Skip to Content
avatar image
Former Member

Compliance Calibrator - Table Cleanup Script

CC/RAR Experts,

We received a script from SAP over a year ago to cleanup/delete our CC5.2 tables (below). We have now upgraded to CC5.3 in a sandbox and are looking to start fresh to build our development box. Can anyone confirm if this script is still valid for CC(RAR)5.3 or is there an updated version of this cleanup script?

Thanks in advance,

Jes

--

SPOOL C:\DATA_CLEANUP.TXT

prompt Delete system specific rules in Action Rule Table

delete from <SCHEMA>.VIRSA_CC_ACTRULE

where vsyskey = '&1';

prompt Delete all System specific Alert details

delete from <SCHEMA>.VIRSA_CC_ALLASTRUN

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_ALLISTDTL

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_ALTCDLOG

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_AUTHMAP

where vsyskey = '&1';

prompt Delete system specific rules in Critical Action Rule Table

delete from <SCHEMA>.virsa_cc_cract

where vsyskey = '&1';

delete from <SCHEMA>.virsa_cc_cractt

where vsyskey = '&1';

prompt Delete system specific rules in Critical Permission Rule Table

delete from <SCHEMA>.virsa_cc_crprm

where vsyskey = '&1';

prompt Delete system specific rules in Critical Profile Table

delete from <SCHEMA>.virsa_cc_crprof

where vsyskey = '&1';

delete from <SCHEMA>.virsa_cc_crproft

where vsyskey = '&1';

prompt Delete system specific rules in Critical Role Table

delete from <SCHEMA>.virsa_cc_crrole

where vsyskey = '&1';

delete from <SCHEMA>.virsa_cc_crrolet

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_dataexd

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_fldmap

where vsyskey = '&1';

prompt Delete system specific rules in Function Action Table

delete from <SCHEMA>.virsa_cc_funcact

where vsyskey = '&1';

prompt Delete system specific rules in Function Permission Table

delete from <SCHEMA>.virsa_cc_funcprm

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_funcsys

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_lastrun

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_lsysgrp

where vsyskey = '&1';

prompt Delete system specific rules in Org User Mapping Table

delete from <SCHEMA>.virsa_cc_orgusers

where vsyskey = '&1';

prompt Delete system specific rules in Permission Rule Table

delete from <SCHEMA>.virsa_cc_prmrule

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_supp_det

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_supp_hdr

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_supp_text

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_syscract

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_syshmap

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_sysrule

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_syssapobj

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_sysusr

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_textkey

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_usrmap

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_xsrulemap

where vsyskey = '&1';

delete from <SCHEMA>.VIRSA_CC_xsysgrp

where vsyskey = '&1';

prompt Delete System details

delete from <SCHEMA>.virsa_cc_system

where vsyskey = '&1';

delete from <SCHEMA>.virsa_cc_systemc

where vsyskey = '&1';

delete from <SCHEMA>.virsa_cc_systemt

where vsyskey = '&1';

commit;

prompt Truncating VIRSA_CC_GENOBJ Table

truncate table <SCHEMA>.virsa_cc_genobj DROP STORAGE;

prompt Truncating VIRSA_CC_GENOBJT Table

truncate table <SCHEMA>.virsa_cc_genobj DROP STORAGE;

prompt Truncating VIRSA_CC_GENUSR Table

truncate table <SCHEMA>.virsa_cc_genusr DROP STORAGE;

prompt Truncating VIRSA_CC_GENACT Table

truncate table <SCHEMA>.virsa_cc_genact DROP STORAGE;

prompt Truncating VIRSA_CC_GENPRM Table

truncate table <SCHEMA>.virsa_cc_genprm DROP STORAGE;

prompt Truncating VIRSA_CC_GPRMLIST Table

truncate table <SCHEMA>.virsa_cc_genobj DROP STORAGE;

prompt Truncating VIRSA_CC_SYSUSR Table

truncate table <SCHEMA>.virsa_cc_sysusr DROP STORAGE;

prompt Truncating VIRSA_CC_ACTVL Table

truncate table <SCHEMA>.virsa_cc_ACTVL DROP STORAGE;

prompt Truncating VIRSA_CC_PRMVL Table

truncate table <SCHEMA>.virsa_cc_PRMVL DROP STORAGE;

prompt Truncating VIRSA_CC_CRACTVL Table

truncate table <SCHEMA>.virsa_cc_CRACTVL DROP STORAGE;

prompt Truncating VIRSA_CC_CRPRMVL Table

truncate table <SCHEMA>.virsa_cc_CRPRMVL DROP STORAGE;

prompt Truncating VIRSA_CC_ROLEVL Table

truncate table <SCHEMA>.virsa_cc_ROLEVL DROP STORAGE;

prompt Truncating VIRSA_CC_CRROLEVL Table

truncate table <SCHEMA>.virsa_cc_CRROLEVL DROP STORAGE;

prompt Truncating Management Tables

truncate table <SCHEMA>.virsa_cc_MGALERTS DROP STORAGE;

truncate table <SCHEMA>.virsa_cc_MGCRTR DROP STORAGE;

truncate table <SCHEMA>.virsa_cc_MGMTBU DROP STORAGE;

truncate table <SCHEMA>.virsa_cc_MGMTTOT DROP STORAGE;

truncate table <SCHEMA>.virsa_cc_MGRISKD DROP STORAGE;

truncate table <SCHEMA>.virsa_cc_MGRISKS DROP STORAGE;

SPOOL OFF

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2008 at 01:16 PM

    Jes-

    Yes, it is the same script. The table names have not changed from 5.2 to 5.3.

    Ankur

    Add comment
    10|10000 characters needed characters exceeded