Topic: Backup & Recovery >> USE OF CONSISTENT=Y IN EXPORT
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: USE OF CONSISTENT=Y IN EXPORT |
| triso |
Posted: Jan 02, 2003 04:57:00 PM |
Total Post: 1
Joined: Jan, 2003
|
Hi Friends,
Can some one tell me use of CONSISTENT=Y in export?
Please try to answer ASAP?
Thanks,
Krity
|
|
|
 Sabari Nath |
| Posted: Jan 02, 2003 05:06:00 PM |  |
|
Total Post: 16
Joined: Jan, 2003
|
Export extracts data by issuing a series of SELECT statements and the snapshot time of each table's data corresponds to when the SELECT statement was issued for that table. If there is no database activity, then this is not an issue. However, it is possible to manipulate the table after the export has started in which case the snapshot of the data may be a factor. Export does not get an exclusive lock on any table. There is an option called CONSISTENT=Y. When this is enabled, EXPORT first issues a SET TRANSACTION READ ONLY command before doing the export. There is a risk of running out of rollback segment space and getting an "ORA-1555 snapshot too old (rollback segment too small)" error when doing a long running export.
If need more detail the read on metalink.
thanks,
Vasu
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
