Home » RDBMS Server » Server Administration » Datadictionary views
Datadictionary views [message #241933] Thu, 31 May 2007 02:05 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
All,i have a question.

Underlying tables for datadictionary views- Are they all exist in SYS schema ?i did a count(*) and i could see 190 tables under SYS schmea.

Re: Datadictionary views [message #241939 is a reply to message #241933] Thu, 31 May 2007 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes there are all in SYS schema, this is the definition of Oracle dictionary.

Regards
Michel
Re: Datadictionary views [message #241947 is a reply to message #241933] Thu, 31 May 2007 02:53 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks Mike
Re: Datadictionary views [message #242387 is a reply to message #241933] Fri, 01 June 2007 15:13 Go to previous message
Thagor
Messages: 9
Registered: April 2007
Junior Member
must be a very old Oracle version Wink
Oracle 10g has more than 600 X$-tables...
Previous Topic: Re: Temp Tablespace not being flushed automatically
Next Topic: Can I safely disable Resource Manager
Goto Forum:
  


Current Time: Mon Dec 05 08:36:56 CST 2016

Total time taken to generate the page: 0.05020 seconds