RE: Unable to drop a datafile
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "Amir.Hameed@xxxxxxxxx" <Amir.Hameed@xxxxxxxxx>, Ryan January <rjjanuary@xxxxxxxxxxxxxxxx>
- Date: Wed, 5 Sep 2012 20:27:19 -0400
If you enable sql_trace, it may reveal the recursive sql that is catching that
error. but you'll probably need to open an sr.
-Mark
Sent from my Samsung Galaxy Note?, an AT&T LTE smartphone
"Hameed, Amir" <Amir.Hameed@xxxxxxxxx> wrote:
Thanks Ryan. I have tried it with both absolute path and file_id but the
outcome was the same.
-----Original Message-----
From: Ryan January [mailto:rjjanuary@xxxxxxxxxxxxxxxx]
Sent: Wednesday, September 05, 2012 5:43 PM
To: Hameed, Amir
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Unable to drop a datafile
I have seen similar error messages once in a great while where character
data was found and numeric data was expected. If I recall correctly you
have to specify the full path of the datafile when attempting to drop it
when not using the file number. Did you only supply the file name
('DATAFILE_NAME') in the command or did you give it the full path (
'/path/to/DATAFILE_NAME', '+DATA/<db>/DATAFILE/DATAFILE_NAME' , etc...) ?
Thanks,
Ryan
On 09/05/2012 09:34 AM, Hameed, Amir 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
>
>
---------------------------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email.
---------------------------------------------------------------------------------------
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
