DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 32

Thread: Help for scripting

  1. 03-06-2003, 03:16 AM #1
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376

    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.
    Reply With Quote Reply With Quote
  2. 03-06-2003, 03:42 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you describe in detail what exactly you want to do ?

    regards
    Hrishy
    Reply With Quote Reply With Quote
  3. 03-06-2003, 07:04 AM #3
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376
    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.
    Reply With Quote Reply With Quote
  4. 03-06-2003, 07:46 AM #4
    pipo
    pipo is offline Senior Advisor
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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...
    Reply With Quote Reply With Quote
  5. 03-06-2003, 10:23 AM #5
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    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
    Reply With Quote Reply With Quote
  6. 03-06-2003, 10:50 AM #6
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    Reply With Quote Reply With Quote
  7. 03-06-2003, 11:27 AM #7
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    you are crazy
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  8. 03-06-2003, 11:33 AM #8
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
    Reply With Quote Reply With Quote
  9. 03-06-2003, 11:34 AM #9
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by marist89
    Call me crazy
    CRAZY, CRAZY, CRAZY

    Happy Now
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  10. 03-06-2003, 11:42 AM #10
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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