|
-
Hi
Thanks for the prompt response.....
The ouput is as follows:
SQL> select * from dba_objects where OBJECT_NAME='DBMS_REGISTRY';
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SYS
DBMS_REGISTRY
897 PACKAGE
06-MAY-08 21-MAY-08 2008-05-06:07:29:16 VALID N N N
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SYS
DBMS_REGISTRY
898 PACKAGE BODY
06-MAY-08 06-MAY-08 2008-05-06:07:29:17 VALID N N N
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
PUBLIC
DBMS_REGISTRY
7237 SYNONYM
06-MAY-08 06-MAY-08 2008-05-06:07:29:19 VALID N N N
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
|