Re: Export Problems

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Fri, 25 Jun 2004 23:19:19 +0100
Message-ID: <9q2Dc.254$B2.81@newsfe6-gui.server.ntli.net>

"HARI OM" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0406251411.4d406e1d_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!

take a look at metalink note 243133.1 Received on Fri Jun 25 2004 - 17:19:19 CDT