Re: Tablespaces
- From: Wit Serdakovskij <freelists@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 2 Jul 2004 18:44:25 +0300
Hello, Ganesh.Raja,
> 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.
It's not true at all. The export file contains TABLESPACE clause of CREATE
TABLE statement.
> -----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.
1. Get the list of statements for creation of all the tables (with
tablespace needed).
2. exp
3. imp ignore=y
--
wbr,
Wit.
----------------------------------------------------------------
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:
