| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing Database To Multiple Tablespaces
Hi Russ
On 3 May 2002 20:44:17 -0700, rgkenneysr_at_cs.com (Russ) wrote:
>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.
My advice is to precreate your tables and indexes in the proper tablespaces and then run the import with the IGNORE=Y option. It would be a lot harder to move them afterwards.
Grab the freeware DBATool it is designed to generate the schema recreation DDL files you will need. Before generating the DDL scripts you can apply simple rules to tables/indexes to modify the tablespace and storage clauses to what you want. You can even use wild cards and say things like "all tables are to go in tablespace X, except tables with names like ABC* which go into tablespace Y except table ABC_BIG which goes into tablespace Z.
In your case you should probably just let the DBATool generate the DDL for tables and indexes. Let the rest get created on import by IMP.
DBATool: http://www.databee.com/dt_home.htm
Regards
Dale Edgar
Net 2000 Ltd.
 |
 |