Re: Dropping a datafile from test db (ORA-01111)

I got it (for those who want to know)

The (somewhat misleading) message, when I tried a DROP TABLESPACE, said that file `MISSING` file id nn, had to be recovered. Since the name of the file did not really help here, I figured it belonged to the tablespace to be dropped. But instead it belonged to the temp tablespace, which I usually recreate right after a recovery, what I forgot this time as I went on and directly tried dropping the unnecessary tablespaces.

After recreating a temp tablespace properly I could drop all the tablespaces that were not required in the cloned db. And all is well.

Thanks to those who responded.

Syltrem

"Joel Garry" <joel-garry_at_home.com> a écrit dans le message de news:91884734.0411111119.63b57f88_at_posting.google.com...
> "Syltrem" <syltremzulu_at_videotron.ca> wrote in message
news:<GAukd.48$df.1932_at_tor-nn1.netcom.ca>...
> > I copied ALL of the datafiles for the tablespaces I need in the cloned
db.
> >
> > I can't use EXPort, or trsnaportable tables.
> > I have 0 seconds to clone the db, at exactly 00:00 hours on the 1st of
> > December, so what I want is to clone the db, then roll it forward until
the
> > "cut" time.
>
> Well then, use RMAN to set up a standby or duplicate.
>
> Note: 109979.1 is pretty strange.
>
> jg
> --
> @home.com is bogus.
> http://www.signonsandiego.com/uniontrib/20041111/news_1b11oracle.html
Received on Thu Nov 11 2004 - 19:32:16 CST