First page Back Continue Last page Graphics
…Principal Features
Utilities
- Export
- Extract object definition and data from database
- Excellent for moving objects to another DB
- Even on different platform
- Also use for secondary backup
- Import
- Insert exported definitions and data into DB
- SQL*Loader
- Load ASCII fixed or variable data into table(s)
Notes:
All editions of the Oracle database come with three utilities. They are:
Export – The export utility is used to extract object definitions (metadata) and data from a database. This is useful when you need to move or copy an object to another database (even on an entirely different platform) or as a secondary means of backup (consider RMAN as a primary backup utility).
Import – The import utility can read the files created by the export utility and is used to insert objects (e.g. tables) and object data into a database.
SQL*Loader – The SQL*Loader utility can read ASCII files containing fixed field or delimited records and load them into database tables.