CDR_PURGING

alter table INCMS.CIN_T_CCN_CDR drop partition TKT_2014_FEB26 update global indexes;

alter table INCMS.CIN_T_CCN_CDR drop partition TKT_2014_FEB27 update global indexes;

alter table INCMS.CIN_T_CCN_CDR drop partition TKT_2014_FEB28 update global indexes;

Recent Posts

select * from ( select SQL_ID, sum(CPU_TIME_DELTA), sum(DISK_READS_DELTA), count(*) from DBA_HIST_SQLSTAT a, dba_hist_snapshot s where...

select open_mode from v$database; spool rp.st select 'alter tablespace ' || tablespace_name || ' add tempfile ' || '''' || file_name...

Steps to configure 11G Physical Standby Database Oracle rdbms software is installed with one database(proddb) following is details...