Re: Help, extremly urgent (tablespaces)

From: Jean-Baptiste Jacquemard <jb.jacquemard_at_pollak-prebon.fr>
Date: Tue, 29 Jan 2002 19:22:44 +0100
Message-ID: <3C56E874.132E9E1@pollak-prebon.fr>

Great !!!! You are great !
Thank you so much.

santysharma wrote:

> If you want to drop datafiles here are the quick steps:
> shutdown database (may be abort)
> startup mount
> alter database datafile 'file' offline drop
> alter database open
> However if you are running in archivelog mode and you have all archives in
> place , it is possible to recreate the datafiles and do the recovery..
> hth
> santysharma

--
Jean-Baptiste Jacquemard
========================
POLLAK PREBON
4, rue de la Bourse
75002 PARIS

Received on Tue Jan 29 2002 - 12:22:44 CST