EXP-00056: ORACLE error 1422
encountered
ORA-01422: exact fetch returns more
than requested number of rows
ORA-06512: at
"XDB.DBMS_XDBUTIL_INT", line 55
ORA-06512: at line 1
EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more
than requested number of rows
ORA-06512: at
"XDB.DBMS_XDBUTIL_INT", line 55
ORA-06512: at line 1
EXP-00000: Export terminated
unsuccessfully
Sat Oct 25 12:42:28 IST 2008
SET lines 100
COL OWNER.OBJECT_NAME FORMAT a40
SELECT o1.object_type, o2.object_type, o1.owner||'.'||o1.object_name "OWNER.OBJECT_NAME"
FROM dba_objects o1, dba_objects o2
WHERE o1.object_name=o2.object_name AND ((o1.owner=o2.owner
AND o1.object_type='TRIGGER' AND o2.object_type !='TRIGGER')
OR (o1.owner != o2.owner
AND o1.object_type='TRIGGER' AND o2.object_type='TRIGGER'))
ORDER BY 1,3,2;
OBJECT_TYPE OBJECT_TYPE OWNER.OBJECT_NAME
------------------
------------------ ----------------------------------------
TRIGGER TRIGGER DEMOMGMT.BUGS_TRIGGER
TRIGGER TRIGGER DEMOMGMT.FEEDBACK_TRIGGER
TRIGGER TRIGGER DEMOMGMT.FEEDBACK_TRIGGER
TRIGGER TRIGGER DEMOMGMT.HISTORY_TRIGGER
TRIGGER TRIGGER DEMOMGMT.HISTORY_TRIGGER
TRIGGER SEQUENCE DEMOMGMT.PURCHASE_ID
TRIGGER TRIGGER DEMOMGMT.PURCHASE_ID
TRIGGER TRIGGER DEMOMGMT.REPLY_TRIGGER
TRIGGER TRIGGER DEMOMGMT.REPLY_TRIGGER
TRIGGER TRIGGER DEMOMGMT.TR_CIRCLE_ENDDATE_UPDATE
TRIGGER TRIGGER DEMOMGMT.TR_CSC_ENDDATE_UPDATE
OBJECT_TYPE OBJECT_TYPE OWNER.OBJECT_NAME
------------------
------------------ ----------------------------------------
TRIGGER TRIGGER DEMOMGMT.TR_SSA_ENDDATE_UPDATE
TRIGGER TRIGGER SIMMGMT.BUGS_TRIGGER
TRIGGER TRIGGER SIMMGMT.FEEDBACK_TRIGGER
TRIGGER TRIGGER SIMMGMT.FEEDBACK_TRIGGER
TRIGGER TRIGGER SIMMGMT.HISTORY_TRIGGER
TRIGGER TRIGGER SIMMGMT.HISTORY_TRIGGER
TRIGGER SEQUENCE SIMMGMT.PURCHASE_ID
TRIGGER TRIGGER SIMMGMT.PURCHASE_ID
TRIGGER TRIGGER SIMMGMT.REPLY_TRIGGER
TRIGGER TRIGGER SIMMGMT.REPLY_TRIGGER
TRIGGER TRIGGER SIMMGMT.TR_CIRCLE_ENDDATE_UPDATE
OBJECT_TYPE OBJECT_TYPE OWNER.OBJECT_NAME
------------------
------------------ ----------------------------------------
TRIGGER TRIGGER SIMMGMT.TR_CSC_ENDDATE_UPDATE
TRIGGER TRIGGER SIMMGMT.TR_SSA_ENDDATE_UPDATE
TRIGGER TRIGGER SIM_HELPDESK.FEEDBACK_TRIGGER
TRIGGER TRIGGER SIM_HELPDESK.FEEDBACK_TRIGGER
TRIGGER TRIGGER SIM_HELPDESK.HISTORY_TRIGGER
TRIGGER TRIGGER SIM_HELPDESK.HISTORY_TRIGGER
TRIGGER TRIGGER SIM_HELPDESK.REPLY_TRIGGER
TRIGGER TRIGGER SIM_HELPDESK.REPLY_TRIGGER
30 rows selected.
Step 2:
In the above output with the same name an OBJECT ( SEQUNCE ) and
a trigger is created.
Solution
So recreated the trigger with
different name and then dropped the old trigger
Problem is resolved.