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

Report message to a moderator

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: 826
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)

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:15:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.