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: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 9 Jun 2007 07:12:25 +0200
Message-ID: <466a36ba$0$19226$426a74cc@news.free.fr>

"J" <noone_at_noone.org> a écrit dans le message de news: 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".

|
| >
| > Regards
| > Michel Cadot
|
|
Received on Sat Jun 09 2007 - 00:12:25 CDT

Original text of this message

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