Carl's Oracle

Carl's thougts about the Oracle Database Server

2006/1/14

CBO - Cardinality oh Cardinaltiy!

Tags:
@ 01:28 PM (31 months, 18 days ago)

Hi, Applications do not live as data islands. The more an application integrates data of other applications of a company the better is. Even we live in the Year 2006 the most common way to import data from other systems is the flat file. Via SQL*LOADER the data is loaded into an Import table which is a table presentation of the flat file. Then the Processing of data starts to apply the imported data to the applications tables.

Read the rest of this entry ... (875 words left)

2006/1/6

PL/SQL - flexible deployment of database objects

Tags:
@ 07:29 AM (31 months, 26 days ago)

Hi, unfortunately in the current project the customer has on development site databases on Windows Server but on production site databases on AIX based UNIX servers. Usually this is no problem when the Oracle versions are the same. Some Oracle Database objects are still OS dependent like the directory objects. Oracle Directory objects are an encapsulation of the real directories in the file system of the OS. Grants on Oracle directory objects controls the user access.

Read the rest of this entry ... (459 words left)