exp consistent = y
Posted: Sun Nov 02, 2008 5:07 pm
I have to run an export for a schema which will take approx 1 hour and 15 minutes (may be more) to complete export but now the challenge is that I cannot give that much downtime to the application.
So I thought to stop application for a minute and use exp with consisten = Y parameter and then up the application again.
e.g. exp user/password file=c:\myexp.dmp owner = user1 consistent = Y.
My understanding with this parameter is that if I run this export command at 4:00 p.m will generate the export file with data as it was at 4:00 p.m.
Any changes (record update, table creation etc etc) will not be included in this.
Please correct me if I am wrong.
So I thought to stop application for a minute and use exp with consisten = Y parameter and then up the application again.
e.g. exp user/password file=c:\myexp.dmp owner = user1 consistent = Y.
My understanding with this parameter is that if I run this export command at 4:00 p.m will generate the export file with data as it was at 4:00 p.m.
Any changes (record update, table creation etc etc) will not be included in this.
Please correct me if I am wrong.