Re: Create Views

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 06 Mar 2000 18:02:16 +0800
Message-ID: <38C38228.6842@yahoo.com>

topinoz_at_my-deja.com wrote:
>
> Hello to everybody
>
> I have some problems creating VIEW:
>
> I'm using Oracle 8 and with 2 tables A and B from 2 different DB,
> trying to execute these SQL statements:
>
> CREATE VIEW AX (NOME, COGNOME, PROVINCIA_NASCITA) AS
> SELECT A.NOME, A.COGNOME, B.PROVINCIA_NASCITA FROM A, B WHERE
> A.ID_RELAZIONE = B.ID_RELAZIONE ;
>
> but the system say "Table or View not exists" under the B of "FROM
> A,B", it does not see the table B.
>
> But if I try the statement:
>
> SELECT * FROM B;
>
> I see the table.
>
> What's wrong?
>
> I also have try to create a synonym for B but nothing.
>
> TNX to all that help me.
>
> Pietro
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Have a look at:

http://govt.oracle.com/~tkyte/Misc/RolesAndProcedures.html --

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Mon Mar 06 2000 - 04:02:16 CST