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: Can't move tables with columns of type long

Re: Can't move tables with columns of type long

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 11 May 2003 20:52:35 -0700
Message-ID: <73e20c6c.0305111952.77641d@posting.google.com>


"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message news:<3ebec088$0$49107$e4fe514c_at_news.xs4all.nl>...
>
> 1. Export the table (with triggers, constraints, indexes, grants) (check
> options with exp help=y)

and use the "buffer" parameter to give it a big enough chunk so that the maxsiz long fits.

DAMHIKT... Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Sun May 11 2003 - 22:52:35 CDT

Original text of this message

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