Question on Import with show=y

From: Alan <alan_psb_at_yahoo.com>
Date: Sat, 01 Apr 2000 15:11:05 -0800
Message-ID: <38E68209.43B35699_at_yahoo.com>



[Quoted] Hello all,

[Quoted]     I import an export file by using show=... to generate the file contains all SQL statements. However, the format of the resulting file is not good. I found that the line may be splitted into two lines on some keywords. e.g.:

 CREATE TABLE CITIES (STATE VARCHAR2(2), CITY VARCHAR2(25), POPULATIO  N NUMBER(8, 0), WHITE NUMBER(6, 2), BLACK NUMBER(6, 2), HISPANIC NUM  BER(6, 2), ASIAN NUMBER(6, 2), OTHER NUMBER(6, 2)) PCTFREE 10 PCTUSED  40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MA
 XEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE COUN
 TRY     Is it possible to generate the file such that the resulting file does not split the line into two lines on words?

Thanks,
Alan Received on Sun Apr 02 2000 - 01:11:05 CEST

Original text of this message