Help - Search - Members - Calendar
Full Version: ORA-600 [15265]
Oracle DBA Forums > Oracle > Oracle Forum
karthickr
Hi,
I'm getting ORA-600 [15265] eror while dropping a tablespace (also user) . database version 10gR2.
Any idea??

Regards,
Karthick R
dave
what did metalink say when you looked it up?
burleson
Hi Karthick,

We have no access toi the code internals, and all ORA-600 errors must be reported to Oracle technical support:

http://metalink.oracle.com

However, there is your exact problem, ORA-600 when dropping users or tablespaces:

http://dba.ipbhost.com/index.php?showtopic=2819


Bug 1646512
~~~~~~~~~~~
It is possible to issue an 'ADD DATAFILE' command with a SIZE
larger than should be allowed. ie: Above 4194303 DB blocks.
Eg: ALTER TABLESPACE ts ADD DATAFILE '/dev/rdsk/ts' size 1073741824 M;
This only occurs for very specific sizes - most invalid sizes will
raise an error.

Workaround
~~~~~~~~~~
The workaround for all of the above problems is not to use the commands
described in this alert with sizes above the maximum for your database
DB_BLOCK_SIZE.

As sizes are often specified in "K" or "M" never try to use file sizes
greater than the values given by the following select:

SELECT to_char(4194303*value,'999,999,999,999') MAX_BYTES,
to_char(trunc(4194303*value/1024),'999,999,999')||' Kb' MAX_KB,
to_char(trunc(4194303*value/1024/1024),'999,999')||' Mb' MAX_MB
FROM v$parameter WHERE name='db_block_size';
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.