-- #################################################################
--
-- Parameters:
--   1: DB SID
--   2: Owner user
--   3: Owner password
--
-- Usage:
--   sqlplus /nolog @ppb_rollback_dml.sql <ORACLE_SID> <PRDUCT_USER> <PRODUCT_PASS>
--
--#################################################################
--
--
SET DEFINE ON
--
DEFINE db_sid  = &1
DEFINE own_usr = &2
DEFINE own_pwd = &3
--
CONNECT &own_usr/&own_pwd@&db_sid
--
--
SET FEEDBACK OFF
--
SET FEEDBACK ON
--
--
DROP TABLE CDRFILE;

ALTER TABLE CDRCALL DROP COLUMN SRV_SEQ, SESSION_ID, TRS_ID;
ALTER TABLE CDRCALLFRAGM DROP COLUMN SRV_SEQ, SESSION_ID, TRS_ID;
ALTER TABLE CDRPPR DROP COLUMN SRV_SEQ, SESSION_ID, TRS_ID;
ALTER TABLE CDRPPRFRAGM DROP COLUMN SRV_SEQ, SESSION_ID, TRS_ID;
ALTER TABLE CDRMMS DROP COLUMN SRV_SEQ, SESSION_ID, TRS_ID;
ALTER TABLE CDRSMS DROP COLUMN SRV_SEQ, SESSION_ID, TRS_ID;

--
PROMPT
PROMPT *** Rollback has been completed ***
PROMPT
--
EXIT;
-------------------------------------------------
--