Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
An 'Invisable' object exists
Message
 
 
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00393396
Message ID:
00393408
Vues:
17
>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_name

You may have to enclose your object type in quotes since it has a space.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform