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.
exp consistent = y
Who is online
Users browsing this forum: No registered users and 1 guest