Home » RDBMS Server » Server Utilities » problem with export
problem with export [message #278350] Sat, 03 November 2007 03:49 Go to next message
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 #278422 is a reply to message #278350] Sun, 04 November 2007 01:08 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
wud u plz the status of the views..whether they r invalid or not??
Re: problem with export [message #278425 is a reply to message #278422] Sun, 04 November 2007 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ONCE AGAIN DON'T USE IM SPEAK.

Regards
Michel
Re: problem with export [message #335086 is a reply to message #278425] Sun, 20 July 2008 22:43 Go to previous message
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
Previous Topic: SQL Loader Log File Creation
Next Topic: imp/exp in oracle8
Goto Forum:
  


Current Time: Sat Dec 03 09:54:36 CST 2016

Total time taken to generate the page: 0.18372 seconds