RE: Tablespaces

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Fri, 2 Jul 2004 11:49:09 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C494@25exch1.vicorpower.vicr.com>

True, But if the user has zero quota on that tablespace the table will = then drop into the users default tablespace. It's an old way of moving = user tables around. Done it several times myself.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Wit Serdakovskij [mailto:freelists_at_wit.kiev.ua] Sent: Friday, July 02, 2004 11:44 AM
To: oracle-l_at_freelists.org
Subject: Re: Tablespaces

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.=20

>=20
> 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_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

>=20
>=20

> Dear All,

>=20
> 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.

>=20
> Please help us.

Get the list of statements for creation of all the tables (with tablespace needed).
exp
imp ignore=3Dy

--
wbr,
Wit.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 10:46:39 CDT