insert into select & datatypes? 2005-05-23 - By Jared Still
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 (See ORA-00997.ora-code.com): illegal use of LONG datatype
On 5/20/05, Marquez, Chris <cmarquez@(protected)> wrote:
>
> Anyone no if any/all Oracle datatypes that are NOT supported by "insert
> into select...".
>
> How about "insert into select...from t1@(protected)" 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
|
|
