Prem
I will provide my guesses and maybe someone that knows the real story
will reply. First, in order for Oracle to drop a datafile, you would somehow
have to ensure that it is empty. I would guess if Oracle added this feature,
then Oracle Support would receive a lot of questions about why it
Thanx everybody.
i thought there would be a way to do it.
just curious .
why is it not so ? any good reason for it ?!!!
Regards,
Jp.
30-10-2003 02:34:26, [EMAIL PROTECTED] wrote:
That won't actually do what you're implying. Checking the docs would prove
helpful.
From the SQL ref:
Thanx craig.
but is there no way of dropping a datafile then ?
Regards,
Jp.
29-10-2003 18:24:25, Craig Richards wrote:
I don't beelive you can drop a datafile from a tablespace, you have to drop
the tablespace, just reaize the datafile to 1M if space is the problem
Regards
--
if you have a tablespace with 10 datafiles. can you drop just one datafile?
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/10/29 Wed AM 08:04:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: How to drop a datafile ?
export the data (make sure you get
disregard my question. i saw it in an earlier post. sorry i have several hundred
emails this morning. i missed it.
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/10/29 Wed AM 08:04:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: How to drop a datafile
datafiles. can you drop just one datafile?
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/10/29 Wed AM 08:04:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: How to drop a datafile ?
export the data (make sure you get all the data)
drop the tablespace