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.
