I did that but I got a different error message. I thought maybe I had
it wrong. Any idea? Is this the only way of executing exp in Perl or
is there a more efficient method?
LRM-00112: multiple values not allowed for parameter 'userid'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
thanks.
On Mon, 28 Feb 2005 17:13:32 -0600 (CST), Michael Nhan
<[EMAIL PROTECTED]> wrote:
>
> escape the @,
> my $r=system("exp file=users.dmp transport_tablespace=y tablespace=users
> userid=\'sys/[EMAIL PROTECTED] as sysdba\'");
>
> > Date: Mon, 28 Feb 2005 18:05:59 -0500
> > From: Tiffany Thang <[EMAIL PROTECTED]>
> > To: dbi-users@perl.org
> > Subject: running Oracle export in perl
> >
> > Hi,
> > The following exp command ran find on Unix command prompt.
> >
> > $> exp file=users.dmp transport_tablespace=y tablespaces=USERS
> > userid=\'sys/[EMAIL PROTECTED] as sysdba\'
> >
> > When I tried calling it in Perl,
> > my $rc=system("exp file=users.dmp transport_tablespace=y
> > tablespaces=USERS userid=\'sys/[EMAIL PROTECTED] as sysdba\'");
> >
> > I got the following error messages:
> > Possible unintended interpolation of @testdb in string at myexport.pl line
> > 5.
> > Global symbol "@testdb" requires explicit package name at myexport.pl line
> > 5.
> >
> > I guess it's treating @testdb like an array. How can I escape @ or is
> > there another way of executing exp in Perl?
> >
> > Thanks.
> >
> > Tiff
> >
>
> ---//---
> "He who learns must suffer. And even in our sleep,
> pain that cannot forget, falls drop by drop upon the heart;
> and, in our own despair, against our will,
> comes wisdom to us by the awful grace of God."
> --- Aeschylus
>
