Unable to drop a datafile
From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Wed, 5 Sep 2012 14:34:40 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCEDFF76_at_USA7109MB012.na.xerox.net>
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
Date: Wed, 5 Sep 2012 14:34:40 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCEDFF76_at_USA7109MB012.na.xerox.net>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 05 2012 - 09:34:40 CDT