LISTAGG

http://www.oracle-developer.net/display.php?id=515


Pivots rows into comma separated list

Linux Command stack search

esc-p or !command or !?command

eg.
!ls
!?ls
esc-p followed by ls

DBMS_MVIEW.REFRESH - atomic_refresh

One of the thing that is not well documented about setting atomic_refresh => false
is it cause the refresh to truncate rather than delete from the Mview. The result can be a much quicker refresh.

How to change properties/attributes of partition table?

ALTER TABLE scott.part_table MODIFY DEFAULT ATTRIBUTES TABLESPACE NEW_TABLESPACE;

ALTER INDEX scott.local_index MODIFY DEFAULT ATTRIBUTES TABLESPACE NEW_TABLESPACE_IDX;

ACL lists

All you need to know is  here

http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_networkacl_adm.htm

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" )%>"

11g incremental stats


BEGIN
  DBMS_STATS.SET_TABLE_PREFS ('SCHEMA', 'TABLE_NAME, 'INCREMENTAL','TRUE');

 --Gather Stats.
   DBMS_STATS.
   gather_table_stats (
      ownname            => 'SCHEMA',
      tabname            => 'TABLE_NAME',
      estimate_percent   => DBMS_STATS.AUTO_SAMPLE_SIZE,
      method_opt         => 'for all indexed columns size auto',
      DEGREE             => 4,
      CASCADE            => TRUE);

END;