Skip to main content
Support

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;