difference between create synonym and create view
From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 21 Dec 2009 06:55:01 -0800 (PST)
Message-ID: <210856.89498.qm_at_web65701.mail.ac4.yahoo.com>
Does anyone know what is different between following two statement:
Date: Mon, 21 Dec 2009 06:55:01 -0800 (PST)
Message-ID: <210856.89498.qm_at_web65701.mail.ac4.yahoo.com>
Does anyone know what is different between following two statement:
- create view aaa as select * from bbb.bbb;
- 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-lReceived on Mon Dec 21 2009 - 08:55:01 CST