| 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
Unless the original tablespace exists.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Ganesh.Raja_at_barclayscapital.com
Sent: Friday, July 02, 2004 4:03 AM
To: oracle-l_at_freelists.org
Subject: RE: Tablespaces
Create the Users and assign them Default Tablespace and then Import the Tables into them. When the Tables are imported they will be Imported into the Default Tablespace.
Better Still u can Move the Tables from One Tablespace to the Other and Rebuild the Indexes.
HTH
Cheers,
Ganesh R
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Computer Centre - NIIPL
Sent: 02 July 2004 09:41
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
Internet communications are not secure and therefore the Barclays Group does not accept legal responsibility for the contents of this message. Although the Barclays Group operates anti-virus programmes, it does not accept responsibility for any damage whatsoever that is caused by viruses being passed. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Barclays Group. Replies to this email may be monitored by the Barclays Group for operational or business reasons.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |