Re: dropped tablespace accidently; datafiles are still there

In article <3981ba0c$0$156$3936f1fe_at_news-core.twtelecom.net>,   "Tom Galfano" <tgalfano_at_estrong.com> wrote:
> Hi Friends! On a test server we accidently dropped a tablespace that
> contains most of our tables and database objects. We have no good
 backups
> (no excuse!). We are wondering if we can issue a create tablespace
 command
> and reuse our existing datafiles.
>
> We have shut down the instance to stop the SCN from incrementing too
 much.
>
> Any suggestions you have would be greatly appreciated! Thanks.
>
> -Tom
>
>

You can re-use the existing datafiles, but they will be purged of data when you recreate the tablespace:

create tablespace <blah>
datafile <blahblah> [sizing specs] REUSE;

Tablespace file blahblah does already exist so actual file creation is not necessary however Oracle will 'clean house' in the datafile and set it up as if it were new.

So, the answer in this case is 'Yes, you CAN reuse the existing datafiles' but without a backup you'll lose your tables and objects.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.