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 |