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

2001-03-05 Thread Jacques Kilchoer
Title: RE: exporting MDSYS schema from an Oracle Apps 11i database? >-Original Message- >From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] >Sent: lundi, 5. mars 2001 11:51 > >I know that there is an MDSYS schema (see results of SQL below) but export says >

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

2001-03-05 Thread Jacques Kilchoer
Title: RE: exporting MDSYS schema from an Oracle Apps 11i database? >-Original Message- >From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] >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

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

2001-03-06 Thread Tim Sawmiller
Somewhere in the rdbms stuff (I can't remember where anymore) there should be a script to create MDSYS and ORDSYS. These should be used instead of exp/imp. >>> [EMAIL PROTECTED] 03/05/01 06:46PM >>> >-Original Message- >From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] >Sent: lundi, 5.

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

2001-03-06 Thread Ron Rogers
MDSYS and the others were created automatically when I created a 8.1.7 rel 3 database on NT 4.0 sp6a. The user MDsys ownes the tables: CS_SRS, MD$ (various) OGIS_GEOMERTY_COLUMNS, OGIS_SPATIAL_REFERENCE_SYSTEMS, SDO_GEOM_METADATA_TABLE, SDO_INDEX_METADATA_TABLE, USER_CS_SYS I have not done any t

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

2001-03-06 Thread Jacques Kilchoer
Title: RE: exporting MDSYS schema from an Oracle Apps 11i database? > -Original Message- > From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] > Sent: mardi, 6. mars 2001 07:25 > > Somewhere in the rdbms stuff (I can't remember where anymore) > there should be a