OraFAQ Forum: Server Administration » View Oracle User Objects (table, synonyms etc)

Home » RDBMS Server » Server Administration » View Oracle User Objects (table, synonyms etc) (Oracle ,10g, Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

View Oracle User Objects (table, synonyms etc) [message #289558]

Mon, 24 December 2007 00:36

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Hi,

I cann't remember the view name to display a particular user's objects in Oracle 10g. Can any one tell me the view name?

Report message to a moderator

Re: View Oracle User Objects (table, synonyms etc) [message #289559 is a reply to message #289558]

Mon, 24 December 2007 00:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Did you try with USER_OBJECTS views.
anyway in future if you forget view name then just query below two views for v$ or DBA view and table.

1. select name from v$fixed where name like 'V$%OBJECT%';
2. select table_name from dict where table_name like 'DBA%OBJECT%';

hope this help

Report message to a moderator