Shell Programming and Scripting

Hi All
I am able to connect my oracle database with Perl and able to execute the queries.
There is one schema names master19 which contains 50 table.

I want to take backup of each table in and store at a given directory location in Perl

For example suppose if a table student is present in master19 schema the Perl should take the back up of the table student in form of insert queries and store it in a given directory with file name student.sql
= = = = = = = = = = = = = = = = = = = = ===
Its not any home work or assignment I am reducing my effort, Normally i do take the back up manually, Now I thought that i should try with Perl, This is new (database stuff) so i posted for some help.
I am equally searching and doing hand zone as well. So i request not to close this thread again


---------- Post updated at 10:18 AM ---------- Previous update was at 10:17 AM ----------

I refereed this website
Hot Backup Of Oracle Database With perl

The easiest way to backup your database would be to export it. Check the help of the exp binary that is shipped with your Oracle client.

tyler_durden

Is there any function to export the table in Perl

What have you tried so far and why/how did it fail?

Moderator's Comments:

Upon thread O/P posts this information any answer will be moderated! @parmitthal2007: I don't care if you are wanting us to do your homework (many of my colleagues think this to be the case) or if you are just way out of your league. It is possible to help someone over the net in understanding or straightening out some detail about his work. But neither is it possible to do your work for you, nor is it possible to teach you the job which you are clearly not qualified to fill from the bottom up. This is simply far beyond the scope of this forum. For example i could explain to you how OSPF works and how it differs from RIP, but neither could i explain networking from the basics nor could i explain what problems these protocols are designed to overcome to someone completely ignorant about how data is transferred from one system to another. At least i can't do that here, over the net, in some forum-postings. The books which deal with this topic occupy 30-40cm on my bookshelf and i had to read and understand them all to have my current knowledge. Teaching this amount of knowledge would need about equal space and i simple have not the time (or the commitment) to write such an amount of text here just for you. You want to know that too? Read the same books as i did! It is not lacking sympathy or personal aversion which keep us from helping you, but simply the limitations described above. We have only limited capacity and in order to do the best possible we have to protect ourselves from being used in excess (to avoid using the term "abused"). So the best help i can give you is: get some training in Perl as well as Oracle and then try to solve the problem again. Right now you are doomed to fail, regardless of how much we try to help you, but once you indeed got the necessary training we'll be here to fill out the last 2% - the details i spoke about above - of necessary knowledge.

bakunin