OraFAQ Forum: Server Administration » diff between view and synonym

Home » RDBMS Server » Server Administration » diff between view and synonym

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

diff between view and synonym [message #54313]

Mon, 11 November 2002 06:16

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

Hi Evrybody
Please tell me the difference between view and synonym. What is the need of synonym. Is it occupy disk space.

Report message to a moderator

Re: diff between view and synonym [message #54314 is a reply to message #54313]

Mon, 11 November 2002 06:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

VIEW:

1. is a restricted / unrestricted portion or whole
   table.
2. View is defined using a query.
   every time, u call the view, the query is executed.
   does not require any storage.
   you can have a view on a table or view.
   view behaves exactly the same as a table.

SYNONYM:

1. another Name for a table, which may be public ( access
   to all or private.

Report message to a moderator

Re: diff between view and synonym [message #54329 is a reply to message #54313]

Mon, 11 November 2002 16:47

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

The synonym allows the schema.object syntax in a query to be substituted to only object specification. It does shield the owner of the object and the users doesn't have to know in each schema the real object is't. You can move the object from schema to schema without to change your application code, export from user to another user too.

All you have to do is to re-create the public synonym.

And yes, it does occupy one row in data dictionary table, nothing else.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

The latest Oracle DBA forums

Report message to a moderator

Previous Topic:	Re: ocp . - dumps,braindumps,kits,cbt,tbt,sts......
Next Topic:	Difference between 8i and 9I

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:40:13 CDT 2024