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;

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