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
> >
> >
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
<[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
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]>
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
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
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
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
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
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
T" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: LONG's
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'
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
13 matches
Mail list logo