OraFAQ Forum: Client Tools » ORA-00942: table or view doesn't exist.

Home » SQL & PL/SQL » Client Tools » ORA-00942: table or view doesn't exist. (oracle 12c windows 12)

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

ORA-00942: table or view doesn't exist. [message #642340]

Tue, 08 September 2015 06:11

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Need help,

When we connect to application user and trying to get the table script export (DATABASE column, EXPORT-->TABLE SCRIPT).
We are able to get it done.

But when the TICK BOX of GRANT is TICKED, then it shows the error message of ORA-00942: table or view doesn't exist.

What could be the issue.

Regards
Muktha

Report message to a moderator

Re: ORA-00942: table or view doesn't exist. [message #642342 is a reply to message #642340]

Tue, 08 September 2015 06:29

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no tick box in SQL*Plus.
Ah! narcissism... /forum/fa/5767/0/

[Updated on: Tue, 08 September 2015 06:31]

Report message to a moderator

Re: ORA-00942: table or view doesn't exist. [message #642343 is a reply to message #642340]

Tue, 08 September 2015 06:30

Lalit Kumar B
Messages: 3171
Registered: May 2013
Location: World Wide on the Web

Senior Member

What are the users involved? what are the underlying scripts called via application?

Quote:

ORA-00942: table or view doesn't exist

Seems like the user doesn't have the privilege on the table in other schema.

[Updated on: Tue, 08 September 2015 06:33]

Report message to a moderator

Re: ORA-00942: table or view doesn't exist. [message #642344 is a reply to message #642340]

Tue, 08 September 2015 06:30

John Watson
Messages: 8454
Registered: January 2010
Location: Global Village

Senior Member

What are you talking about?

Report message to a moderator

Re: ORA-00942: table or view doesn't exist. [message #642346 is a reply to message #642344]

Tue, 08 September 2015 06:36

Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Ticks in Oracle?

Report message to a moderator

Re: ORA-00942: table or view doesn't exist. [message #642347 is a reply to message #642346]

Tue, 08 September 2015 06:45

John Watson
Messages: 8454
Registered: January 2010
Location: Global Village

Senior Member

Perhaps the Java class, sun/misc/TimerTickThread

Report message to a moderator

Re: ORA-00942: table or view doesn't exist. [message #642348 is a reply to message #642347]

Tue, 08 September 2015 06:58

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Sorry guys for the confussion,

We are using TOAD.

And we have got the answer for it.

That is ALL_TAB_SOURCE is the table to be granted on to the relevant user.

Thanks for the support
Muktha

Report message to a moderator

Previous Topic:	CE_RECONCILED_TRANSACTIONS_V returns no rows in R12
Next Topic:	Exporting CLOB data in a file and importing using SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 16:14:49 CST 2021