Re: removing useless datafile

	Actually, I did try 'alter database datafile offline drop'
	but it just took the datafile offline. Then I followed it up
	with a 'create controlfile resetlogs' with the datafile
	edited out. But I got a ORA-01200. Am I missing out some 
	steps here ?

	One solution is to do an export, recreate the tablespace without
	the datafile and then import. But this can take a lot
	of time. I am wondering if there is a quicker way of do this.

	Thanks a lot.

Bola Ogunlana (bolao_at_incads.demon.co.uk) wrote:
: try

: alter database datafile '/m001/.../USER02.dbf' offline drop;

: as long as you're sure the datafile contains no data ie. Don't forget to do
: your backup beforehand.

: Shirley Donor wrote in message <6t9n99$gnc$1_at_paxfeed.eni.net>...
: >
: > We have a tablespace with 2 datafiles. one of the
: > datafile is unnecessary and we like to
: > delete it ? how do we go about it ?
: >
: > Example : Tablespace : USER
: > Datafile : /m001/.../USER01.dbf
: > /m001/.../USER02.dbf
: >
: > We like to remove USER02.dbf from the
: > USER tablespace.
: >
: > Thanks.
: >
: >
Received on Tue Sep 15 1998 - 10:26:59 CDT