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]
Click Here to Expand Forum to Full Width