ORA-00942 [message #9273] |
Thu, 30 October 2003 04:23 |
Pocha Chhele
Messages: 2 Registered: October 2003
|
Junior Member |
|
|
I exported a table, named Part_Master, from a MS Access 2K DB to a Oracle 8.1.7 DB through a ODBC for Oracle DSN. Then I login to SQL Plus and issued:
select * from Part_Master
and got the error:
ORA-00942: Table or view doesn't exist.
Plz help.
|
|
|
Re: ORA-00942 [message #9282 is a reply to message #9273] |
Thu, 30 October 2003 09:51 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Make sure the table actually got copied over. Check it with
Select table_name from all_tables where table_name='PART_MASTER';
|
|
|