dbTalk Databases Forums  

Export Problems

comp.databases.oracle comp.databases.oracle


Discuss Export Problems in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
HARI OM
 
Posts: n/a

Default Export Problems - 06-25-2004 , 05:11 PM






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!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.