Message-Id: <10711.124687@fatcity.com> From: "Mark Leith" Date: Fri, 15 Dec 2000 12:52:42 -0000 Subject: RE: Moving tables to a different tablespace This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C06695.E9E0D4C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: Moving tables to a different tablespaceIf not on 8i how about - CREATE TABLE new_table as (select * from old_table) ... STORAGE (what ever your storage clause would be) Then drop the original table if need be? Mark -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Vincent Ruger Sent: Friday, December 15, 2000 11:57 To: Multiple recipients of list ORACLE-L Subject: RE: Moving tables to a different tablespace Hi, What about 'alter table (name) move tablespace (tablespace name) Orcale 8i features hth Vincent Ruger Oracle DBA -----Oorspronkelijk bericht----- Van: root@fatcity.com [mailto:root@fatcity.com]Namens Ramamohan B N Verzonden: vrijdag 15 december 2000 11:12 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Moving tables to a different tablespace Hi, You can import table to a different TBS. Make the quota Zero on the current TBS for the user and make the TBS to which you want to move as the default and import the tables. Regards, Mohan achoto@american.edu wrote: > > I need to move some tables out of a tablespace into another. Is there > another option other than dropping the tables and recreating them in the > new tablespace? > > I have exported the user, but if I understand correctly I can import the > tables into a different user, but not into a different tablespace, or am I > wrong? I want to keep the owner as it is. > > Thanks > > Thanks > > Ana E. Choto > Systems Programmer > American University > e-Operations > Phone (202) 885-2275 > Fax (202) 885-2224 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: achoto@american.edu > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramamohan B N INET: ramamohan.bn@tatainfotech.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------=_NextPart_000_000D_01C06695.E9E0D4C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Moving tables to a different tablespace
If not=20 on 8i how about -
 
CREATE TABLE new_table as (select * from = old_table) ... STORAGE (what ever your storage clause would=20 be)
 
Then=20 drop the original table if need be?
 
Mark
-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Vincent = Ruger
Sent:=20 Friday, December 15, 2000 11:57
To: Multiple recipients of = list=20 ORACLE-L
Subject: RE: Moving tables to a different=20 tablespace

Hi,

What about 'alter table (name) move tablespace = (tablespace=20 name)

Orcale 8i features

hth

Vincent Ruger
Oracle = DBA

-----Oorspronkelijk bericht-----
Van:=20 root@fatcity.com [mailto:root@fatcity.com]Namens = Ramamohan B=20 N
Verzonden: vrijdag 15 december 2000 = 11:12=20
Aan: Multiple recipients of list ORACLE-L =
Onderwerp: Re: Moving tables to a different tablespace =


Hi,

You can import table to a different TBS. Make the = quota=20 Zero
on the current TBS for the user and = make the TBS=20 to which you
want to move as the default and = import=20 the tables.

Regards,
Mohan

achoto@american.edu wrote:
>=20
> I need to move some tables out of a = tablespace=20 into another.  Is there
> another = option other=20 than dropping the tables and recreating them in the
> new tablespace?
> =
> I have exported the user, but if I understand correctly = I can=20 import the
> tables into a different = user, but not=20 into a different tablespace, or am I
>=20 wrong?   I want to keep the owner as it is.
>
> Thanks
>=20
> Thanks
>=20
> Ana E. Choto
> Systems=20 Programmer
> American University =
> e-Operations
> Phone (202)=20 885-2275
> = Fax      (202)=20 885-2224
>
> = --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --
> = Author:
>   INET: achoto@american.edu
>=20
> Fat City Network = Services    --=20 (858) 538-5051  FAX: (858) 538-5051
> San=20 Diego, California        -- Public = Internet=20 access / Mailing Lists
>=20 = --------------------------------------------------------------------=20
> To REMOVE yourself from this mailing list, = send an=20 E-Mail message
> to: ListGuru@fatcity.com = (note=20 EXACT spelling of 'ListGuru') and in
> = the message=20 BODY, include a line containing: UNSUB ORACLE-L
>=20 (or the name of mailing list you want to be removed from).  You=20 may
> also send the HELP command for = other=20 information (like subscribing).
-- =
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- =
Author: Ramamohan B N
 =20 INET: ramamohan.bn@tatainfotech.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San = Diego,=20 California        -- Public = Internet access=20 / Mailing Lists
----------------------------------------------------------------= ----=20
To REMOVE yourself from this mailing list, send an = E-Mail=20 message
to: ListGuru@fatcity.com (note EXACT = spelling=20 of 'ListGuru') and in
the message BODY, = include a line=20 containing: UNSUB ORACLE-L
(or the name of = mailing=20