Re: Question on Import with show=y

Alan <alan_psb_at_yahoo.com> wrote in message news:38E68209.43B35699_at_yahoo.com...
> 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
>

I could answer your question and leave at that. You'r more or less asking for it :)

NO

This behavior of imp is one of the reasons to make sure always to have your create statements in separate files (the other reason of course being you don't need to use exp to extract them)
Tp tools like Toad or SqlNavigator will be able to dump them w/o using exp AND in a legible format.
As you (like many other posters, and you really shouldn't do that) don't specify platform and/or version, it is up to you to determine whether you can use the ugly_ddl korn shell script by Steve Hauser. He recently replied to a different message, so his URL is in the Deja Archives, if you don't find it, I should be able to dig it up for you. He made it a while ago because my reply to the same question was unsatisfactory for him.

Hth,

Sybrand Bakker, Oracle DBA
' Received on Sat Apr 01 2000 - 00:00:00 CST