Home » SQL & PL/SQL » SQL & PL/SQL » synonym
synonym [message #245422] Sun, 17 June 2007 00:32 Go to next message
mkumar26
Messages: 3
Registered: June 2007
Junior Member
hi,

i have a doubt about synonyms...

if we create a synonym occupy space or not.......

bcoz synonyms using only alter name only.....




plz help me out
Re: synonym [message #245425 is a reply to message #245422] Sun, 17 June 2007 00:49 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
A synonym doesn't occupy any space by itself. However, when it is created, a row is inserted into a dictionary table. So, there is a minimal space overhead.
Previous Topic: oracle select results in excelsheet
Next Topic: delete with variables
Goto Forum:
  


Current Time: Sat Dec 10 09:01:18 CST 2016

Total time taken to generate the page: 0.08994 seconds