 Posted 6/10/2010 11:38:18 AM
|
|
|
|
| I kept getting this error and couldn't figure it out. Oracle Error ORA-20000 Error: ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 121, Batch 2 Line 1 Col 1 Oracle basically says this: 20000, 00000, "%s"
// *Cause: The stored procedure 'raise_application_error'
// was called which causes this error to be generated.
// *Action: Correct the problem as described in the error message or contact
// the application administrator or DBA for more information. It doesn't really help. I finally found the answer to increase the output characters using: DBMS_OUTPUT.ENABLE() By default, you can output 2000 characters, the maximum is 1,000,000
DBMS_OUTPUT.ENABLE(1000000);
However, If the code excedes the limit you will get the same error. You can also also use the following to fix the error message: set serveroutput on size 1000000 Hope this helps. Thanks,
|
|
|
Posted 6/14/2010 10:29:57 AM
|
|
|
|
ORA-20000: | %s | | Cause: | The stored procedure 'raise_application_error' was called which causes this error to be generated.
| | Action: | Correct the problem as described in the error message or contact the application administrator or DBA for more information. |
|
|
|
Posted 6/14/2010 10:30:49 AM
|
|
|
|
SQL> conn / as sysdba
Connected.
SQL> exec dbms_stats.gather_fixed_objects_stats('ALL');
BEGIN dbms_stats.gather_fixed_objects_stats('ALL'); END;
*
ERROR at line 1:
ORA-20000: Insufficient privileges to analyze an object in Fixed Ob
ORA-06512: at "SYS.DBMS_STATS", line 13323
ORA-06512: at "SYS.DBMS_STATS", line 13637
ORA-06512: at "SYS.DBMS_STATS", line 14165
ORA-06512: at line 1
this is Oracle 10.2.0.3 on linux x86-64. My temp tablespace is also online. can you guys help me to find solution for this...
thanks
|
|
|
Posted 6/14/2010 10:31:52 AM
|
|
|
|
| One thing you need to check to resolve ora error code ORA-20000 is: to check if you have the SYSDBA or ANALYZE ANY DICTIONARY system privilege. You need this to execute this procedure.
|
|
|
Posted 6/14/2010 10:33:16 AM
|
|
|
|
I've been trying to execute code ( logged on as user LIVE ) to gather
system stats & get the following
BEGIN
*
ERROR at line 1:
ORA-20000: Unable to analyze INDEX "LIVE"."DSX_CODA_C_LINES_DT_IDX_1",
insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 9375
ORA-06512: at "SYS.DBMS_STATS", line 9389
ORA-06512: at line 2
I've granted gather_system_stats & analyze any to user ...any ideas?
|
|
|
Posted 6/14/2010 10:34:23 AM
|
|
|
|
| If objects get created while logged in as one user yet gather stats get run for another owner that doesn't own the object for which dbms_stats are being gathered then ora-20000 can occur . I've checked the permissions and fixed it. Thanks.
|
|
|
|