Hi,

I have a tablespace named ORGSDATA.

I was getting the following errors ORA-01653 as a result of which I decided to add a datafile.The existing data file is 'DATA02ORGS.DBF of size 100M

I tried using

ALTER TABLESPACE ORGSDATA ADD DATAFILE 'F:\\ORGS\\DBFILES\DATA02ORGS.DBF' SIZE 100M REUSE AUTOEXTEND ON NEXT 10K MAXSIZE UNLIMITED

But got the following errors

ORA-01537: cannot add data file 'F:\\ORGS\\DBFILES\DATA02ORGS.DBF' - file already part of database

Can't I reuse the same existing Datafile instead of adding a new one?
What then is the use of the REUSE clause?

I use Oracle7 in Win NT


[Edited by sabita_ban on 02-18-2002 at 04:12 AM]