Re: Question on Import with show=y

Hello Sybrand,

    Thanks for your help.

    I found Steve Hauser script on Deja Archives. I also want the script on NT platform. Steve suggested that someone has posted another script in PERL. However, I cannot run this script successfully (due to some statements are invalid). Since I don't know anything about PERL, I don't know how to solve this problem. Maybe I need more time to read the PERL script. Anyway, did anyone use this script (PERL) before? Or anyone suggest other scripts on Windows NT platform? (I am using Oracle 8i on NT platform)

Thanks,
Alan

Sybrand Bakker wrote:

> 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 Sun Apr 02 2000 - 22:40:20 CEST