exp consistent = y

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
baberamin
Posts: 4
Joined: Tue May 29, 2007 4:30 am
Location: Pakistan

exp consistent = y

Post by baberamin »

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest