Re: Noob Oracle Question

I've create a new Data File (SNEData), and a new User (SNE), which in turn creates the Schema. [I did this in OEM]

There is another Schema called IFSAPP within the IFSP database. How do I structure a simple SQL statement in SNE that queries IFSAPP [via SQL Developer]?

Eg.

Select * from IFSAPP.MyTable;

I'm getting a 'SQL command not properly ended' error...

Do I need to create a Database Link; I assume I dont since the two Schema are within the same DB.

Any ideas?

Thanks Received on Thu Aug 17 2006 - 11:05:14 CDT