viiews across schemas?

From: Douglas Nichols <dnichols_at_fhcrc.org>
Date: Tue, 12 Oct 1999 17:28:39 +0000
Message-ID: <38036FC7.2B36E7D0@fhcrc.org>

I have been trying to create a view from schemaX in schemaY but cannot do it.
create view schemaY.viewX as select * from schemaX.tableX;

ERROR at line 1:
ORA-00942: table or view does not exist

But I can create a table from schemaX in schemaY then create a view. create table schemaY.tableX as select * from schemaX.tableX; create view schemaY.viewX as select * from schemaY.tableX;

Can I reference a table across a schema with a view? --
Cheers, dn

Douglas Nichols                              dnichols_at_fhcrc.org
---------------------------------------------------------------
National Wilms Tumor Study Group                   206.667.4283

Seattle, WA Received on Tue Oct 12 1999 - 12:28:39 CDT