Sql error:ORA-12801:error

Read only

2,597

Hi,

This is a BW system.

There is lot of data in the cube table and now we are rolling up this table data into the Aggregate tables

We are getting this errror while running a job.

Sql error:ORA-12801:error signaled in parallel query server P001

Regards,

Rajiv

Edited by: Rajiv V on Oct 31, 2008 12:19 PM

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

check alert_SID.log for more clues.

also check SM21.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

hi,

This was resolved when the size of the file PSATEMP was increased.

Regards,

Visshwas

Ask a Question

Top Q&A Solution Author

User

Count