|
-
select owner,object_name,object_type,status from dba_objects where object_name like 'EMP%'
OWNER OBJECT_NAME OBJECT_TYPE STATUS
PUBLIC EMP_V SYNONYM VALID
BLAKE EMP_V VIEW VALID
SCOTT EMP TABLE VALID
SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME LIKE 'EMP_V%'
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
PUBLIC EMP_V BALKE EMP_V
Last edited by bang_dba; 12-08-2003 at 06:09 AM.
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
|
Reply With Quote