Unable to drop a datafile

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Sep 2012 14:34:40 +0000

Hi All,
I am trying to drop a datafile which is empty and contains no extent and is not 
the first datafile of the tablespace either. I am getting the following error 
when I execute the drop command:
alter tablespace <TS_NAME> drop datafile 'DATAFILE_NAME' ;
alter tablespace .... drop datafile ....
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01426: numeric overflow

The DB version is 11.1.0.7. Has anyone seen this issue and knows how to resolve 
it?

Thanks
Amir

--
//www.freelists.org/webpage/oracle-l


Other related posts: