N/APosted on - 12/18/2012
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.
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!