What about this oracle auto export?

Asked By Martha Nelson 20 points N/A Posted on - 12/18/2012

Hi,

What about this oracle auto export? I need to know the possibility of oracle auto export, has this feature existed? Getting Oracle database data and export it to another software application such as Microsoft packages? Or any other database system that could possibly help to make things easier.

Thanks.

Regards,

Martha Nelson.

• Status: Open
• Question Views: 1097
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Johnstoon Leen 0 points N/A #172686

What about this oracle auto export?

Hi Martha Nelson

Well there is a way to do this sort of thing.

 

• This solution is for those DBA’s who worked tedious tasks.
• You have to take daily backups of the database.
• Each and every day you have to run the script to export data from database.
• You have to modify your batch file with current date each and every day.
• In your batch file contains your database user name and passwords while running this batch file, it exports your database and will create a dump file with an auto file name.
• Each and every day you’ll export and you’ll get a new dump file every day with date append in the file name.
• You don’t need to give date manually.

 

Here is the batch file Picture which you have to run every day.

 

 

I am pretty sure that you’ll like this solution. Good Luck!

 

Regards,

 

Johnstoon Leen

 

About Johnstoon Leen

Questions
4

Answers
102

Best Answers
64

• Vote Up 0 Vote Down

• Posted on - 01/21/2013
• Question Category: Oracle Database