Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> exporting MDSYS schema from an Oracle Apps 11i database?

exporting MDSYS schema from an Oracle Apps 11i database?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 05 Mar 2001 12:54:53 -0800
Message-ID: <F001.002C4013.20010305115031@fatcity.com>

My commander-in-chief has told me that he wants a second copy of a sample Oracle Apps 11i database for use by developpers. "Aye-aye sir" I answered smartly and went on the hunt for an Oracle Apps 11i database that I got copy over. (One person told me "oh yeah, I have an OraApps 11i database here that you can copy, no one's touched it since it was created." I can believe no one has touched it, it won't come up since half the datafiles are missing!?!?!)

Anyhoo, I found one on another platform (since it's a different OS I can't just clone the database by copying over the datafiles) so I decide to use export/import. But I can't export the MDSYS schema. Why is that?

I know that there is an MDSYS schema (see results of SQL below) but export says



About to export specified users ...
EXP-00010: MDSYS is not a valid username

What am I doing wrong and what is this MDSYS schema anyway? Is it a standard schema in an Oracle Apps 11i database? It looks to me like it has objects pertaining to the Oracle 8i Spatial functions/procedures but I've never installed Oracle 8i Spatial so I can't tell for sure.

SQL> run

  1  select a.user_id, b.object_type, count (*)
  2  from dba_users a, dba_objects b
  3  where a.username = 'MDSYS'
  4        and b.owner = a.username
  5* group by a.user_id, b.object_type


   USER_ID OBJECT_TYPE          COUNT(*)

---------- ------------------ ----------

        26 INDEX                      13
        26 INDEXTYPE                   2
        26 LIBRARY                     9
        26 LOB                         2
        26 OPERATOR                   13
        26 PACKAGE                    33
        26 PACKAGE BODY               33
        26 SEQUENCE                    1
        26 TABLE                      14
        26 TRIGGER                     4
        26 TYPE                       20
        26 TYPE BODY                   2
        26 VIEW                       32

13 rows selected. Received on Mon Mar 05 2001 - 14:54:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US