1. Applications Installation Guide for UNIX with Oracle
  2. Dropping Oracle Tablespaces and Indexes

Dropping Oracle Tablespaces and Indexes

This section lists the Oracle tablespaces and indexes that must be manually dropped by a DBA. This is the list of databases that were created by the JD Edwards EnterpriseOne Tools Release 9.2 Installation of the Platform Pack on your Enterprise or Database Server for your JD Edwards EnterpriseOne installation, or from a previous JD Edwards EnterpriseOne installation.

By design, these database components are not automatically removed by the JD Edwards EnterpriseOne uninstallation program. You should have a DBA for your RDBMS manually remove any unused items specifically listed in the table below.

Note:

When removing Oracle, you must drop the tablespace first and then drop the indexes.

Tip:

The JD Edwards EnterpriseOne installer delivers sample scripts which you can use as examples of how to drop the tablespaces. You should examine and edit these to suit your needs with the understanding that they have not been delivered 'ready to run '. You should pay attention to environment variables and arguments the scripts are expecting. Your DBA may prefer to drop the tablespaces themselves instead of using scripts.

Sample drop scripts are located in the ORCL directory under the JD Edwards EnterpriseOne installation directory (E920):

CallDrop.sh

RunDropOracleDB.sh

drop_db.bat

You should also be aware that when you run the JD Edwards EnterpriseOne uninstaller, the directory structure containing sample drop scripts is deleted.

JD Edwards EnterpriseOne Component

Oracle Index Name (suffixed by the capital letter "I")

Oracle Tablespace Name (suffixed by the capital letter "T")

Foundation

SVM920I

SY920I

OL920I

DD920I

SVM920T

SY920T

OL920T

DD920T

Production

PD920I

PRODDTAI

PRODCTLI

PD920T

PRODDTAT

PRODCTLT

Note: For your installation, the proddta and prodctl tablespaces and indexes may be needed for a previous release.

Pristine

PS920I

PS920DTAI

PS920CTLI

PS920T

PS920DTAT

PS920CTLT

Development

DV920I

TESTDTAI

TESTCTLI

DV920T

TESTDTAT

TESTCTLT

Note: For your installation, the testdta and testctl tablespaces and indexes may be needed for a previous release.

Prototype

PY920I

CRPDTAI

CRPCTLI

PY920T

CRPDTAT

CRPCTLT

Note: For your installation, the crpdta and crpdctl tablespaces and indexes may be needed for a previous release.