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

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: 4507
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: Sun Apr 30 13:58:06 CDT 2017

Total time taken to generate the page: 0.12686 seconds