Create or Replace View

Is there any way to create a view based on a table in another schema? I can select from lms_data.class, but:

Create View testview as
Select * from lms_data.class;

returns an error, table class not found. I tried using a synonym and got the same result.

Thanks for any help. Received on Thu Jul 01 2004 - 19:11:27 CDT