Clone database for new environment

Clone database for new environment:

Scripts to be executed once you copy data from other environment. 

–CORE
alter session set current_schema=atgdb_user_core;

delete from dms_msg_properties;
delete from dms_msg;
delete from dms_topic_entry;
delete from dms_topic_sub;
delete from dms_topic;
delete from dms_queue_entry;
delete from dms_queue_recv;
delete from dms_queue;
delete from dms_client;
delete from dms_limbo_delay;
delete from dms_limbo_ptypes;
delete from dms_limbo_props;
delete from dms_limbo_body;
delete from dms_limbo_replyto;
delete from dms_limbo_msg;
delete from dms_limbo;

truncate table dss_server_id;
truncate table das_gsa_subscriber;
delete from rout_engine;
delete from ROUT_HOST_RSRVD_LPS;
delete from rout_host;
delete from rout_host_inf;
delete from rout_env;

commit;

–CORE_PRV
alter session set current_schema=atgdb_user_core_prv;

delete from dms_msg_properties;
delete from dms_msg;
delete from dms_topic_entry;
delete from dms_topic_sub;
delete from dms_topic;
delete from dms_queue_entry;
delete from dms_queue_recv;
delete from dms_queue;
delete from dms_client;
delete from dms_limbo_delay;
delete from dms_limbo_ptypes;
delete from dms_limbo_props;
delete from dms_limbo_body;
delete from dms_limbo_replyto;
delete from dms_limbo_msg;
delete from dms_limbo;

truncate table dss_server_id;
truncate table das_gsa_subscriber;
delete from rout_engine;
delete from rout_host;
delete from rout_host_inf;
delete from rout_env;

commit;

–PUB
alter session set current_schema=atgdb_user_pub;

delete from dms_msg_properties;
delete from dms_msg;
delete from dms_topic_entry;
delete from dms_topic_sub;
delete from dms_topic;
delete from dms_queue_entry;
delete from dms_queue_recv;
delete from dms_queue;
delete from dms_client;
delete from dms_limbo_delay;
delete from dms_limbo_ptypes;
delete from dms_limbo_props;
delete from dms_limbo_body;
delete from dms_limbo_replyto;
delete from dms_limbo_msg;
delete from dms_limbo;

delete from epub_agent_trnprt;
delete from epub_tr_dest;
delete from epub_tr_agents;
delete from epub_princ_asset;
delete from epub_includ_asset;
delete from epub_agent;

delete from epub_wf_server_id;
delete from epub_coll_workflow;
delete from epub_workflow_info;
delete from dsi_server_id;
delete from dss_server_id;
delete from das_gsa_subscriber;

delete from epub_ind_workflow;
delete from epub_topology;
delete from epub_tl_targets;
delete from epub_target;

commit;

–AGENT
alter session set current_schema=atgdb_user_agent;

delete from dms_msg_properties;
delete from dms_msg;
delete from dms_topic_entry;
delete from dms_topic_sub;
delete from dms_topic;
delete from dms_queue_entry;
delete from dms_queue_recv;
delete from dms_queue;
delete from dms_client;
delete from dms_limbo_delay;
delete from dms_limbo_ptypes;
delete from dms_limbo_props;
delete from dms_limbo_body;
delete from dms_limbo_replyto;
delete from dms_limbo_msg;
delete from dms_limbo;

truncate table dsi_server_id;
truncate table dss_server_id;
truncate table das_gsa_subscriber;
truncate table epub_wf_server_id;

commit;

Used when Dynamo Application server was used :

delete from das_cluster_name;

delete from das_sds;