problem with export [message #278350] |
Sat, 03 November 2007 03:49 |
sd_md_rizwan@yahoo.com
Messages: 37 Registered: September 2007 Location: Saudi Arabia
|
Member |
|
|
Hi this is rizwan
and iam getting the problem while iam exporting the whole database , i use to do the same thing before and it was comming
nice but today i got this error please help me iam giving all the situation
i connected to system/manager@qlty
sql>ho
H:\oracle\product\10.1.0\db_1\BIN>EXP
Export: Release 10.1.0.2.0 - Production on Sat Nov 3 11:42:27 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: SYSTEM/MANAGER@QLTY
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > E:\RIZWAN\BACKUP-20071103\QLTY_EDB-20071103.DMP
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 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
. exporting cluster definitions
EXP-00056: ORACLE error 904 encountered
ORA-00904: "XMLFORMAT"."CREATEFORMAT2": invalid identifier
ORA-06512: at "SYS.DBMS_METADATA", line 1511
ORA-06512: at "SYS.DBMS_METADATA", line 1548
ORA-06512: at "SYS.DBMS_METADATA", line 1864
ORA-06512: at "SYS.DBMS_METADATA", line 3707
ORA-06512: at "SYS.DBMS_METADATA", line 3689
ORA-06512: at line 1
EXP-00056: ORACLE error 904 encountered
ORA-00904: "XMLFORMAT"."CREATEFORMAT2": invalid identifier
ORA-06512: at "SYS.DBMS_METADATA", line 1511
ORA-06512: at "SYS.DBMS_METADATA", line 1548
ORA-06512: at "SYS.DBMS_METADATA", line 1864
ORA-06512: at "SYS.DBMS_METADATA", line 3707
ORA-06512: at "SYS.DBMS_METADATA", line 3689
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
H:\oracle\product\10.1.0\db_1\BIN>
what to do go get out of this
|
|
|
|
|
Re: problem with export [message #335086 is a reply to message #278425] |
Sun, 20 July 2008 22:43 |
mastersimran
Messages: 1 Registered: April 2008
|
Junior Member |
|
|
Rizwan
I think you've imported the previous version of dmp file without migrating it. thats why it occurred problems. one thing you can do, (If this is your useful) you can convert all the ddl into script file, and the data also. then create a new user and run the script. i think the problem will solved. if it occurs again then run the catexp.sql or catalog.sql
|
|
|