-
Help for scripting
Hi
I need to write some PERL scripts to transfer the data from one database to other. Can somebody suggest me links/books which give me details of perl scripting related to oracle.
I searched in google, and found lots; but very few related to oracle.
-
Hi
Can you describe in detail what exactly you want to do ?
regards
Hrishy
-
hi rishi,
things like taking backup, starting up, shutdown the database, taking export, transferring data from one oracle to sql server etc...
To do this i, think i have to first learn perl. and also if there are some available scripts, probably that will make my job easier.
-
tip : if your server is a Unix box, you'd better learn shell scripting than PERL, it will be much easier for you to write scripts doing what you want...
-
Hi
Nope please follow pipo's advice for the kinds of task you mentioned shell scripts are more than sufficent..you can serach for those scripts right here on these site..tweak them play around with them.when in doubt come n paost here :-)..
regards
Hrishy
-
Call me crazy, but I prefer to use Perl when automating DBA Tasks. It gives you much more control and better error handling than ksh or csh. Sure, for simple jobs I still use ksh, but if I need to connect to the database for something, it's Perl all the way...
Some good Perl books are:
http://www.amazon.com/exec/obidos/tg...books&n=507846
http://www.amazon.com/exec/obidos/tg...books&n=507846
http://www.amazon.com/exec/obidos/tg...books&n=507846
And I've just started reading http://www.amazon.com/exec/obidos/tg...books&n=507846 , so I can't really comment on it right now. (Although I spend the $30 on it so I think it will be at least interesting...)
Jeff Hunter
-
-
slimdave, do you do everything that Jeff tells you to do?
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
-
slimdave, do you do everything that Jeff tells you to do?
Well i'm not about to start using Perl for dba stuff. I have to draw the line somewhere.
My greatest triumph in obfuscation was an EDI extract script, which combined SQL, PL/SQL, ksh, csh, Perl, C and an ftp. It was a mighty tower of eclectic technologies that only i could understand, and ensured my continued employment for as long as i wished.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|