>I'm moving an Oracle instance from one multi database app to several one databse apps. Somehow, a couple of triggeres wound up in the wrong schema. No sweat, drop trigger yada, create or replace , so on and so forth. No go, object name in use. Try to find it, using several tools, no such object. Query dba_objects, there it is, with an OBJECT_TYPE of NEXT OBJECT. Que?
>What the heck is a NEXT OBJECT and how do I get rid of it?
I obviously have no way of knowing if this will work:
DROP "NEXT OBJECT" object_name;
According to my newly obtained Advanced PL/SQL programming, you can create a user defined object:
Create or Replace TYPE MyType AS OBJECT (....
How a space got in there I do not know.
There is also a DROP TYPE command:
DROP TYPE
schema.type_nameYou may have to enclose your object type in quotes since it has a space.
Mark McCasland
Midlothian, TX USA