Delete datafile(s) - 9.2.0.4

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Mon, 22 Nov 2004 11:46:21 -0000
Message-ID: <1101123863.1079.0@ersa.uk.clara.net>

During a brain lockup moment this morning i have created 3 datafiles with the incorect PATH - One path represents a testing location and the other a live environment

I have created datafiles to do with a testing instance within the PATH of the live environment -

How can i delete these datafiles without dropping the tablespace on the testing instance - My basic problem is that

ALTER TABLESPACE USERS ADD DATAFILE '/u02/oradata/SID/users06.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE 1024M; should have read

ALTER TABLESPACE USERS ADD DATAFILE '/u02/oradata/SOMEOTHERSID/users06.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE 1024M; and i need to remove them.

thanks! Received on Mon Nov 22 2004 - 05:46:21 CST

Delete datafile(s) - 9.2.0.4 - RHEL3