-
In SQL Plus, use your Oracle System account logon information and provide the Host String value to connect to the target Oracle database.
The Host String value is the Oracle server name defined in the [DATABASE] section of the Intools.ini file, as the Server parameter value.
-
Do the following to display Smart Instrumentation schema tablespace names, which you must remember and delete after deleting the schemas themselves.
-
To display the Admin data and Temporary tablespace names, run the command
SELECT DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE FROM DBA_USERS WHERE USERNAME ='IN_DBAMN';
Remember the DEFAULT_TABLESPACE name (MAIN_TS by default) and TEMPORARY_TABLESPACE name (TEMP1_TS by default).
-
To display the Admin index tablespace name, run the command
SELECT DISTINCT TABLESPACE_NAME FROM DBA_INDEXES WHERE OWNER='IN_DBAMN';
This command returns both the Admin data and Admin index tablespace names. Remember the Admin index tablespace name (INDEX_MAIN_TS by default).
In these commands, IN_DBAMN is the default Admin schema logon name. If you changed the default name during the database setup, you can retrieve it from the [Database] section of the Intools.ini file, where the Admin schema logon name appears as the LogId parameter value.
-
-
Delete the INTOOLS_ENGINEER role using the command
DROP ROLE INTOOLS_ENGINEER CASCADE;
-
Delete the Smart Instrumentation schemas (database users) one by one using the commands
DROP USER INTOOLS_LOGIN CASCADE;
DROP USER IN_DBAMN CASCADE;Substitute the default Admin schema logon name IN_DBAMN with your value.
-
Delete the Smart Instrumentation tablespaces one by one using the commands
DROP TABLESPACE MAIN_TS INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE INDEX_MAIN_TS INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE TEMP1_TS INCLUDING CONTENTS AND DATAFILES;Use your tablespace names in place of the default names displayed in the SQL commands.