Loading DataSeveral 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.SQL*LoaderSQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. Direct-Load insertDirect-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 buffer cache and writing data directly into the datafiles....
Nội dung trích xuất từ tài liệu:
Loading Data into a Database
Loading Data into a Database
Số trang: 32
Loại file: ppt
Dung lượng: 268.50 KB
Lượt xem: 29
Lượt tải: 0
Thông tin tài liệu:
Tìm kiếm theo từ khóa liên quan:
Loading Data into a Database Oracle Net database data management Oracle XML Performance Tuning XML Data AdministrationTài liệu có liên quan:
-
Trắc nghiệm 300 câu phân tích và thiết kế hệ thống
29 trang 123 0 0 -
863 trang 89 0 0
-
710 trang 46 0 0
-
0 trang 37 0 0
-
Lecture Principles of network and system administration: Performance monitoring
26 trang 36 0 0 -
Advanced SQL Functions in Oracle 10g
417 trang 35 0 0 -
Lecture Introduction to computing - Lesson 36: Data management
54 trang 34 0 0 -
20 trang 34 0 0
-
Using Data Dictionary and Dynamic Performance Views
20 trang 34 0 0 -
568 trang 34 0 0
