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.shRunDropOracleDB.shdrop_db.batYou 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.