error while adding column on table [message #350268] |
Wed, 24 September 2008 09:37  |
coolyogi4u
Messages: 10 Registered: September 2008
|
Junior Member |
|
|
error stack shown on command prompt if a column is added to any freshly
created table by the owner
ORA-00604
ORA-06531
ORA-06512
But if the same thing is being done by sys, the table gets modified.
This problem is not occurring on production.
|
|
|
|
|
Re: error while adding column on table [message #350405 is a reply to message #350272] |
Wed, 24 September 2008 23:49   |
coolyogi4u
Messages: 10 Registered: September 2008
|
Junior Member |
|
|
i have not seen those errors because my freind had sent me this prob and he cant tell me the errors.
but basically the problem is some xyz user can create table in his own schema but cant add columns to his tables. he have all the privileges as that of sys.
but when sys creates table in his schema ,he can add column to his table.
|
|
|
|
Re: error while adding column on table [message #350408 is a reply to message #350272] |
Wed, 24 September 2008 23:59   |
coolyogi4u
Messages: 10 Registered: September 2008
|
Junior Member |
|
|
hey the error stack is
ORA-06531: Reference to uninitialized collection
ORA-00604: error occurred at recursive sql level 1
also
ORA-12012: error on auto execute of job 302
ORA-04045: errors during recompilation/revalidation of
PMS.SPK_STATEWISE_DATA
ORA-06531: Reference to uninitialized collection
ORA-06512: at line 4
see if it can help.
thanks in advance
|
|
|
Re: error while adding column on table [message #350412 is a reply to message #350408] |
Thu, 25 September 2008 00:10  |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
coolyogi4u wrote on Thu, 25 September 2008 06:59 | ORA-04045: errors during recompilation/revalidation of
PMS.SPK_STATEWISE_DATA
|
From http://ora-04045.ora-code.com/:
Quote: | ORA-04045: errors during recompilation/revalidation of string.string
Cause: This message indicates the object to which the following errors apply. The errors occurred during implicit recompilation/revalidation of the object.
Action: Check the following errors for more information, and make the necessary corrections to the object.
|
What is PMS.SPK_STATEWISE_DATA? I bet this is ALTER trigger. It has errors. Fix them.
|
|
|