Home » RDBMS Server » Server Utilities » 10g_export_errors (Oracle 10.2.0.3.0 on AIX 5.3)
10g_export_errors [message #317713] Fri, 02 May 2008 13:23 Go to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Hi DBAs,

I'm trying to export a schema from my 10g RAC database, but i'm getting a whole lot of errors. Infact, the same script i used to export the same schema from a 9i database successfully is what i'm using, as shown below:

> exp system/xxxxxx@labtest1 file=/u02/epiphany_sys.dmp owner=epiphany_sys_meta_data log=/u02/epiphany_sys.log statistics=none buffer=80000 consistent=y

The errors i'm getting are:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYS.LT_EXPORT_PKG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LT_EXPORT_PKG"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
. exporting foreign function library names for user EPIPHANY_SYS_META_DATA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user EPIPHANY_SYS_META_DATA
About to export EPIPHANY_SYS_META_DATA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

Does anyone have an idea of what's going on? Your help will be highly appreciated.

Thanks,

divroro12
Re: 10g_export_errors [message #317716 is a reply to message #317713] Fri, 02 May 2008 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/48144/0/
unwilling or incapable of using Search or GOOGLE?
Re: 10g_export_errors [message #318055 is a reply to message #317713] Mon, 05 May 2008 08:34 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Hi anacedent,

You know u're under no obligation to respond to a thread. Rather than be intriguing & post solutions wh' do not resolve the issue at stake, u better stay silent. I did my research & GOOGLING before posting this thread.

The solution u provided didn't help me.

Thanks,

divroro12
Re: 10g_export_errors [message #318056 is a reply to message #317713] Mon, 05 May 2008 08:38 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW posting guidelines as stated above


'u' is not a member of this forum.
Re: 10g_export_errors [message #318064 is a reply to message #318055] Mon, 05 May 2008 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
divroro12 wrote on Mon, 05 May 2008 15:34
Hi anacedent,

You know u're under no obligation to respond to a thread. Rather than be intriguing & post solutions wh' do not resolve the issue at stake, u better stay silent. I did my research & GOOGLING before posting this thread.

The solution u provided didn't help me.

Thanks,

divroro12

Can you translate this in proper english, I don't understand it.

Regards
Michel

Re: 10g_export_errors [message #318072 is a reply to message #317713] Mon, 05 May 2008 09:07 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
The very first instruction to be followed before posting in this forum states

.Be polite, which i think some of us aren't!

u = you
u're = you are
wh' = which

If you can replace these English words with the short forms i used earlier, then the English language in that posting can be as clean, clear & understandable as it can be...

Thanks,

divroro12
Re: 10g_export_errors [message #318076 is a reply to message #318072] Mon, 05 May 2008 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If you can replace these English words with the short forms

They are not short form they are 11 year old language.
When looking for a professional I always have a look at what the candidate posted in Internet. Sure, such a language in a professional forum is not a good sign for me to hire.

Regards
Michel
Re: 10g_export_errors [message #318085 is a reply to message #317713] Mon, 05 May 2008 09:26 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
OK Michel, now i know i shouldn't use such language here. I apologise for doing that earlier. I don't think it should be any reason to be picked on, or for anybody else to be inpolite. let's not forget the main issue at stake here & concentrate on the secondary. I was posting a request, not applying for a job.

Thanks,

Divine
Re: 10g_export_errors [message #419539 is a reply to message #317713] Mon, 24 August 2009 02:23 Go to previous message
rajeshnaik
Messages: 1
Registered: August 2009
Junior Member
whether the link finally worked ???
Previous Topic: IMPDP ignore=y
Next Topic: EXP:00056 oracle error 1578 encountered
Goto Forum:
  


Current Time: Sat Dec 03 17:54:30 CST 2016

Total time taken to generate the page: 0.11344 seconds