RE: Create Table Error

From: Trassens, Christian <CTrassens_at_uni2.es>
Date: Mon, 15 Jan 2001 14:37:54 +0100
Message-Id: <10742.126660@fatcity.com>

Use a copy with create option. However I recommend you to use LOBs. They have several features that helps you manage that kind of data. For Instance you can create the table with as select:

SQL> create table t1
  2 ( a clob);

Table created.

SQL> r
  1* create table t2 as select * from t1 where 1=0

Table created.

And about the copy.....Here you have a quick reference:

SQL> copy
usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>

  <db>   : database string, e.g., scott/tiger_at_d:chicago-mktg
  <opt>  : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
  <table>: name of the destination table
  <cols> : a comma-separated list of destination column aliases
  <sel>  : any valid SQL SELECT statement

A missing FROM or TO clause uses the current SQL*Plus connection.

> -----Mensaje original-----
> De: Heikki Jantunen [SMTP:hjantunen_at_hotmail.com]
> Enviado el: lunes 15 de enero de 2001 13:06
> Para: Multiple recipients of list ORACLE-L
> Asunto: Create Table Error
>
> Hi,
>
> I am receiving this kind of error:
>
> create table prop_md_user_defined_tmp as select * from
> wlcs_prop_md_user_defined where 1=2
> *
> ERROR at line 1:
> ORA-00997: illegal use of LONG datatype
>
>
> any ideas how to fix...
>
> I am using 8i
>
> br
> Hessu
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Heikki Jantunen
> INET: hjantunen_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jan 15 2001 - 07:37:54 CST