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: Transportable tablespaces within the same database

Re: Transportable tablespaces within the same database

From: <jms.news_at_gmail.com>
Date: Tue, 12 Jun 2007 00:54:52 -0000
Message-ID: <1181609692.160410.149400@j4g2000prf.googlegroups.com>


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".
  1. Tablespace rename only works with Oracle10g.
  2. 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

Original text of this message

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