RE: Moving tables to a different tablespace

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 15 Dec 2000 12:52:42 -0000
Message-Id: <10711.124687@fatcity.com>

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_at_fatcity.com [mailto:root_at_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_at_fatcity.com [mailto:root_at_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_at_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_at_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_at_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_at_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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Moving tables to a different tablespace</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =

class=3D173434512-15122000>If not=20
on 8i how about -</DIV>
<DIV><SPAN=20 class=3D173434512-15122000> </DIV> <DIV><SPAN=20 class=3D173434512-15122000>CREATE TABLE new_table as (select * from =

old_table) ... STORAGE (what ever your storage clause would=20 be)</DIV>
<DIV><SPAN=20 class=3D173434512-15122000> </DIV> <DIV>Then=20
drop the original table if need be?</DIV> <DIV><SPAN=20 class=3D173434512-15122000> </DIV> <DIV><SPAN=20 class=3D173434512-15122000>Mark</DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_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<BR><BR></DIV></FONT>
  <P><FONT size=3D2>Hi,</FONT> </P>
  <P><FONT size=3D2>What about 'alter table (name) move tablespace =

(tablespace=20
name)

  <P><FONT size=3D2>Orcale 8i features</FONT> </P>
  <P><FONT size=3D2>hth</FONT> </P>
  <P><FONT size=3D2>Vincent Ruger</FONT> <BR><FONT size=3D2>Oracle =

DBA 
 -----Oorspronkelijk bericht----- Van:=20
 root_at_fatcity.com [<A=20
 href=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A>]Namens = Ramamohan B=20
 N Verzonden: vrijdag 15 december 2000 = 11:12=20
 Aan: Multiple recipients of list ORACLE-L = <FONT=20
 size=3D2>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.</FONT> </P>
  <P><FONT size=3D2>Regards,</FONT> <BR><FONT size=3D2>Mohan</FONT> </P>
  <P><FONT size=3D2>achoto_at_american.edu wrote:</FONT> <BR><FONT =

size=3D2>>=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 <FONT=20

  size=3D2>&gt; new tablespace?</FONT> <BR><FONT size=3D2>&gt; =
</FONT><BR><FONT=20
  size=3D2>&gt; 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. <FONT =

size=3D2>> > Thanks <FONT =

size=3D2>&gt;=20
  </FONT><BR><FONT size=3D2>&gt; Thanks</FONT> <BR><FONT size=3D2>&gt;=20
  </FONT><BR><FONT size=3D2>&gt; Ana E. Choto</FONT> <BR><FONT =
size=3D2>&gt; Systems=20

Programmer > American University = <FONT=20
 size=3D2>> e-Operations > Phone (202)=20 885-2275 > = Fax      (202)=20 885-2224 > > = --=20
 > Please see the official ORACLE-L FAQ: <A=20 href=3D"http://www.orafaq.com" =
target=3D_blank>http://www.orafaq.com</A>=20 > -- > = Author: <FONT=20
 size=3D2>>   INET: achoto_at_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 =

--------------------------------------------------------------------</FON=

T>=20
 > To REMOVE yourself from this mailing list, = send an=20
 E-Mail message > to: ListGuru_at_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). -- = <FONT=20
 size=3D2>Please see the official ORACLE-L FAQ: <A = href=3D"http://www.orafaq.com"=20
 target=3D_blank>http://www.orafaq.com</A> -- =

Author: Ramamohan B N  =20
INET: ramamohan.bn_at_tatainfotech.com Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=

----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_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 Received on Fri Dec 15 2000 - 06:52:42 CST