Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on Import with show=y
Alan wrote:
>
> Hello all,
>
> 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
Two common workarounds
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Sun Apr 02 2000 - 00:00:00 CST