View Poll Results: Export DB Problem
- Voters
- 0. You may not vote on this poll
-
Error " exporting cluster definitions"
-
EXP-00056: ORACLE error 19206 encountered
-
ORA-19206: Invalid value for query or REF CURSOR parameter
-
ORA-06512: at "SYS.DBMS_METADATA", line 345
-
Export DB Problem
I am facing problem in Export db
Error Details
" exporting cluster definitions
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410"
Please advice.
regs
ramji
-
Connect as sys and run
SQL> @?/rdbms/admin/catmeta.sql
Then do the export again.
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
Re: Export DB Problem
Hi,
XDB installation/dictionary built causes some of the underlying XML views to be INVALID. Here the error occurs when dbms_xmlgen tries to access one those invalid views.
Run the following script that resides under $ORACLE_HOME/rdbms/admin directory after XDB dictionary is built by connecting as user SYS : catmeta.sql (Creates Object Model of Oracle dictionary).After running this script, start the export of database again.
Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com
-
Dear all ,
Thanks for valuable support from team.
i hv run catmeta.sql
the problem get resolved but one worning message has came at every table
" EXP-00091: Exporting questionable statistics.
. . exporting table TOOLTRANS 2 rows exported
Please advise...
Regards
Ramji
-
Originally posted by ramji
Dear all ,
Thanks for valuable support from team.
i hv run catmeta.sql
the problem get resolved but one worning message has came at every table
" EXP-00091: Exporting questionable statistics.
. . exporting table TOOLTRANS 2 rows exported
Please advise...
Regards
Ramji
in the exp command add statistics=none
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
Thanks Problem resolved.
regs
ramji
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|