Re: LONG's

2002-11-28 Thread Jared Still
AIL PROTECTED] > > 11/26/2002 07:54 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > cc: > > Subject:RE: LONG's > > > >

Re: LONG's

2002-11-28 Thread Yechiel Adar
EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/26/2002 07:54 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: LONG's > > > > Thanks all for th

RE: LONG's

2002-11-26 Thread OraCop
<[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/25/2002 07:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:LONG's > > > OK, so yo

RE: LONG's

2002-11-26 Thread OraCop
B? > > Jared > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/25/2002 07:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]>

RE: LONG's

2002-11-26 Thread Jared . Still
LONG's maybe converted to LOB's via the TO_LOB SQL function. There are strict limitations on this function: it can only be used in the SELECT subquery of an INSERT statement. e.g INSERT INTO lob_table SELECT n, TO_LOB(long_col) FROM long_table; As to which is better, LONG co

RE: LONG's

2002-11-26 Thread Jared . Still
ase respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: LONG's Thanks all for the suggestions. I think I'll take a look at COPY and the PL/SQL options since I've used them before, and C &a

RE: LONG's

2002-11-26 Thread VIVEK_SHARMA
TED]> Sent by: [EMAIL PROTECTED] 11/25/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:LONG's OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I

RE: LONG's

2002-11-26 Thread Hand, Michael T
use it. Why not just convert them to CLOB and LOB? Jared "Hand, Michael T" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/25/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subje

Re: LONG's

2002-11-26 Thread John Shaw
you can use the copy  command for the longs - but I don't think it works for long raws - write a pl/sql that pulls it in in 32k chunks or create temp tables with the pk and long raw and do the insert/update routine.>>> [EMAIL PROTECTED] 11/25/02 09:59AM >>> OK, so you can't CTAS on tables wi

Re: LONG's

2002-11-25 Thread Jared . Still
25/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:LONG's OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter

Re: LONG's

2002-11-25 Thread Mark Richard
T" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: LONG's

Re: LONG's

2002-11-25 Thread Connor McDonald
Its called the C compiler :-) If the LONG's are not so long (ie less than 32k) you can get away with just plain old static PLSQL to get at the data, otherwise you can look at dbms_sql hth connor --- "Hand, Michael T" <[EMAIL PROTECTED]> wrote: > OK, so you can'

LONG's

2002-11-25 Thread Hand, Michael T
OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move.   So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB?   Thanks, Mike This trans