Oracle Import Database

Source: Internet
Author: User
Tags exception handling import database

System is a tool, similar to a machine, can be divided into these categories:

1. Operational tools---------------------only for users, data entry operation OLTP

2. Processing Tools---------------------Calculate the data according to the business model, then give a result to the user OLTP

3. Analytical tools----------------------Multi-dimensional analysis of data OLAP

But some systems, the acquisition of data is very troublesome, for example, a cost accounting system, the basis is all from other systems, so customers need to export the required data in other systems (sub-Library sub-table is not shared), this time there is a lot of work, such as export files, manual processing of files before importing the system, for accounting.

is a data import process: ETL, of course, can use professional tools, but now like the version of Oracle, although the function is very powerful, but the project is only a few functions, because the needs of the scene, there is no need for some advanced features, and a professional ETL tools, Perhaps more expensive than the customer's system, may use it???? , so you have to do the job, the total work for people to do it!!! This is also the current display requirement.

==========================

Sql-load: A dedicated Data import processing solution

Write a configuration file and your data file

In fact, the current ETL tool ideas and sql-load a bit similar, such as the core: caching mechanism, batch processing mechanism, exception handling mechanism, data compensation mechanism.

Oracle Import Database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.