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: Importing Database To Multiple Tablespaces

Re: Importing Database To Multiple Tablespaces

From: George Barbour <gbarbour_at_csc.com>
Date: Sat, 4 May 2002 12:14:31 +0100
Message-ID: <3cd3c26a$1@pull.gecm.com>


Oracle "Change Management" tool provided with OEM is worth looking at. It provides fine detailed data migration between instances.

George Barbour.

"Russ" <rgkenneysr_at_cs.com> wrote in message news:1e0b5621.0205031944.4692d46b_at_posting.google.com...
> Hello, Is there a way to import a database to multiple tablespaces? I
> want certain tables to go to different tablespace along with breaking
> out the indexes as well. Is it easier to import the db and then move
> the indexes and tables to their respective tablespaces? The database
> is 8.1.7 and there are 1800 tables and a ton of indexes. Time really
> isn't an issue as I have a couple of days to complete this. It is
> also on a Window DataCenter Server platform. Thanks for any help you
> can provide.
>
> Russ
Received on Sat May 04 2002 - 06:14:31 CDT

Original text of this message

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