Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00942
ORA-00942 [message #9273] Thu, 30 October 2003 04:23 Go to next message
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 Go to previous message
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';
Previous Topic: Minimizing consistent gets ..
Next Topic: weird sequence problem
Goto Forum:
  


Current Time: Wed Apr 17 19:47:38 CDT 2024