Home » RDBMS Server » Server Administration » Strange Export Error
Strange Export Error [message #125874] Wed, 29 June 2005 11:42 Go to next message
snagra
Messages: 23
Registered: March 2005
Junior Member
Any idea what this could be caused by ?


Export: Release 10.1.0.4.0 - Production on Wed Jun 29 12:56:53 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.


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

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
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.sc
hema_info_exp
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_AQERROR 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_CALLDEST 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_DEFAULTDEST 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_DESTINATION 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_ERROR 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_LOB 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_ORIGIN 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_PROPAGATOR 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_PUSHED_TRANSACTIONS 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEF$_TEMP$LOB 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table HELP 959 rows exported

Report message to a moderator

Re: Strange Export Error [message #125876 is a reply to message #125874] Wed, 29 June 2005 12:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
some of the DMSYS objects are improperly removed.
Either remove properly ( if you are not using)
or
Install again cleanly (if you are planning to use)

Report message to a moderator

Re: Strange Export Error [message #125877 is a reply to message #125874] Wed, 29 June 2005 12:07 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
If you are talking about the "Exporting questionable statistic" google tells you this:

http://dbasupport.com/oracle/ora10g/globalization02.shtml
and
http://www.lazydba.com/oracle/0__108940.html

among others.

[Updated on: Wed, 29 June 2005 12:08]

Report message to a moderator

Re: Strange Export Error [message #125878 is a reply to message #125877] Wed, 29 June 2005 12:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yea.
questionable statistics thingy is okie.
when export done with statistics=none, these wont popup.
I believe, the OP was looking into

>> PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared

Report message to a moderator

Re: Strange Export Error [message #125880 is a reply to message #125874] Wed, 29 June 2005 12:50 Go to previous message
snagra
Messages: 23
Registered: March 2005
Junior Member
do I need to have DMSYS.DBMS_DM_MODEL_EXP declared? or can I get around it some how?
What effect will it have on my export and will it stop me importing if I ever need to recover a table?

Report message to a moderator

Previous Topic: IMP-00003: ORACLE error 2248 encountered
Next Topic: Not able to open standy database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 05:37:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.