RE: Tablespaces
- From: Ganesh.Raja@xxxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 2 Jul 2004 10:03:22 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.
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.
------------------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
