| fail to drop tablespace [message #276187] |
Wed, 24 October 2007 05:43  |
airother
Messages: 27
Registered: February 2006
|
Junior Member |
|
|
Hi,
i drop the table having size around 10gb
SQL>drop table test;
and try resize tablesapce userdata ,which having only this object.It is fail to do so,as that table is goes to recyclebin
then i try to purge recycle bin
SQL>purge recyclebin
then error comes
ORA-00604: error occurred at recursive SQL level 2
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 16
then i try to create new temp. tables in same tablespace userdata.after this there is no table in recycle bin
but when try to drop a tablesapce userdata it gives
SQL>drop tablespace userdata including contents and datafile;it gives error
ORA-01561: failed to remove all objects in the tablespace specified
i check all view(dba_segments,dba_extents) w.r.to this tablespace
there is no objects in the tablespace.
please tell what really happen with that tablesapce?
can i able to release 10gb size?
regard,
Ajit
|
|
|
|
|
|
| Re: fail to drop tablespace [message #276196 is a reply to message #276187] |
Wed, 24 October 2007 06:10  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Check if you have any trigger on DDL.
Check the code of this trigegr.
Check if then there is any implicit conversion (for instance on date).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
