On Jun 9, 3:12 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "J" <noone_at_noone.org> a écrit dans le message denews: 466a2d19$0$17156$afc38c87_at_news.optusnet.com.au...
> | "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> |
> | >
> | > <jms.news_at_gmail.com> a crit dans le message de news:
> | > 1181278817.166749.65340_at_i13g2000prf.googlegroups.com...
> | > | Instead of transporting a tablespace between 2 databases .... can one
> | > | transport the tablespace to the same database to essentially "restore"
> | > | a tablespace to the state when the datafiles were copied ?
> | > |
> | > | e.g.: Assuming I have only one user that owns objects in the
> | > | tablespace(s):
> | > |
> | >
> | > And the purpose is?
> |
> | You did not read the first part of the post ? The OP says to "restore" a
> | tablespace to the state when the datafiles were copied.
>
> I meant what is the purpose to use TTS instead of "rename".
- Tablespace rename only works with Oracle10g.
- Even if I was using 10g, you still have to use a transportable
tablespace, dont you ?
jms
Received on Mon Jun 11 2007 - 19:54:52 CDT