Re: startup db with another datafile

From: <fitzjarrell_at_cox.net>
Date: 20 May 2005 08:12:32 -0700
Message-ID: <1116601952.566626.226720@o13g2000cwo.googlegroups.com>

Comments embedded.
|a|i|e|i|e| wrote:
> Hi all,
> Just a question/curiosity
>
> I have a database with many TS/datafile. For ONE TS there is ONE
datafile.
>
> Can i get an old datafile for this TableSpace and start the DB (stop
DB,
> delete current datafile, and copy old datafile) ?
>

Unless you're running in archivelog mode and can recover the old tablespace, no, you can't. I expect it's because you don't want to recover that this has become an issue.

> Any command with alter session set events, for keep an OLD tablespace

> version??
>

No.

> I think it's no possible.
>

Your thinking is correct.

>
> thanks

David Fitzjarrell Received on Fri May 20 2005 - 10:12:32 CDT