|
-
Hi .. again
As i have mentioned earlier DBA_OBJECTS table returns me a record >> containing the followinf information
OWNER : TEST
OBJECT_NAME : DEF$_AQCALL
OBJECT TYPE = TABLE.
i dont find any information about QUEUE in it . But when i issue
DROP TABLE DEF$_AQCALL
return me back with an eeor and to use
DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the table .. when i us this same procdure .. it returns me back .. that TEST.DEF$_AQCALL does not exist.
I m really stuck in it .. if i m trying to create a queue table in the test schema .. so that i can delete it afterwards .. return me back with the message that
object by the name DEF$_AQCALL already exist in the test scehema. isnt it confusing .. help me out ..
thanks
RAFF
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|