Export Problems
From: HARI OM <hari_om_at_hotmail.com>
Date: 25 Jun 2004 15:11:26 -0700
Message-ID: <d1d5ebe4.0406251411.499f3307_at_posting.google.com>
I would like to EXPORT the DATABASE INSTANCE Named "GATES" and execute following:
./exp
Username: system
Password: ****
Export File: expgates.dat
Users
Grants: yes
Table Data: yes
Compress Extents: yes
Exporet done is US7ASCII and AL16UTF16 NCHAR. Server uses WE8ISO8859P1
User to be exported: BILL
......
EXP-00000: ,Expoert terminated unsuccessfully
Date: 25 Jun 2004 15:11:26 -0700
Message-ID: <d1d5ebe4.0406251411.499f3307_at_posting.google.com>
I would like to EXPORT the DATABASE INSTANCE Named "GATES" and execute following:
./exp
Username: system
Password: ****
Export File: expgates.dat
Users
Grants: yes
Table Data: yes
Compress Extents: yes
Exporet done is US7ASCII and AL16UTF16 NCHAR. Server uses WE8ISO8859P1
User to be exported: BILL
......
and my output console shows following:
EXP-00091: Exporting questionable staticis
. exporting synonuyms
. exporting triggers
EXP-00056: ORACLE error 6550 encountered ORA-06550: Line 1, column 26: PLS-00201: identified 'XDB.DBMS_XDBUTIL_INT' must be declared....
EXP-00000: ,Expoert terminated unsuccessfully
Any hints or suggestions or related information on above errors would be greatly appreciated.
I read the EXPORT Oracle DOcs and it said to FIRST RUN "catexp.sql" OR
"catalog.sql" scripts.....I executed those but still in vain....
wonder why..... It also says to check the privileges....and the user
"SYSTEM" had "EXP_FULL_DATABASE" role enabled
Thanks! Received on Sat Jun 26 2004 - 00:11:26 CEST