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=2819Bug 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';