| export oracle user [message #245914] |
Tue, 19 June 2007 04:33  |
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?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
