about object naming conventions

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 22 Apr 2003 11:40:18 +0100
Message-ID: <3ea51c1c$0$29709$ed9e5944@reading.news.pipex.net>

FYI Should you manage to create two objects of different types, but the same name, then exports in 9.2 may terminate unsuccessfully with

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 52
ORA-06512: at line 1

This appears to occur only

If XDB is installed and
an object has the same name as a trigger.

Received on Tue Apr 22 2003 - 05:40:18 CDT