OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » ora-00942

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-00942 [message #73199]

Mon, 01 March 2004 09:43

Grace
Messages: 6
Registered: April 2002

Junior Member

The OS is XP.Table is exporter from office2000 access. When I use 'select language' from Oracle SQLPLUS 8.0, it shows 'ora-00942 table or view does not exist' massage. How can I fix this?

Report message to a moderator

Re: ora-00942 [message #73204 is a reply to message #73199]

Tue, 02 March 2004 03:26

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You need to ensure that the table was successfully imported before using it. Do a select from DBA_TABLES (or USER_TABLES) to get a list of all tables in your database (schema).

Best regards.

Frank

Report message to a moderator

Re: ora-00942 [message #73206 is a reply to message #73204]

Tue, 02 March 2004 12:13

Grace
Messages: 6
Registered: April 2002

Junior Member

Hi,
I saw this table on schema and it is in 'select * from DBA_TABLES'

Thanks
Grace

Report message to a moderator

Re: ora-00942 [message #73221 is a reply to message #73206]

Thu, 04 March 2004 10:13

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

Can you also see the table from USER_TABLES? If so,
you should be able to select from it. If not, connect
to the table's schema/owner and select from it.
Alternatively, try to select from OWNER.TABLE_NAME.

Best regards.

Frank

Report message to a moderator

Re: ora-00942 [message #73380 is a reply to message #73206]

Tue, 06 April 2004 19:20

Thanh Tung
Messages: 1
Registered: April 2004

Junior Member

frm-40735: WHEN_BUTTON_PRESSED trigger raise unhandled exception ORA-00942.

Report message to a moderator

Previous Topic:	Error in using SQLLDR
Next Topic:	Multiple When Clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 20:07:50 CST 2024