| DBMS_RULE_EXP_RULES and DBMS_METADATA problem in export. [message #71687] |
Wed, 18 December 2002 16:07  |
Nilu
Messages: 5
Registered: December 2002
|
Junior Member |
|
|
following problem is facing by one of my friend.
he said
-----------
These are the messages i am getting , while taking export. Help me immediately. I have tried running catalog and catproc ,standard.sql etc. But still i am getting
the message.
G:DUMP>exp sys/sys@sdev file=G:DUMPSDEV_DEC17_11pm.DMP log=G:DUMPSDEV_DE
C17_11pm.LOG owner=sdev
Export: Release 9.2.0.1.0 - Production on Thu Dec 19 00:19:01 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 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.sc
hema_info_exp
. exporting foreign function library names for user SDEV
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SDEV
About to export SDEV'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
Thanks in Advance.,
|
|
|
|
|
|
| Re: DBMS_RULE_EXP_RULES and DBMS_METADATA problem in export. [message #71695 is a reply to message #71687] |
Fri, 20 December 2002 08:18  |
Nilu
Messages: 5
Registered: December 2002
|
Junior Member |
|
|
Thank you very much for your response. We could able to solve this problem. This problem is due to DUAL TABLE of system.
It is fetching more than one row from the table . If you are using any select statement from dual in procedures or packages ,
it is returning more than one row. We donot know how two rows are inserted in dual table . Hence we have truncated the DUAL TABLE and
inserted one dummy value like'x'.
insert into dual values('x');
Immediately the problem solved .we could able take the export . Because the procedures used in export packages are using select statements
from dual .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
