I feel that "" and system() is the same thing.
Well, what i want is to import some tables from a full export dump.
The problem is that if the user's tables will be overwritten during the
automating import.
For example
system("imp system/password fromuser=(myuser) touser=(myuser)
file=export.dmp tables=(table1, table2, table3, ...)");
Will the above command work and keep the table(1-Z) every time up to date?
Or should i drop the user first? (that's the difficult part concerning Perl
and internal commands of sqlplus)
----- Original Message -----
From: "Kevin Moore" <[EMAIL PROTECTED]>
To: "John" <[EMAIL PROTECTED]>
Sent: Friday, December 26, 2003 9:40 PM
Subject: Re: Automatng import
> Try "drop user jim cascade"
>
> John wrote:
>
> >Hi all
> >
> >I am planning to make a cronjob so i would like to know if tht can be
achived through a perl script.
> >
> >To be more specific, i have an Oracle RDBMS and i want to execute some
commands in the shell
> >
> >.....
> >system("sqlplus system/password");
> >system("drop jim cascade");
> >........
> >
> >
> >can be the above done? To execute internal commands as the sqlplus
programs provides?
> >
> >
>
>
