Home » SQL & PL/SQL » SQL & PL/SQL » error while adding column on table
error while adding column on table [message #350268] Wed, 24 September 2008 09:37 Go to next message
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 #350272 is a reply to message #350268] Wed, 24 September 2008 09:57 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
And when you look up those error codes in the manual you find...
Re: error while adding column on table [message #350287 is a reply to message #350268] Wed, 24 September 2008 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.
Before, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: error while adding column on table [message #350405 is a reply to message #350272] Wed, 24 September 2008 23:49 Go to previous messageGo to next message
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 #350407 is a reply to message #350405] Wed, 24 September 2008 23:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So check what is wrong and fix it.

Regards
Michel
Re: error while adding column on table [message #350408 is a reply to message #350272] Wed, 24 September 2008 23:59 Go to previous messageGo to next message
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 Go to previous message
flyboy
Messages: 1832
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.
Previous Topic: question regarding grants
Next Topic: To select the rows, for which most of the columns have values
Goto Forum:
  


Current Time: Fri Dec 09 11:39:58 CST 2016

Total time taken to generate the page: 0.06669 seconds