KB Article #181843
Wipe database instance for Mserver installation
Problem
If you want to reuse a database instance without dropping the user/instance and recreating for Mserver installation/reinstallation as new.
Resolution
1) in V3.7 you can use the utility "dbtools clean -p <automator db user password>" from the Mserver/bin directory
2) in V4 (also for V3.7), Follow that cleanup queries with !! automator oracle user !! connected to the database to wipe (!!all data will be lost) :
SET ECHO OFF
SET FEED OFF
set pages 1000
set lines 1250
set head off
spool droptables.sql
SELECT 'DROP TABLE "' || TABLE_NAME || '" CASCADE CONSTRAINTS;' FROM user_tables;
spool off
@droptables.sql
DROP SEQUENCE UC_JAR_LST_SEQ;
DROP SEQUENCE UC_UPD_LST_SEQ;
DROP PROCEDURE LISTCONSTRAINTS;
DROP PROCEDURE CHKADDDROPCOL;