| ORA-12801(Error signaled in parallel query server) [message #75066] |
Mon, 18 June 2001 23:14  |
Rajee
Messages: 17
Registered: June 2001
|
Junior Member |
|
|
Hi,
Actually we want to upgrade an oracle database in 7.3.4 to oracle 8.1.7. The database is working perfect in oracle 7.3.4 and oracle 8.1.7 if we use export/import options. But, if we use migration assistant (GUI-in WinNT) we are getting ora-12801 error followed by ora-00942 (table or view does not exist). This problem is coming when we try to execute a particular query, that too from the front end - VB6.0. The same query is running perfectly if we run it in the backend. Can anyone help us out in this. Please
With regards,
rajee
----------------------------------------------------------------------
|
|
|
|
| Re: ORA-12801(Error signaled in parallel query server) [message #75105 is a reply to message #75066] |
Mon, 27 August 2001 09:05  |
Brad Herder
Messages: 2
Registered: July 1999
|
Junior Member |
|
|
We are having a very similar problem after upgrading to Oracle 8. Cold Fusion queries that worked before are now aborting (on an intermittent basis). My specific error is:
ORA-12801: error signaled in parallel query server P002 ORA- 00942: table or view does not exist
Is there a fix for this???
----------------------------------------------------------------------
|
|
|
|
| Re: ORA-12801(Error signaled in parallel query server) [message #75112 is a reply to message #75105] |
Wed, 17 October 2001 06:01 |
R. S. Bisht
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
We have Oracle 8i installed in two different servers:-
1). Dual Processor, 1GB of RAM
2). PIII 700 Mhz PC with 256 MB of RAM
If I run the query in 1st the server the, query is executing fine, but in 2nd server it is giving the above mentioned error !!!
My query is using "UNION ALL"
----------------------------------------------------------------------
|
|
|
|
|
|
| Re: ORA-12801(Error signaled in parallel query server) [message #75169 is a reply to message #75066] |
Wed, 01 May 2002 11:21 |
Stephen Pradeep
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
Hi,
check v$tablespace;
The name correponding to the TS# is the tablespace which is causing this problem.
Change the default Storage parameters(intial extent next maxextents) of that Tablespace to accomodate the table you are trying to create.
It should solve your problem!
Oracle internally uses the Temp Tablespace when large tables are created and the storage parameters for TEMp may not be geared to handle your create statement!
Regards,
Stephen
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
