Re: insert into select & datatypes?

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 23 May 2005 11:38:48 -0700
Message-ID: <bf463805052311381b1f9dcf@mail.gmail.com>

Here's one:

11:41:17 SQL> create table ctas_source (
11:41:17 2 id number(12) not null
11:41:17 3 , file_data long raw
11:41:17 4 )
11:41:17 5 /

Table created.

11:41:17 SQL>
11:41:17 SQL> create table ctas_dest
11:41:17 2 as
11:41:17 3 select *
11:41:17 4 from ctas_source
11:41:17 5 /

select *
*
ERROR at line 3:
ORA-00997: illegal use of LONG datatype

On 5/20/05, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:
>
> Anyone no if any/all Oracle datatypes that are NOT supported by "insert
> into select...".
>
> How about "insert into select...from t1_at_dblink" over db link?
>
> insert into SCOTT.B_[LOB_TABLE | XMLTYPE_TABLE | USERDEFINEDTYPE_TABLE |
> LONG_TABLE | RAW_TABLE]
> select * from SCOTT.A_[LOB_TABLE | XMLTYPE_TABLE | USERDEFINEDTYPE _TABLE
> | LONG_TABLE | RAW_TABLE]
> ;
>
> Thanks,
>
> Chris Marquez
> Oracle DBA
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 23 2005 - 14:43:35 CDT