Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping a datafile from test db (ORA-01111)

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

From: Joel Garry <joel-garry_at_home.com>
Date: 11 Nov 2004 11:19:21 -0800
Message-ID: <91884734.0411111119.63b57f88@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 - 13:19:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US