Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

You use the controlfile autobackup feature oracle


Chapter 18

Backup and Restore Using Export and Import

Every database administrator (DBA) uses Oracle export and import command-line utilities. The goal of this chapter is to provide best practices for running export and import in order to get the best out of both tools in terms of functionality and perfor-mance. Export and import both have some exciting new features for Oracle9i that make the tools much more powerful. For example, export to a point in time is sup-ported through Oracle9i Flashback Query (covered in Chapter 17) and the resumable space allocation features of Oracle9i (refer to Chapter 6) enable import to suspend, rather than abort, when a space shortage exists. Best performance has always been a key requirement for both import and export. In the past there’s been a shortage of information on which factors affect import performance, and this chapter aims to rem-edy that, based on a quantitative analysis.

■■ Exporting to a point in time using Oracle9i Flashback Query

■■ Maximizing export performance using direct path


How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELIF3320B8
Uploaded by :
Page 1 Preview
you use the controlfile autobackup feature oracle
Sell Your Old Documents & Earn Wallet Balance