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

Importing Database To Multiple Tablespaces

From: Russ <rgkenneysr_at_cs.com>
Date: 3 May 2002 20:44:17 -0700
Message-ID: <1e0b5621.0205031944.4692d46b@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 Fri May 03 2002 - 22:44:17 CDT

Original text of this message

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