When i export data from 9i db,get error message as follow:
exp-00008: ORACLE error 1422 encountered
ORA-01422: exact fetch return 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
Can anyone tell me how to fix this problem?
Thanks for all.
If your SYS.DUAL table has more then one row, the easiest way to repair it is as follows. Do NOT skip any steps. and do the following steps as a dba user. Do NOT drop the DUAL table, you will be in a world of hurt if you do.
delete from sys.dual;
insert into sys.dual values('X');
Now that it is corrected, NEVER,NEVER,NEVER mess with any table in SYS.
You do not need a parachute to skydive. You only need a parachute to skydive twice.