Re: move tables with longs

From: Steven <SPAMBLOCKERsteven.pannell_at_gmx.net>
Date: Thu, 4 Sep 2003 16:25:44 +0200
Message-ID: <bj7i17$fuhum$1@ID-82797.news.uni-berlin.de>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f570e2e$0$563$afc38c87_at_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
>
>

bummer, but it worked.

Thanks,
Steve. Received on Thu Sep 04 2003 - 09:25:44 CDT