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

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a table to another tablespace

Re: Moving a table to another tablespace

From: Rafa³ Jank <yankee_at_wp.pl>
Date: Wed, 4 Sep 2002 11:41:12 +0200
Message-ID: <20020904114112.4e488f89.yankee@wp.pl>

On Wed, 4 Sep 2002 09:49:46 +0100
"Alistair Thomson" <thomson_alistair_at_yahoo.co.uk> wrote:

> Hi
>
> If you export drop and reimport the table it will go straight back where it
> came from!.
>
> Try export, drop, recreate the table in the new tablespace then import with
> the flag ignore =y
>

Well, yes, this is correct way.
On the other hand the export files can be edited ;))

-- 
_/        _/  _/_/_/  -----     Rafa³ Jank rjank_at_wp-sa.pl     -----
 _/  _/  _/  _/   _/         Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/    ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
   _/  _/  _/         --------==*  http://szukaj.wp.pl *==----------
Received on Wed Sep 04 2002 - 04:41:12 CDT

Original text of this message

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