RE: exporting MDSYS schema from an Oracle Apps 11i database?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 05 Mar 2001 16:37:31 -0800
Message-ID: <F001.002C448F.20010305163026@fatcity.com>

>-----Original Message-----
>From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com]
>Sent: lundi, 5. mars 2001 15:46
>
>Does anyone know if MDSYS is in fact the Oracle 8i Spatial functions
> user and/or how I could create that user and its objects in an
>Oracle 8i database (said database being created to server as an Oracle
> Apps 11i repository)?

I apologize to the list for my stupid questions. I found the answer in Oracle8i Spatial User's Guide and Reference Release 8.1.5
A67295-01
Appendix B
<<B.2 Installation Details
To install Spatial, the script catmd.sql in the ORACLE_HOME/md/admin directory must be run as user mdsys. The mdsys user should be created with the set of privileges listed in ORACLE_HOME/MD/mdprivs.sql, and with both default and temporary tablespace.

Installation of Spatial requires that the COMPATIBLE init.ora parameter is set to 8.1.0.0.0 or higher. This is required for the creation and definition of Spatial index types and operators. Thus, if the database was created with a compatibility parameter value of 8.0.x.x.x, the DBA must shut down the database and restart with COMPATIBLE=8.1.x.x.x.>>

P.S. the manual has a typo. instead of "ORACLE_HOME/MD/mdprivs.sql" it should say "ORACLE_HOME/md/admin/mdprivs.sql".

---

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Mon Mar 05 2001 - 18:37:31 CST