Clean Up the Oracle Database - Intergraph Smart Instrumentation - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2018 (12.0)
  1. In SQL Plus, use your Oracle System account logon information and provide the Host String value to connect to the target Oracle database.

    SHARED Tip The Host String value is the Oracle server name defined in the [DATABASE] section of the Intools.ini file, as the Server parameter value.

  2. Do the following to display Smart Instrumentation schema tablespace names, which you must remember and delete after deleting the schemas themselves.

    1. 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).

    2. 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).

      SHARED Tip 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.

  3. Delete the INTOOLS_ENGINEER role using the command

    DROP ROLE INTOOLS_ENGINEER CASCADE;

  4. Delete the Smart Instrumentation schemas (database users) one by one using the commands

    DROP USER INTOOLS_LOGIN CASCADE;
    DROP USER IN_DBAMN CASCADE;

    SHARED Tip Substitute the default Admin schema logon name IN_DBAMN with your value.

  5. 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;

    SHARED Tip Use your tablespace names in place of the default names displayed in the SQL commands.