Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
exporting preschema procedural objects and actions

Exporting pre-schema procedural objects and actions

750 Part IV ✦ Managing Oracle Data

Export table data (yes/no): yes > @@< 7

Compress extents (yes/no): yes > no @@< 8

Chapter 15 ✦ Reorganizing Data 751

1. USERID connecting to the database for the export 2. Password for user connecting
3. BUFFER size parameter with a default of 4096 bytes 4. FILE parameter indicates the export file name
5. TABLE or USER mode export
6. GRANTS export Yes or No with a default value of Yes 7. ROWS prompt to include table data
8. COMPRESS to compress table extents into one extent

If the export completes successfully, a file named sample.dmp will be located in the directory specified by the FILE parameter containing all the data specified by the export.

You can let Export prompt you for parameters by entering the EXP command followed by your username/password:


You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Nicole Watkins

PageId: ELI0165B57