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
