Quote:
Originally posted by RAFF
Hello!
The following are the answer of your queries
ORACLE RELEASE : ORACLE 9.2
QUERY1: NO ROWS SELECCTED
QUERY2: SYSTEM
QUERY3: NO ROWS SELECCTED
QUERY4: ORA-00904: "NAME": invalid identifier.
QUERY5:
OWNER OBJECT_TYPE
------------------------------ ------------------
SYS SYNONYM
SYSTEM TABLE
PLS TABLE
Beside i laso want to let you know that the queue table DEF$_AQCALL basiscally exists on SYSTEM schema. But some how due to wrong import of the databse, i m getting it in this TEST schema. Have to remove it.
Thanks
RAFF
Don't u see from the results that its in SYSTEM schema and not in TEST schema....