| Dropping a datafile in Oracle 9i [message #166808] |
Sun, 09 April 2006 02:36  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi Team,
I 've one problem. I am using Oracle 9i version on Windows 2003 Server. My problem is like this.
I have one tablespace called "USERS" . for that tablespace 2 datafiles are assoicated with it i.e USERS01.DBF AND USERS02.DBF.
what i've done is that as there is no much space left in the users tablespace i just wanted to add one more datafile to this tablespace since because i need to load data from a .csv file into oracle table which contains 48 lakh recs.
what i've done is that i've issued the following cmd.
SQL>alter tablespace users
add datafile '/..../users03.dbf' size 2048m;
but unfortunately one of team member closed that session.
What i tried to do is that i just opened one more session and
tried to give the same above SQL stmt and immediately thrown me an error saying as follows.
ORA-01537: cannot add data file 'string' - file already part of database
i think what happened was, the datafile with 2GB has been created and also the updated the controlfile but the entry was not made in the Data Dictionary because when i checked
select name from v$datafile;
i could'nt find the entry for that datafile.
Now i want to drop this datafile.How to do it.
Can anyone give me proper solution.
It's urgent.
Thanks and Advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
