RE: Tablespaces
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Jul 2004 11:49:09 -0400
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@xxxxxxxxxxx]
Sent: Friday, July 02, 2004 11:44 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> 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.
1. Get the list of statements for creation of all the tables (with
tablespace needed).
2. exp
3. imp ignore=3Dy
--
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
