Re: move tables with longs

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 4 Sep 2003 20:02:44 +1000
Message-ID: <3f570e2e$0$563$afc38c87@news.optusnet.com.au>

"Steven" <SPAMBLOCKERsteven.pannell_at_gmx.net> wrote in message news:bj6to4$g89op$1_at_ID-82797.news.uni-berlin.de...
> Hi,
>
> I need to move some tables with a Long datatype column to a new
tablespace.
> I cannot perform this using the move command in the alter table statement.
> does anyone know the best way I can go about this?? (I am using Oracle
> 8.1.7)
>
> Thanks in advance.
> Steve.
>

Export the table, re-create it manually somewhere else, import with ignore=y.

It's what we used to do in the dim and distant days of Oracle 7 and 8.0!

Regards
HJR Received on Thu Sep 04 2003 - 05:02:44 CDT