QUESTION: Can we manually remove the OL_DATAxxx tables within Oracle SQL Plus?
SCENARIO: Presently ETL Runtime process is not transferring data from ODS to Datamart. There's already
an open ticket at Genesys Tech Support for this.
PROBLEM:
But the consequence of the problem with ETL Runtime is that once the ODS data hasn't been moved to Datamart since July 4th (and we hadn't never set the dropTRansferredTables parameter in trans_xxx.property files because we were still testing and validating the reports), the ODS tablespace grew and now it run out of space (we don't have more space on the disk to increase the size of the tablespace). I was wondering if there is any way to delete old data from ODS (OL_DATAxxx tables) that were already moved to Datamart. Can we manually remove the OL_DATAxxx tables within Oracle SQL Plus?
Note: I set the dropTRansferredTables parameter in trans_only.property file
and nothing happened.
Environment:
Product Version Status Operating System & Release
======= ======= ====== ==========================
TServer 6.1.0 Active HPUX B.11.11 U 9000/800
Call Center Analyzer 6.1.0 Active HPUX B.11.11 U 9000/800
Call Center Pulse Supervisor 6.1.0 Active NT Workstation 4
CPD Server 6.5.0 Active NT Server 4
Outbound Contatc Server 6.5.1 Active HPUX B.11.11 U 9000/800
StatServer 6.1.007.03 Active HPUX B.11.11 U 9000/800
Telephony Environment:
Nortel Meridian 1 Option 81C, Release 25
Nortel Symposium Call Center Server 4.0
