truncate table BATCH_RUN_ASSET;
truncate table BATCH_RUN_RM_PTFL_UPLOAD;
truncate table BATCH_RUN_RM_RISK_ANALYSIS;
truncate table BATCH_RUN_STATE_LOG;
truncate table BRS_ASSET;
truncate table BRS_INSTRUMENT_TYPE;
truncate table BRS_PV_CALC_LINKING_LOG;
truncate table BRS_PV_RESULTS_LOG_DETAIL;
truncate table BRS_PV_RESULTS_LOG;
truncate table BRS_RM_PTFL_UPLOAD_LOG;
truncate table BRS_RM_PTFL_UPLOAD_RESULT_LOG;
truncate table BRS_RM_RISK_ANALYSIS_LOG;
truncate table BRS_RM_RISK_ANALYSIS_R_LOG;
truncate table JOB_BATCH_RUN_STAGE;
truncate table RM_COMM_FAULT_LOG;
truncate table RM_COMM_LOG;
truncate table BATCH_RUN_STATE;
truncate table JOB_BATCH_RUN_STAGE;
truncate table BATCH_RUN;
truncate table CHC_STATS_POS_LOAD;
truncate table CHC_STATS_POS_UNPROCESSED;
truncate table CHRON_BBUNIQUE_REF_FORWARD;
truncate table CHRON_BBUNIQUE_REF_FUTURE;
truncate table CHRON_BBUNIQUE_REF_INT_RATE;
truncate table CHRON_BBUNIQUE_REF_OPTION;
truncate table CHRON_COR_MATRIX;
truncate table CHRON_COUNTER_PARTY;
truncate table CHRON_EWA_BATCH_RESULT;
truncate table CHRON_EWA_GTAA_CALC;
truncate table CHRON_EWA_STD_DEV;
truncate table CHRON_EWA_STD_DEV_SETTING;
truncate table CHRON_EWA_STD_DEV_TYPE;
truncate table CHRON_EWA_STD_DEV_VAL;
truncate table CHRON_EXCLUDED_PTFL_ACCT;
truncate table CHRON_EXCLUDED_SECURITY;
truncate table CHRON_FUND_MANAGER;
truncate table CHRON_FUTURE_TICKER_XREF;
truncate table CHRON_HIERARCHY_NODE;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table CHRON_INST;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_FOREX;
truncate table CHRON_INST_FUTURE;
truncate table CHRON_INST_INDEX;
truncate table CHRON_INST_INFRA;
truncate table CHRON_INST_IR;
truncate table CHRON_INST_MONEY;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_POOLED_FUND;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table CHRON_INST_REAL_ESTATE;
truncate table CHRON_INST_REPO;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_VAR_SWAP;
truncate table CHRON_ISSUER;
truncate table CHRON_LEGAL_ENTITY;
truncate table CHRON_LEGAL_ENTITY_GC;
truncate table CHRON_LOOKTHROUGH_MAPPING;
truncate table CHRON_MR_COUNTERPARTY_XREF;
truncate table CHRON_MUREX_PTFL_ACCT_XREF;
truncate table CHRON_NOTIONAL;
truncate table CHRON_NOTIONAL_META;
truncate table CHRON_PNL_ROLLUP;
truncate table CHRON_POS_PNL;
truncate table CHRON_PTFL_ACCT_PNL;
truncate table CHRON_PNL;
truncate table CHRON_PNL_LOAD;
truncate table CHRON_PNL_ROLLUP;
truncate table CHRON_POS_PNL;
truncate table CHRON_PTFL_ACCT_PNL;
truncate table CHRON_PNL;
truncate table CHRON_PNL_LOAD;
truncate table CHRON_PNL_META;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PNL;
truncate table CHRON_POS_PV;
truncate table CHRON_POS_STRESS_PNL;
truncate table CHRON_PTFL_ACCT_PNL;
truncate table CHRON_PTFL_ACCT_PV;
truncate table CHRON_PTFL_ACCT_STRESS_PNL;
truncate table CHRON_PTFL_ACCT;
truncate table CHRON_PTFL_ACCT_PNL;
truncate table CHRON_PTFL_ACCT_PV;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table CHRON_PTFL_ACCT_STRESS_PNL;
truncate table CHRON_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_PV_CALC_LOAD;
truncate table CHRON_PV_CALC;
truncate table CHRON_PV_CALC_LOAD;
truncate table CHRON_PV_META;
truncate table CHRON_REPORT_ASSET;
truncate table CHRON_REPORT;
truncate table CHRON_REPORT_CONFIG;
truncate table CHRON_REPORT_CONFIG_SET;
truncate table CHRON_RM_EXCL_RULE;
truncate table CHRON_RM_INSTR_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table CHRON_SEC_EXCHANGE;
truncate table CHRON_STATIC_DATA_ASSET;
truncate table CHRON_STD_DEV_CACHE;
truncate table CHRON_STD_DEV;
truncate table CHRON_STD_DEV_CACHE;
truncate table CHRON_STRAT;
truncate table CHRON_STRAT_SUB_1;
truncate table CHRON_STRAT_SUB_2;
truncate table CHRON_STRAT_SUB_3;
truncate table CHRON_STRAT_TYPE;
truncate table CHRON_POS_STRESS_PNL;
truncate table CHRON_PTFL_ACCT_STRESS_PNL;
truncate table CHRON_STRESS_PNL_ROLLUP;
truncate table CHRON_STRESS_PNL;
truncate table CHRON_STRESS_PNL_LOAD;
truncate table CHRON_POS_STRESS_PNL;
truncate table CHRON_PTFL_ACCT_STRESS_PNL;
truncate table CHRON_STRESS_PNL_ROLLUP;
truncate table CHRON_STRESS_PNL;
truncate table CHRON_STRESS_PNL_LOAD;
truncate table CHRON_STRESS_PNL_META;
truncate table CHRON_USER_BATCH_RESULT;
truncate table CHRON_USER_GTAA_CALC;
truncate table CHRON_USER_STD_DEV;
truncate table CHRON_VAR_CACHE;
truncate table CHRON_VAR;
truncate table CHRON_VAR_CACHE;
truncate table HC_MUREX_BONDSWAP;
truncate table HC_MUREX_CDO;
truncate table HC_MUREX_CDS;
truncate table HC_MUREX_COMMODITY;
truncate table HC_MUREX_DERIVATIVES;
truncate table HC_MUREX_EQUITYSWAP;
truncate table HC_MUREX_FUTURES;
truncate table HC_MUREX_IRS;
truncate table HC_RM_BOND;
truncate table HC_RM_BONDFUTURE;
truncate table HC_RM_CASH;
truncate table HC_RM_CASHFLOW;
truncate table HC_RM_CDS;
truncate table HC_RM_CDX;
truncate table HC_RM_COMMODITYFUTURE;
truncate table HC_RM_CONVERTIBLEBOND;
truncate table HC_RM_CREDITDEFAULTSWAP;
truncate table HC_RM_EQUITY;
truncate table HC_RM_EQUITYFUTURE;
truncate table HC_RM_EQUITYOPTION;
truncate table HC_RM_EQUITYSWAPPLUS;
truncate table HC_RM_EQUITYVARSWAP;
truncate table HC_RM_EXCHANGETRADED;
truncate table HC_RM_FRN;
truncate table HC_RM_FXFORWARD;
truncate table HC_RM_FXOPTION;
truncate table HC_RM_GENERICBOND;
truncate table HC_RM_INFLATIONINDEXEDBOND;
truncate table HC_RM_INTERESTRATEFUTURE;
truncate table HC_RM_MANDATORYCONVERTIBLEBOND;
truncate table HC_RM_MONEYMARKET;
truncate table HC_RM_MORTGAGEBACKEDSECURITY;
truncate table HC_RM_OPTIONPLUS;
truncate table HC_RM_REPOPLUS;
truncate table HC_RM_SWAP;
truncate table HC_RM_SYNTHETICCDO;
truncate table HC_RM_UKINDEXLINEDGILT;
truncate table HC_SIMCORP_HOLDINGS;
truncate table JOB_REPORT_GENERATE;
truncate table JOB_RISK_BATCH_RUN;
truncate table CHRON_REPORT_ASSET;
truncate table CHRON_REPORT;
truncate table CHRON_REPORT_ASSET;
truncate table CHRON_REPORT_CONFIG;
truncate table CHRON_REPORT_CONFIG_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table JOB_REPORT_GENERATE;
truncate table CHRON_REPORT_CONFIG;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_REPORT_CONFIG;
truncate table CHRON_REPORT_CONFIG_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_REPORT_CONFIG_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_RPT_CFG_RPT_CFG_SET;
truncate table OVERRIDE_META;
truncate table CHRON_BBUNIQUE_REF_FORWARD;
truncate table SNAP_BBUNIQUE_REF_FORWARD;
truncate table CHRON_BBUNIQUE_REF_FORWARD;
truncate table SNAP_BBUNIQUE_REF_FORWARD;
truncate table CHRON_BBUNIQUE_REF_FUTURE;
truncate table SNAP_BBUNIQUE_REF_FUTURE;
truncate table CHRON_BBUNIQUE_REF_FUTURE;
truncate table SNAP_BBUNIQUE_REF_FUTURE;
truncate table CHRON_BBUNIQUE_REF_INT_RATE;
truncate table SNAP_BBUNIQUE_REF_INT_RATE;
truncate table CHRON_BBUNIQUE_REF_INT_RATE;
truncate table SNAP_BBUNIQUE_REF_INT_RATE;
truncate table CHRON_BBUNIQUE_REF_OPTION;
truncate table SNAP_BBUNIQUE_REF_OPTION;
truncate table CHRON_BBUNIQUE_REF_OPTION;
truncate table SNAP_BBUNIQUE_REF_OPTION;
truncate table CHRON_COR_MATRIX;
truncate table SNAP_COR_MATRIX_ELMNT;
truncate table SNAP_COR_MATRIX;
truncate table CHRON_COR_MATRIX;
truncate table SNAP_COR_MATRIX_ELMNT;
truncate table SNAP_COR_MATRIX;
truncate table CHRON_COUNTER_PARTY;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_SWAP;
truncate table SNAP_COUNTER_PARTY;
truncate table CHRON_COUNTER_PARTY;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_SWAP;
truncate table SNAP_COUNTER_PARTY;
truncate table CHRON_EWA_GTAA_CALC;
truncate table SNAP_EWA_GTAA_CALC;
truncate table CHRON_EWA_GTAA_CALC;
truncate table SNAP_EWA_GTAA_CALC;
truncate table CHRON_EWA_GTAA_CALC;
truncate table CHRON_EWA_STD_DEV;
truncate table SNAP_EWA_STD_DEV_VAL;
truncate table SNAP_EWA_STD_DEV;
truncate table CHRON_EWA_GTAA_CALC;
truncate table CHRON_EWA_STD_DEV;
truncate table SNAP_EWA_STD_DEV_VAL;
truncate table SNAP_EWA_STD_DEV;
truncate table SNAP_EWA_STD_DEV_SETTING_VAL;
truncate table SNAP_EWA_STD_DEV_SETTING;
truncate table SNAP_EWA_STD_DEV_SETTING_VAL;
truncate table SNAP_EWA_STD_DEV_SETTING;
truncate table SNAP_EWA_STD_DEV_SETTING_VAL;
truncate table SNAP_EWA_STD_DEV_SETTING_VAL;
truncate table SNAP_EWA_STD_DEV_TYPE;
truncate table SNAP_EWA_STD_DEV_TYPE;
truncate table CHRON_EXCLUDED_PTFL_ACCT;
truncate table SNAP_EXCLUDED_PTFL_ACCT;
truncate table CHRON_EXCLUDED_PTFL_ACCT;
truncate table SNAP_EXCLUDED_PTFL_ACCT;
truncate table CHRON_EXCLUDED_SECURITY;
truncate table SNAP_EXCLUDED_SECURITY;
truncate table CHRON_EXCLUDED_SECURITY;
truncate table SNAP_EXCLUDED_SECURITY;
truncate table CHRON_FUND_MANAGER;
truncate table CHRON_INST_POOLED_FUND;
truncate table SNAP_FUND_MANAGER;
truncate table CHRON_FUND_MANAGER;
truncate table CHRON_INST_POOLED_FUND;
truncate table SNAP_FUND_MANAGER;
truncate table CHRON_FUTURE_TICKER_XREF;
truncate table SNAP_FUTURE_TICKER_XREF;
truncate table CHRON_FUTURE_TICKER_XREF;
truncate table SNAP_FUTURE_TICKER_XREF;
truncate table CHRON_HIERARCHY_NODE;
truncate table CHRON_HIERARCHY_NODE;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table SNAP_HIERARCHY_NODE;
truncate table CHRON_HIERARCHY_NODE;
truncate table CHRON_HIERARCHY_NODE;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table SNAP_HIERARCHY_NODE;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table SNAP_H_NODE_PTFL_ACCT;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table SNAP_H_NODE_PTFL_ACCT;
truncate table CHRON_INST;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_FOREX;
truncate table CHRON_INST_FUTURE;
truncate table CHRON_INST_INDEX;
truncate table CHRON_INST_INFRA;
truncate table CHRON_INST_IR;
truncate table CHRON_INST_MONEY;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_POOLED_FUND;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table CHRON_INST_REAL_ESTATE;
truncate table CHRON_INST_REPO;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_VAR_SWAP;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table SNAP_INST;
truncate table CHRON_INST;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table CHRON_INST_FOREX;
truncate table CHRON_INST_FUTURE;
truncate table CHRON_INST_INDEX;
truncate table CHRON_INST_INFRA;
truncate table CHRON_INST_IR;
truncate table CHRON_INST_MONEY;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_POOLED_FUND;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table CHRON_INST_REAL_ESTATE;
truncate table CHRON_INST_REPO;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_SWAP;
truncate table CHRON_INST_VAR_SWAP;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table SNAP_INST;
truncate table CHRON_INST_BOND;
truncate table SNAP_INST_BOND;
truncate table CHRON_INST_BOND;
truncate table SNAP_INST_BOND;
truncate table CHRON_INST_BOND_SWAP;
truncate table SNAP_INST_BOND_SWAP;
truncate table CHRON_INST_BOND_SWAP;
truncate table SNAP_INST_BOND_SWAP;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table SNAP_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table SNAP_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table SNAP_INST_CRED_DEF_PROD;
truncate table CHRON_INST_CRED_DEF_PROD;
truncate table SNAP_INST_CRED_DEF_PROD;
truncate table CHRON_INST_FOREX;
truncate table SNAP_INST_FOREX;
truncate table CHRON_INST_FOREX;
truncate table SNAP_INST_FOREX;
truncate table CHRON_INST_FUTURE;
truncate table SNAP_INST_FUTURE;
truncate table CHRON_INST_FUTURE;
truncate table SNAP_INST_FUTURE;
truncate table CHRON_INST_INDEX;
truncate table SNAP_INST_INDEX;
truncate table CHRON_INST_INDEX;
truncate table SNAP_INST_INDEX;
truncate table CHRON_INST_INFRA;
truncate table SNAP_INST_INFRA;
truncate table CHRON_INST_INFRA;
truncate table SNAP_INST_INFRA;
truncate table CHRON_INST_IR;
truncate table SNAP_INST_IR;
truncate table CHRON_INST_IR;
truncate table SNAP_INST_IR;
truncate table CHRON_INST_MONEY;
truncate table SNAP_INST_MONEY;
truncate table CHRON_INST_MONEY;
truncate table SNAP_INST_MONEY;
truncate table CHRON_INST_OPTION;
truncate table SNAP_INST_OPTION;
truncate table CHRON_INST_OPTION;
truncate table SNAP_INST_OPTION;
truncate table CHRON_INST_POOLED_FUND;
truncate table SNAP_INST_POOLED_FUND;
truncate table CHRON_INST_POOLED_FUND;
truncate table SNAP_INST_POOLED_FUND;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table SNAP_INST_PUBLIC_FUND;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table SNAP_INST_PUBLIC_FUND;
truncate table CHRON_INST_REAL_ESTATE;
truncate table SNAP_INST_REAL_ESTATE;
truncate table CHRON_INST_REAL_ESTATE;
truncate table SNAP_INST_REAL_ESTATE;
truncate table CHRON_INST_REPO;
truncate table SNAP_INST_REPO;
truncate table CHRON_INST_REPO;
truncate table SNAP_INST_REPO;
truncate table CHRON_INST_STOCK;
truncate table SNAP_INST_STOCK;
truncate table CHRON_INST_STOCK;
truncate table SNAP_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table SNAP_INST_STOCK_PREFERRED;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table SNAP_INST_STOCK_PREFERRED;
truncate table CHRON_INST_SWAP;
truncate table SNAP_INST_SWAP;
truncate table CHRON_INST_SWAP;
truncate table SNAP_INST_SWAP;
truncate table CHRON_INST_VAR_SWAP;
truncate table SNAP_INST_VAR_SWAP;
truncate table CHRON_INST_VAR_SWAP;
truncate table SNAP_INST_VAR_SWAP;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_INFRA;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table CHRON_INST_REPO;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_ISSUER;
truncate table SNAP_ISSUER;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_INFRA;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_PUBLIC_FUND;
truncate table CHRON_INST_REPO;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_ISSUER;
truncate table SNAP_ISSUER;
truncate table CHRON_COUNTER_PARTY;
truncate table CHRON_FUND_MANAGER;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_FOREX;
truncate table CHRON_INST_VAR_SWAP;
truncate table CHRON_ISSUER;
truncate table CHRON_LEGAL_ENTITY;
truncate table CHRON_LEGAL_ENTITY_GC;
truncate table SNAP_LEGAL_ENTITY;
truncate table CHRON_COUNTER_PARTY;
truncate table CHRON_FUND_MANAGER;
truncate table CHRON_INST_BOND_SWAP;
truncate table CHRON_INST_COMMODITY_FORWARD;
truncate table CHRON_INST_FOREX;
truncate table CHRON_INST_VAR_SWAP;
truncate table CHRON_ISSUER;
truncate table CHRON_LEGAL_ENTITY;
truncate table CHRON_LEGAL_ENTITY_GC;
truncate table SNAP_LEGAL_ENTITY;
truncate table CHRON_LEGAL_ENTITY_GC;
truncate table SNAP_LEGAL_ENTITY_GC;
truncate table CHRON_LEGAL_ENTITY_GC;
truncate table SNAP_LEGAL_ENTITY_GC;
truncate table CHRON_LOOKTHROUGH_MAPPING;
truncate table SNAP_LOOKTHROUGH_MAPPING;
truncate table CHRON_LOOKTHROUGH_MAPPING;
truncate table SNAP_LOOKTHROUGH_MAPPING;
truncate table CHRON_MR_COUNTERPARTY_XREF;
truncate table SNAP_MR_COUNTERPARTY_XREF;
truncate table CHRON_MR_COUNTERPARTY_XREF;
truncate table SNAP_MR_COUNTERPARTY_XREF;
truncate table CHRON_MUREX_PTFL_ACCT_XREF;
truncate table SNAP_MUREX_PTFL_ACCT_XREF;
truncate table CHRON_MUREX_PTFL_ACCT_XREF;
truncate table SNAP_MUREX_PTFL_ACCT_XREF;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table SNAP_POS;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table SNAP_POS;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table CHRON_PTFL_ACCT_PNL;
truncate table CHRON_PTFL_ACCT_PV;
truncate table CHRON_PTFL_ACCT_STRESS_PNL;
truncate table CHRON_PTFL_ACCT;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table SNAP_PTFL_ACCT;
truncate table CHRON_H_NODE_PTFL_ACCT;
truncate table CHRON_POS_NOTIONAL;
truncate table CHRON_POS_PV;
truncate table CHRON_PV_CALC;
truncate table CHRON_POS;
truncate table CHRON_PTFL_ACCT_PNL;
truncate table CHRON_PTFL_ACCT_PV;
truncate table CHRON_PTFL_ACCT_STRESS_PNL;
truncate table CHRON_PTFL_ACCT;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table SNAP_PTFL_ACCT;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table SNAP_PTFL_ACCT_STRAT_SUB_3;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table SNAP_PTFL_ACCT_STRAT_SUB_3;
truncate table CHRON_REPORT_CONFIG;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_REPORT_CONFIG;
truncate table CHRON_REPORT_CONFIG;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_REPORT_CONFIG;
truncate table CHRON_REPORT_CONFIG_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_REPORT_CONFIG_SET;
truncate table CHRON_REPORT_CONFIG_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_REPORT_CONFIG_SET;
truncate table CHRON_RM_EXCL_RULE;
truncate table SNAP_RM_EXCL_RULE;
truncate table CHRON_RM_EXCL_RULE;
truncate table SNAP_RM_EXCL_RULE;
truncate table CHRON_RM_INSTR_SET;
truncate table SNAP_RM_INSTR_SET;
truncate table CHRON_RM_INSTR_SET;
truncate table SNAP_RM_INSTR_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_RPT_CFG_RPT_CFG_SET;
truncate table CHRON_RPT_CFG_RPT_CFG_SET;
truncate table SNAP_RPT_CFG_RPT_CFG_SET;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_FUTURE;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_SEC_EXCHANGE;
truncate table SNAP_SEC_EXCHANGE;
truncate table CHRON_INST_BOND;
truncate table CHRON_INST_FUTURE;
truncate table CHRON_INST_OPTION;
truncate table CHRON_INST_STOCK;
truncate table CHRON_INST_STOCK_PREFERRED;
truncate table CHRON_SEC_EXCHANGE;
truncate table SNAP_SEC_EXCHANGE;
truncate table CHRON_STATIC_DATA_ASSET;
truncate table SNAP_STATIC_DATA_ASSET;
truncate table CHRON_STATIC_DATA_ASSET;
truncate table SNAP_STATIC_DATA_ASSET;
truncate table CHRON_STRAT;
truncate table CHRON_STRAT_SUB_1;
truncate table SNAP_STRAT;
truncate table CHRON_STRAT;
truncate table CHRON_STRAT_SUB_1;
truncate table SNAP_STRAT;
truncate table CHRON_STRAT_SUB_1;
truncate table CHRON_STRAT_SUB_2;
truncate table SNAP_STRAT_SUB_1;
truncate table CHRON_STRAT_SUB_1;
truncate table CHRON_STRAT_SUB_2;
truncate table SNAP_STRAT_SUB_1;
truncate table CHRON_STRAT_SUB_2;
truncate table CHRON_STRAT_SUB_3;
truncate table SNAP_STRAT_SUB_2;
truncate table CHRON_STRAT_SUB_2;
truncate table CHRON_STRAT_SUB_3;
truncate table SNAP_STRAT_SUB_2;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table CHRON_STRAT_SUB_3;
truncate table SNAP_STRAT_SUB_3;
truncate table CHRON_PTFL_ACCT_STRAT_SUB_3;
truncate table CHRON_STRAT_SUB_3;
truncate table SNAP_STRAT_SUB_3;
truncate table CHRON_STRAT_TYPE;
truncate table SNAP_STRAT_TYPE;
truncate table CHRON_STRAT_TYPE;
truncate table SNAP_STRAT_TYPE;
truncate table CHRON_USER_GTAA_CALC;
truncate table SNAP_USER_GTAA_CALC;
truncate table CHRON_USER_GTAA_CALC;
truncate table SNAP_USER_GTAA_CALC;
truncate table CHRON_USER_GTAA_CALC;
truncate table CHRON_USER_STD_DEV;
truncate table SNAP_USER_STD_DEV_VAL;
truncate table SNAP_USER_STD_DEV;
truncate table CHRON_USER_GTAA_CALC;
truncate table CHRON_USER_STD_DEV;
truncate table SNAP_USER_STD_DEV_VAL;
truncate table SNAP_USER_STD_DEV;
truncate table SNAP_USER_STD_DEV_VAL;
truncate table SNAP_USER_STD_DEV_VAL;
truncate table CHRON;
truncate table INST_BOND;
truncate table INST_BOND;
truncate table INST_BOND_SWAP;
truncate table INST_BOND_SWAP;
truncate table INST_BOND_SWAP;
truncate table INST_COMMODITY_FORWARD;
truncate table INST_CRED_DEF_PROD;
truncate table INST_CRED_DEF_PROD;
truncate table INST_FUTURE;
truncate table INST_INDEX;
truncate table INST_INFRA;
truncate table INST_IR;
truncate table INST_MONEY;
truncate table INST_OPTION;
truncate table INST_OPTION;
truncate table INST_POOLED_FUND;
truncate table INST_PUBLIC_FUND;
truncate table INST_REPO;
truncate table INST_STOCK;
truncate table INST_STOCK_PREFERRED;
truncate table INST_SWAP;
truncate table INST_SWAP;
truncate table INST_SWAP;
truncate table INST_VAR_SWAP;
truncate table INST_forex;
truncate table INST_repo;
truncate table INST_real_estate;
truncate table POS;
truncate table INST;

insert into inst (inst_id, inst_type, short_desc, lk, source_system_key, cppib_security_id)
values (-1, ‘FIXED_INTEREST_RATE’, ‘Fixed interest rate’, ‘FIXED_INTEREST_RATE’, ‘FIXED_INTEREST_RATE’, null);
select ‘alter table ‘||table_name||’ disable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type = ‘R’;

select ‘alter table ‘||table_name||’ enable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type = ‘R’;

 

 

Leave a Reply