INTERFACE FAILURE CALL
OdiStartScen "-SCEN_NAME=INTERFACE_FAILURE_DW_ACTION" "-GLOBAL.g_mod_name=<%=odiRef.getPrevStepLog("STEP_NAME")%>" "-GLOBAL.g_session_no=<%=odiRef.getPrevStepLog("SESS_NO")%>" "-GLOBAL.g_step_no=<%=odiRef.getPrevStepLog("NNO")%>" "-GLOBAL.g_extract_start_date=<%=odiRef.getSysDate("dd/MM/yyyy")%>" "-GLOBAL.g_extract_end_date=<%=odiRef.getSysDate("dd/MM/yyyy")%>"

The default Tablespace for an index is held in  sys.dba_part_indexes

Tom kyte on caching

caching

Export using an external table


unloading data using external tables

Functions prevent queries going parallel , in-built functions do not.

select is_number(col1) from table;

Will NOTgo parallel is the is_number function is a user written function, whereas

select regexp_like(col1, '^-?[[:digit:],.]*$') then 'Numeric' else 'Non-Numeric' ed

from table

WILL GO Parallel

Linux 32 bit or 64 bit?

file /usr/bin/file

compression - order by matters

You get much better compress if you order the data as you compress
use this sql to work out the best order by clause


SELECT
', ' || dtc.column_name
, dtc.num_distinct
, dtc.avg_col_len
FROM dba_tab_cols dtc
WHERE dtc.owner = 'OWNER'
AND dtc.table_name = 'TABLE_TO_COMRESS'
ORDER BY
dtc.num_distinct
,dtc.avg_col_len DESC;