Re: Basic exp/imp question

From: Just Visting <guest_at_example.com>
Date: Sat, 24 Jul 1999 18:16:41 GMT
Message-ID: <379a0250.18833220@news>

Try placing as the very last character on each "continuation" line the "\" (without the double quote marks); as below

exp userid=3Dscott/tiger \
full=3Dy \
file=3D'/home/oracle/full.dmp' \
log=3D'/home/oracle/full.log'

Alternatively you could use a "parameter file"

HTH, YMMV & HAND!

On Sat, 24 Jul 1999 13:40:59 -0700, "Juan Carlos" <jc_va_at_hotmail.com> wrote:

>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0480_01BED5DA.29B272A0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>If I have a script to exp with carriage returns, it seems to not =
>recognize the commands. This works:
>
>[oracle : ~] $cat full
>exp userid=3Dscott/tiger full=3Dy file=3D'/home/oracle/full.dmp' =
>log=3D'/home/oracle/full.log'
>
>but this doesn't, and it writes to the default expdat.dmp file
>
>[oracle : ~] $cat fulx
>exp userid=3Dscott/tiger
>full=3Dy
>file=3D'/home/oracle/full.dmp'
>log=3D'/home/oracle/full.log'
>
>Is there a continuation character so that the commands are parsed =
>correctly? This is oracle 8.0.5/linux.
>
>Thanks.
>
>------=_NextPart_000_0480_01BED5DA.29B272A0
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
><HTML>
><HEAD>
>
><META content=3Dtext/html;charset=3Diso-8859-1 =
>http-equiv=3DContent-Type>
><META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
></HEAD>
><BODY>
><DIV>If I have a script to exp with carriage returns, it seems to not =
>recognize=20
>the commands.  This works:</DIV>
><DIV> </DIV>
><DIV><FONT face=3D"Courier New">[oracle : ~] $cat full<BR>exp =
>userid=3Dscott/tiger=20
>full=3Dy file=3D'/home/oracle/full.dmp' =
>log=3D'/home/oracle/full.log'</FONT></DIV>
><DIV> </DIV>
><DIV>but this doesn't, and it writes to the default expdat.dmp =
>file</DIV>
><DIV> </DIV>
><DIV>[<FONT face=3D"Courier New">oracle : ~] $cat fulx<BR>exp=20
>userid=3Dscott/tiger<BR>full=3Dy<BR>file=3D'/home/oracle/full.dmp'<BR>log=
>=3D'/home/oracle/full.log'</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=3D2>Is there a continuation character so that the =
>commands are=20
>parsed correctly?  This is oracle 8.0.5/linux.</FONT></DIV>
><DIV><FONT size=3D2></FONT> </DIV>
><DIV><FONT size=3D2>Thanks.</FONT></DIV></BODY></HTML>
>
>------=_NextPart_000_0480_01BED5DA.29B272A0--
>
Received on Sat Jul 24 1999 - 13:16:41 CDT