Re:How to drop a datafile from a tablespace quickly

2002-05-15 Thread Rachel_Carmichael
ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re:How to drop a datafile from a| | tabl

Re:How to drop a datafile from a tablespace quickly

2002-05-15 Thread dgoulet
Tom, Regrettably there is no way that you can drop a datafile from a tablespace. Your stuck with having to drop the entire tablespace. If you can export and import that's great. Otherwise try creating a new tablespace, copying the table (with a new name) into the new tablespace, dropping t