Wednesday, January 20, 2021

New Features Added to Import Data Script

 I've added the following features to the import_data.sh script:

If the Flashback Database feature is turned ON the script will offer the user to turn it OFF during the import, then after the completion of the import the script will automatically turn it back ON:

But please be aware that when Flashback Database get turned OFF, all the flashback logs will be deleted, which means you will not be able to flashback the database to a point in time prior to turning it OFF.

Also, the script will delay the drop of the importer user --which get created during the import process for the purpose of running the import job.

To download the script:
https://www.dropbox.com/s/5qmfaeos9w4tj63/import_data.sh?dl=0

To get more details on how to use the script please follow the main article:
https://dba-tips.blogspot.com/2020/12/import-shell-script-for-importing-data.html