Using Oracle8ifs Import Utility
Oracle's Import utility reads data and object definitions from a file and loads them into an Oracle database. Import is the complement to Oracle's Export utility and can read files produced only by the Export utility. Import al]〇ws you to do the following:
^ Load data that was exported from another database.
Load object deGnitions that were exported from another database.
Restore objects that you accidentally deleted. If you drop a table, for example, you can import it from the most recent export file.
^ Import tables that you have exported as part of a reorganization process.
Much of the Import utility's functionality parallels that of the Export utility. Export is described in Chapter 8. MUsir^ Oracle8i s Export Utility., It is recommended that you read Chapter 8 first, or at least be familiar with the Export utility, before you attempt to use the Import utility.
In This Chapter
Using the Import utility
Importing an entire database
Importing users
Importing a table
Using Import options
C
Using 0racle8irs Import Utility
To use the Import utility to import data into a database, you need to know how to do several operations, including:
Starting the Import utility
Getting help when you need it
Passing parameters to it
Running it interactively
Using its prerequisites