Data Warehousing Community Forum
February 08, 2012, 10:41:24 pm

Pages: [1]   Go Down
  Print  
Author Topic: Synonym and its Advantages..?  (Read 3263 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: July 04, 2007, 03:16:46 pm »

Hi,

What is a Synonym?
What is the importance of the Synonym in Oracle? Is this database object occupies any space on DB?

List the advantages of by using synonyms in Oracle?
Logged

Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: July 04, 2007, 04:19:50 pm »

Synonym is an alias for any Table, View, Snap-shot, Sequence, Procedure, Function or Package. Because synonym is simply an alias, it requires no storage other than its definition in the data dictionary.

Advantages of having synonyms -
Synonyms are often used for security and convienience.
for Example, they can do the following things.

  • Mask the name and owner of an object.
  • Provide location transparency for remote objects of a distributed database.
  • Simplify SQL statements for database users.

Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: