Oracle Database Discussions

Hi All,

Oracle version 9.2

I'm trying to retrieve some information from a few tables and import them to Excel. I haven't got much idea about ORACLE, but I'm not able to do anything.

I open SQL PLus, and use CONNECT SYSTEM/MANAGER@ORG.DOMAIN AS SYSDBA

The console shows connected.

I use select table_name,owner from dba_tables where owner='USER1';

I can see the tables I want to access in the output.

I do select * from USER1.TABLE1 and also tried with select * from TABLE1, both return ORA-00903:invalid table

I also tried to connect with "CONNECT USER1/USER1@ORG.DOMAIN" also shows connected, but then same error ORA-00903:invalid table

Could anyone guide me so I can find out whats going on wrong??

Thanks.. Best regards!