Seek The Sun Slowly

I have given a seminar in Special Topics In Database Systems Course at University. It was in Turkish. I showed how can a person use Oracle Business Intelligence techniques. My Agenda is below:
•İş Zekası
•Data WareHouse
•ETL
•External Tables
•SQl*Loader
•Özet Tabloları(MVs)
•BitMap Indeksler
•Parale[......]

Read More…

A few days ago one of my colleagues has asked me about a problem that does not allow to open database. Somehow one of datafiles of database has been removed. When we analyze, realize that the they do not need “the datafile” anymore. So we removed the datafile.
I printed out below which w[......]

Read More…

A general programming practise to store old snapshot of data with versioning.
For instance currency table may be updated three or more times a day.
When application developers need currency info, first they have to get last version of curency rates for given day.
For future analysis, old currencies [......]

Read More…

Parallel processing is to run the same process-usally a heavy process- simultaneously. It is called Parallel computing in computer science. Main idea of Parallel computing is to get faster responses. Wikipedi describes as
 

 
“Parallel computing is the simultaneous execution of the same t[......]

Read More…

Gelişen ve değişen çevre koşulları, sınırların kalkması ile küreselleşen dünya, farklı pazarlama ve ar-ge(araştırma geliştirme) yöntemleri “veri”nin değil “bilgi”nin önemini her geçen gün daha da artacak şekilde ortaya koymaktadır. İnternetin yaygınlaşması ve kolaylaşması ar-ge ekiplerinin “bilgi”ye[......]

Read More…

Today I have struggled a problem while importing a dump file to oracle 9.2.0.7 database. The problem was about “ORA-01658: unable to create INITIAL extent for segment in tablespace”. I investigated the problem and find a solution…
One tablespace was created with following command:
[......]

Read More…

Today I have struggled a problem while importing a dump file to oracle 9.2.0.7 database. The problem was about “ORA-25153: Temporary Tablespace is Empty”. I investigated the problem and find a solution…
Accidentally creating two temporary tablespace(TEMP and TMP), making first one [......]

Read More…

Today I have struggled a problem while importing a dump file to oracle 9.2.0.7 database. The problem was about “ORA-01552: cannot use system rollback segment for non-system tablespace”. I investigated the problem and find a solution…
SQL> show parameter undo_management;
NAME    [......]

Read More…

Sometimes you need to copy table across databases/schemas. Oracle provides some utilities for them. We can summarize them as follow:
Trasportable Tablespaces
IMPD/EXPD utilities(Import/Export data pump)
IMP/EXP(Import/Export)
SQL*Loader
CTAS(Create Table As Select) with dblinks
SQL*Plus COPY command[......]

Read More…

In Oracle you can wrap your source code, packages, functions e.g., with built-in wrap utility. Securing source code is an important responsibility for enterprise projects. It is possible to compile a wrapped package. It can not possible to see a wrapped source code with selecting all_source view or [......]

Read More…