Message-Id: <10742.126660@fatcity.com> From: "Trassens, Christian" Date: Mon, 15 Jan 2001 14:37:54 +0100 Subject: RE: Create Table Error 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 TO { () } USING : database string, e.g., scott/tiger@d:chicago-mktg : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
: name of the destination table : a comma-separated list of destination column aliases : any valid SQL SELECT statement A missing FROM or TO clause uses the current SQL*Plus connection. > -----Mensaje original----- > De: Heikki Jantunen [SMTP:hjantunen@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@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@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).