Home » RDBMS Server » Server Administration » View Oracle User Objects (table, synonyms etc) (Oracle ,10g, Windows Xp)
View Oracle User Objects (table, synonyms etc) [message #289558] Mon, 24 December 2007 00:36 Go to next message
azamkhan
Messages: 548
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?
Re: View Oracle User Objects (table, synonyms etc) [message #289559 is a reply to message #289558] Mon, 24 December 2007 00:39 Go to previous messageGo to next message
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
Re: View Oracle User Objects (table, synonyms etc) [message #289561 is a reply to message #289558] Mon, 24 December 2007 00:57 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
What if the OP forgets the name of v$fixed and dict views too? Laughing
Re: View Oracle User Objects (table, synonyms etc) [message #289563 is a reply to message #289561] Mon, 24 December 2007 01:11 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Smile
but atleast he need to know two views instead of more than 100s of views as DBA.
Previous Topic: how to extract db data to flat file
Next Topic: backup concept(user managed)
Goto Forum:
  


Current Time: Fri Dec 02 20:50:38 CST 2016

Total time taken to generate the page: 0.13961 seconds