RE: difference between create synonym and create view

Well, your friend is half right.  Both statements only save information
into the data dictionary, but that's about where it ends.  Create
synonym simply allows you to replace 'bbb.bbb' with 'aaa' without
causing any other activity, where as create view causes 'bbb.bbb. With
'from (<sql for aaa>)' and then the execution of said sql which can then
cause a lot of resource consumption.


Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Monday, December 21, 2009 9:55 AM
To: oracle-db-l@xxxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: difference between create synonym and create view

Does anyone know what is different between following two statement:

   1. create view aaa as select * from bbb.bbb;

   2. create synonym from aaa;

My friend told me "create synonym" will save resource than 'create
view".  Is it true?

Thanks. 


      

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: