Home » RDBMS Server » Security » View sysdba tables (Oracle 11.1.0.7.0,Unix)
View sysdba tables [message #514218] Sat, 02 July 2011 12:39 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



Hi,

How to view sysdba tables in oracle ?

Thanks
Re: View sysdba tables [message #514219 is a reply to message #514218] Sat, 02 July 2011 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How to view sysdba tables in oracle ?
SELECT ....
Re: View sysdba tables [message #514220 is a reply to message #514219] Sat, 02 July 2011 12:44 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Using which data dictionary views i mean?

Re: View sysdba tables [message #514221 is a reply to message #514220] Sat, 02 July 2011 12:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Using which data dictionary views i mean?
any/all of them

when all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm
Re: View sysdba tables [message #514228 is a reply to message #514218] Sat, 02 July 2011 13:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
balaji14 wrote on Sat, 02 July 2011 19:39


Hi,

How to view sysdba tables in oracle ?

Thanks


You don ot use SYS tables, you use dictionary views whose definition is there where I already pointed you several times and you have a summary in DICT view I many times already told to query when you want to find something in the dictionary.

Regards
Michel

Re: View sysdba tables [message #514230 is a reply to message #514228] Sat, 02 July 2011 13:39 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



can you name that dictionary views. i am not aware of that.

Thanks
Re: View sysdba tables [message #514233 is a reply to message #514230] Sat, 02 July 2011 13:56 Go to previous messageGo to next message
thatishari@gmail.com
Messages: 1
Registered: September 2009
Location: Chennai
Junior Member
select TABLE_NAME from dict where TABLE_NAME like '%DBA%'
just execute this query in your database. IT returns approxi 516 rows (as of 10G) from there find wt u required. Before this set the pagesize to 800 using command set pagesize 800 in SQL prompt. Smile
Re: View sysdba tables [message #514237 is a reply to message #514233] Sat, 02 July 2011 14:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
select TABLE_NAME from dict where TABLE_NAME like '%DBA%'

You shot in the void, I already told him many times he can get information on catalog from this... with no success.

Regards
Michel
Re: View sysdba tables [message #514324 is a reply to message #514218] Mon, 04 July 2011 01:00 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=45075&SkipA=0

Why your question is clearer in DBA-Village than here?
Why don't make the effort to post the complete question INCLUDING what you want to do, you'd have more appropriate answers.

Regards
Michel

Previous Topic: How to check grant privs own by user
Next Topic: SQLs to monitor user access
Goto Forum:
  


Current Time: Thu Mar 28 11:02:10 CDT 2024