Re: Question on Import with show=y

I might be wrong, but i think with the indexfile=yes you should be able to get a file which you could use
to create the tables and indexes.

eugen

Sybrand Bakker schrieb:

> 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 - 22:53:58 CEST