OraFAQ Forum: Replication » ORA-12801(Error signaled in parallel query server)

Home » Server Options » Replication » ORA-12801(Error signaled in parallel query server)

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

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

----------------------------------------------------------------------

Report message to a moderator

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???

----------------------------------------------------------------------

Report message to a moderator

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"

----------------------------------------------------------------------

Report message to a moderator

Re: ORA-12801(Error signaled in parallel query server) [message #75147 is a reply to message #75066]

Mon, 25 February 2002 06:45

TERADATA
Messages: 1
Registered: February 2002

Junior Member

GET TERADATA THEN!

Report message to a moderator

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

Report message to a moderator

Re: ORA-12801(Error signaled in parallel query server) [message #75258 is a reply to message #75066]

Wed, 28 August 2002 09:25

vk
Messages: 13
Registered: December 2001

Junior Member

It seems there are quite some issues with ORA 8.1 parallel servers. Some of them are fixed with 8.1.7.4.

Best way to avoid the ORA-12801 is to turn of the PARALLELIZATION compeletely. Though it can slow down the operations.

Report message to a moderator