| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespaces
Balu,
I'd suggest that you consder the "alter table <SCHEMA>.<TABLE> move tablespace <TABLESPACE_NAME>" and "alter index <SCHEMA>.<INDEX_NAME> rebuild tablespace <TABLESPACE_NAME>" statements, they will make the job far simpler.
Make sure you move the tables before rebuilding the indexes as the table move necessarily invalidates the related indexes.
Otherwise, with exp/imp you would export a schema at a time, use "indexfile=<file_name>" on the first import, edit the file to change the tablespace names, pre-create the tables from this DDL, load the data with "ignore=y" then build the indexes add constraints with the remainder of the parsed DDL.
You can see why it is easier to use "alter table move" and "alter index rebuild" statements!!
Cheers,
Graeme.
-----Original Message-----
From: Computer Centre - NIIPL [mailto:compute_at_ponyneedles.com]
Sent: Friday, 2 July 2004 6:41 PM
To: Oracle Mailing List
Subject: Tablespaces
Dear All,
In our test database we are having one tablespace. The tablespace contains all the tables for different users. ( 1200 Tables). We would like to have a separate tablespace for each user in the real time database.If we use the exp/imp utility, the table will be created in same tablespace as of the original one. Is there any way to insert the tables in to the newly created tablespaces while using imp utility.
Please help us.
Regards,
Balu
This mail is scaned by eScan Anti Virus Software
--
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
 |
 |