Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Line Length on Import Log File

Re: Line Length on Import Log File

From: John Schneider <JohnSchneider_at_Bigfoot.com>
Date: Wed, 10 Apr 2002 22:56:20 -0400
Message-ID: <3CB4FB54.C6AC80B@Bigfoot.com>


> > Using the following parm file:
> >
> > FILE=c:\client.dmp
> > FULL=Y
> > SHOW=Y
> > LOG=c:\client.dmp.log
> >
> > the line length in the DOS window is 80 bytes, and the resulting line
> > length in the log file is 80 also.
> >
> > I'd like to get the log file to show each line in the import file in
> > full, without breaking into multiple lines. For example, a CREATE TABLE
> > statement that is over 80
> > bytes will be broken into multiple lines, each one starting and ending
> > with double quotes (").
> >
> > I've played with the properties of the DOS window, but this has no
> > effect.
>
> It is not DOS which is putting the double quotes there, it is IMP. If you have a
> look in your dump file you'll see that Oracle puts every name (table, index,
> user, etc.) in double quotes. I think it is not possible to get rid off it. What
> you can do is using a filter. This could be a little script (e.g. written in
> Perl) which formats the output the way you like.
>
> Regards,
>
> Knut

Knut,

Thanks for the response. It's not the double quotes I was concerned about, but the actual line length. There must be a parameter somewhere which tells IMP to format each output line at 80 characters. I was looking for a way to keep it from breaking lines up at the 80 char limit.

Thanks,
John Received on Wed Apr 10 2002 - 21:56:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US