Export and Import
For long time, we have been using export utility as part of our backup process using sys account scheduled to run on a daily basis. Recently, I have a migration project to upgrade our database to Oracle 11. Everything is good now except that I ran into an error, EXP-0015 (parameter CONSISTENT is is not supported for this user) when I re-build the backup script.
I know that when I change the statement to CONSISTENT=N, the log file will be clean again with the beautiful statement at the end saying “terminated successfully without warnings”, which I like a lot. I just wonder what is the implication from now on in terms of keeping the exported files using a new CONSISTENT=N parameter in the export script?