Populating the Database Using Oracle Utilities
Oracle databases can be populated with information from a variety of sources. Oracle provides several utilities that can help in loading and unloading data from the database:
SQL*Loader— This utility can be used to load data from a flat file into an Oracle database. Information in the flat file can come from various sources, such as other Oracle databases, non-Oracle databases, and spreadsheets.
Export utility— This utility backs up the entire database, entire schema, or specified tables into a proprietary binary file that can be read by only the Import utility.
Note
Data can be exported from the database incrementally. This can be useful for very large databases.
Import utility— This utility performs ...
Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
