ORACLE培训资料Less09.pptVIP

Managing Data Objectives After completing this lesson, you should be able to do the following: Manipulate data through SQL Use Data Pump to export data Use Data Pump to import data Load data with SQL Loader Manipulating Data Through SQL The INSERT Command Create one row at a time. Insert many rows from another table. The UPDATE Command Use to change zero or more rows of a table. The DELETE Command Use to remove zero or more rows from a table. The COMMIT and ROLLBACK Commands Used to finish a transaction. Commit: Makes the change permanent Rollback: Undoes the change Integrity Constraints and DML Data Pump Export Data Pump ExportFull Notes Page Data Pump Import Data Pump ImportFull Notes Page DIRECTORY Objects SQL*Loader Tables and indexes SQL*LoaderFull Notes Page The SQL*Loader Control File The loader control file tells SQL*Loader: Where to find the load data The data format Configuration details: Memory management Record rejection Interrupted load handling details How to manipulate the data Control File Syntax Considerations The syntax is free-format. Syntax is not case sensitive. Comments extend from the two hyphens (--) that mark the beginning of the comment to the end of the line. The CONSTANT keyword is reserved. Input Data and Data Files SQL*Loader reads data from one or more files specified in the control file. From SQL*Loader’s perspective, the data in the data file is organized as records. A data file can be in one of three formats: Fixed-record format Variable-record format Stream-record format Loading Methods Loading MethodsFull Notes Page Comparing Direct and Conventional Path Loads Comparing Direct and Conventional Path Loads - Full Notes Page Loading Data with SQL*Loader Loading Data with SQL*LoaderFull Notes Page Summary In this lesson, you should have learned how to: Manipulate data through SQL Use Data Pump to export data Use Data Pump to import data Load data with SQL Loader Practice 9:  Using Data Pump Export and Import This practice