Home » SQL & PL/SQL » Client Tools » ORA-00942: table or view doesn't exist. (oracle 12c windows 12)
ORA-00942: table or view doesn't exist. [message #642340] Tue, 08 September 2015 06:11 Go to next message
muktha_22
Messages: 526
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
Re: ORA-00942: table or view doesn't exist. [message #642342 is a reply to message #642340] Tue, 08 September 2015 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
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 Go to previous messageGo to next message
John Watson
Messages: 7264
Registered: January 2010
Location: Global Village
Senior Member
What are you talking about?
Re: ORA-00942: table or view doesn't exist. [message #642346 is a reply to message #642344] Tue, 08 September 2015 06:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10681
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Ticks in Oracle?
Re: ORA-00942: table or view doesn't exist. [message #642347 is a reply to message #642346] Tue, 08 September 2015 06:45 Go to previous messageGo to next message
John Watson
Messages: 7264
Registered: January 2010
Location: Global Village
Senior Member
Perhaps the Java class, sun/misc/TimerTickThread
Re: ORA-00942: table or view doesn't exist. [message #642348 is a reply to message #642347] Tue, 08 September 2015 06:58 Go to previous message
muktha_22
Messages: 526
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
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:
  


Current Time: Fri Feb 23 16:42:58 CST 2018

Total time taken to generate the page: 0.01755 seconds