Home » Infrastructure » Linux » export oracle user
export oracle user [message #245914] Tue, 19 June 2007 04:33 Go to next message
shanthis
Messages: 6
Registered: June 2007
Location: Chennai
Junior Member
my server' OS is redhat linux enterprener version 3. I have created one oracle database. i am unable to export particular user using the utility EXP command. i am getting the following error at the time of export the user ops$analysis.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Productio
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.STANDARD", line 628
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 129
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP
RULES.schema_info_exp
. exporting foreign function library names for user OPS$ANALYSIS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user OPS$ANALYSIS
About to export OPS$ANALYSIS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_METADATA", line 474
ORA-06512: at "SYS.DBMS_METADATA", line 497
ORA-06512: at "SYS.DBMS_METADATA", line 649
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
30,1 Bot


how can i solve this problem?








Re: export oracle user [message #245954 is a reply to message #245914] Tue, 19 June 2007 07:18 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Try to recreate tables/views need for export/import by running under SYS script $ORACLE_HOME/rdbms/admin/catexp.sql.
Re: export oracle user [message #246008 is a reply to message #245954] Tue, 19 June 2007 10:00 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
try this option
Statistics=none
Previous Topic: Error installing the asm package
Next Topic: Deleting Old Archive logs
Goto Forum:
  


Current Time: Fri Dec 02 13:55:47 CST 2016

Total time taken to generate the page: 0.09785 seconds