TAILIEUCHUNG - Loading Data into a Database - 19

Data Loading Methods Several methods are available for loading data into tables in an Oracle database. Of the methods available, Direct Load insert and SQL*Loader are discussed here. Export and Import are covered in the Oracle9i Database Administration Fundamentals II course. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that places little limitation on the format of the data in the data file. Direct Load Direct Load insert can be used to copy data from one table to another table within the same database. It speeds up the insert operation, bypassing the. | Loading Data into a Database Objectives After completing this lesson, you should be able to do the following: Demonstrate usage of Direct Load operations Describe the usage of SQL*Loader Perform basic SQL*Loader operations List guidelines for using SQL*Loader and Direct Load Data Loading Methods Oracle database SQL*Loader Other applications Export Import Direct Load Oracle database Data Loading Methods Several methods are available for loading data into tables in an Oracle database. Of the methods available, Direct Load insert and SQL*Loader are discussed here. Export and Import are covered in the Oracle9i Database Administration Fundamentals II course. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that places little limitation on the format of the data in the data file. Direct Load Direct Load insert can be used to copy data from one table to another table within the same database. It speeds up the insert

• Cơ sở dữ liệu
• Oracle XML Applications
• database
• data management
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Oracle Blocks Efficiently
• Oracle Data Storage Structures
• Oracle Enterprise Manager
• EXPORT IN ORACLE
• Oracle Server
• Managing an Oracle Instance
• Tuning the Oracle Shared Server
• Oracle Architectural Components
• System APIs
• Oracle Workflow
• Data Dictionary
• Managing Undo Data
• SQL Statement Tuning
• Creating Views
• Oracle9i Datetime Functions
• Managing Privileges
• Managing RolesRoles
• Advanced Subqueries
• Using Resource Manager
• Auditing
• Hierarchical Retrieval