Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving tables to a different tablespace

RE: Moving tables to a different tablespace

From: Vincent Ruger <Vincent.Ruger_at_nos.nl>
Date: Fri, 15 Dec 2000 12:55:04 +0100
Message-Id: <10711.124674@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0668D.DCA87BA8
Content-Type: text/plain;

        charset="iso-8859-1"

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_001_01C0668D.DCA87BA8
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Moving tables to a different tablespace</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi,</FONT>
</P>

<P><FONT SIZE=3D2>What about 'alter table (name) move tablespace =
(tablespace name)</FONT>
</P>

<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</FONT>
</P>

<P><FONT SIZE=3D2>-----Oorspronkelijk bericht-----</FONT>
<BR><FONT SIZE=3D2>Van: root_at_fatcity.com [<A =
HREF=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A>]Namens =
Ramamohan B N</FONT>
<BR><FONT SIZE=3D2>Verzonden: vrijdag 15 december 2000 11:12</FONT>
<BR><FONT SIZE=3D2>Aan: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Onderwerp: Re: Moving tables to a different =
tablespace</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi,</FONT>
</P>

<P><FONT SIZE=3D2>You can import table to a different TBS. Make the =
quota Zero</FONT>
<BR><FONT SIZE=3D2>on the current TBS for the user and make the TBS to =
which you</FONT>
<BR><FONT SIZE=3D2>want to move as the default and import 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>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; I need to move some tables out of a tablespace =
into another.&nbsp; Is there</FONT>
<BR><FONT SIZE=3D2>&gt; another option other than dropping the tables =
and recreating them in the</FONT>
<BR><FONT SIZE=3D2>&gt; new tablespace?</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; I have exported the user, but if I understand =
correctly I can import the</FONT>
<BR><FONT SIZE=3D2>&gt; tables into a different user, but not into a =
different tablespace, or am I</FONT>
<BR><FONT SIZE=3D2>&gt; wrong?&nbsp;&nbsp; I want to keep the owner as =
it is.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Thanks</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Thanks</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Ana E. Choto</FONT>
<BR><FONT SIZE=3D2>&gt; Systems Programmer</FONT>
<BR><FONT SIZE=3D2>&gt; American University</FONT>
<BR><FONT SIZE=3D2>&gt; e-Operations</FONT>
<BR><FONT SIZE=3D2>&gt; Phone (202) 885-2275</FONT>
<BR><FONT SIZE=3D2>&gt; Fax&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (202) =
885-2224</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>&gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; Author:</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: achoto_at_american.edu</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt; =
--------------------------------------------------------------------</FO=
NT>
<BR><FONT SIZE=3D2>&gt; To REMOVE yourself from this mailing list, send =
an E-Mail message</FONT>
<BR><FONT SIZE=3D2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling =
of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>&gt; the message BODY, include a line containing: =
UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; (or the name of mailing list you want to be =
removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>&gt; also send the HELP command for other =
information (like subscribing).</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Ramamohan B N</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: ramamohan.bn_at_tatainfotech.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
Received on Fri Dec 15 2000 - 05:55:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US