Re: Unable to drop a datafile
- From: Gus Spier <gus.spier@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Wed, 5 Sep 2012 17:35:14 -0400
You might want to try to drop the file by its file_id/file number. And I
think that this can also be done using ALTER DATABASE DROP DATAFILE ....
But be sure to check the documentation for the details.
Regards,
Gus
On Wed, Sep 5, 2012 at 10:34 AM, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
