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: 4516
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: ORA-01940: cannot drop a user that is currently connected
Next Topic: index in oracle
Goto Forum:

Current Time: Sun Aug 20 10:31:10 CDT 2017

Total time taken to generate the page: 0.00884 seconds