difference between create synonym and create view

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-db-l@xxxxxxxxxxxxxxxxxxxx
  • Date: Mon, 21 Dec 2009 06:55:01 -0800 (PST)

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. 


      

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


Other related posts: