What about this oracle auto export?

Asked By 20 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #172686

What about this oracle auto export?

qa-featured

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.
 
script to export data from database
 
I am pretty sure that you’ll like this solution. Good Luck!
 
Regards,
 
Johnstoon Leen
 

Login/Register to Answer

Related Questions