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) ?

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

I think it's no possible.


thanks

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