Home » RDBMS Server » Server Administration » db links,procedures,functions,views,synoyms
db links,procedures,functions,views,synoyms [message #194615] Sat, 23 September 2006 00:49 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
I just want to confirm that
in which tablespace db links,procedures,functions,views,synoyms exits
Do anybody have any idea it,
Although this query is very basic level
but u all won't mind it
Re: db links,procedures,functions,views,synoyms [message #194639 is a reply to message #194615] Sat, 23 September 2006 05:06 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
They are stored in data dictionary. They are not stored like tables/indexes etc -e.g. for views only the definiation is stored in the dictionary)
Re: db links,procedures,functions,views,synoyms [message #194655 is a reply to message #194615] Sat, 23 September 2006 11:09 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Since datadictionary is in system tablespace..it is safe to assume that they will be there in system tablespace.

-Sai Jeedigunta
Previous Topic: How to run the Single Server Multiple instance and Multiple database?
Next Topic: row chaining
Goto Forum:
  


Current Time: Thu Dec 08 10:47:21 CST 2016

Total time taken to generate the page: 0.12838 seconds