Oracle
Enterprise Manager Administrator's Guide
Release 1.6 A63731-01 |
|
This chapter describes how to use Oracle Data Manager wizards to transfer data to and from an Oracle database. It also includes a discussion of the Data Manager tasks that can be submitted with the Job Scheduling system. The topics in this chapter are:
This chapter assumes that you have read Chapter
7, "Overview of the Database Tools", and that you are familiar with
the interface elements of the database tools.
For more information on the tasks Data Manager performs,
see the sections on the Export, Import and SQL*Loader utilities in Oracle
Server Utilities. For information about standard elements of your operating
system, see your operating system-specific documentation.
To start Data Manager, select a database object from the Navigator tree list. Then click on the Data Manager icon in the Applications Launch Palette, or choose Applications and then Oracle Data Manager from the Tools menu.
Note: You can change the database connection with
the Change Database Connection option in the File menu. For information,
see Application Menus on page 7-10.
After Data Manager has successfully connected to a database,
the Users container displays in a tree list on the left side of the Data
Manager window. The Users container is located in the database that Data
Manager is connected to. An individual user container can be expanded to
show the tables that the user owns.
The display on the right side of the window is determined by the object selected on the left side of the screen. The right side may contain a multi-column list, property sheet, or other information.
For general information, see:
An example of a Data Manager window is shown in Figure
14-1, "Oracle Data Manager".
Oracle Data Manager includes the standard menus, File, View,
Log, and Help, plus the Data menu. For information on the standard menus,
see Application Menus on page 7-10.
The Data menu includes the Export, Import, and Load wizard options for:
Context-sensitive menus may also be active when you press
the right mouse button to select a specific object from the navigator or
the multi-column list. This feature provides quick access to a subset of
the menu options provided in the menu bars.
The objects in the tree list are identified by various icons. In the listing:
Data Manager Export is used to the transfer data from an
Oracle database to an operating system file in Oracle-binary format. Files
in this proprietary format can only be read by using the Import component
of Data Manager. Export files can be used to transfer data between databases
or used as backups.
To export data from a database with the Data Manager Export wizard:
See the Data Manager Export online help for information on the individual pages of the Export wizard.
This option specifies that the file is on the remote machine that contains the connected database. This option uses the Job Scheduling system and is only available when the Console is running.
When running the Export wizard, note that the default values
for certain parameters are operating-system specific. Specifically, the
BUFFER parameter defaults to a value of 4K under Windows NT and the RECORDLENGTH
parameter defaults to 2K.
Data Manager Import is used to transfer data from an export
file to an Oracle database. Import can only read data that has been created
with the Export component of Data Manager.
To import data to a database with the Data Manager Import wizard:
See the Data Manager Import online help for information on the individual pages of the Import wizard.
This option specifies that the file is on the remote machine
that contains the connected database. This option uses the Job Scheduling
system and is only available when the Console is running.
When the .DMP file resides on a remote machine, Data Manager uses the Console job and event system to retrieve the file before displaying the data in through the Import Wizard. The Remote Import page of the Import Wizard provides a status line at the top of the page indicating the progress of the data retrieval job. There are three conditions that can be displayed: Job Submitted, Job Started, and Job Completed. Important: the job must complete successfully befor proceeding with the import operation.
When running the Data Manager, note that the default values
for certain parameters are operating-system specific. Specifically, the
BUFFER parameter defaults to a value of 4K under Windows NT and the RECORDLENGTH
parameter defaults to 2K.
Data Manager Load is used to transfer data to an Oracle database
from files that have a different format from export files. Often these
are delimited text files. Using a control file, you specify how the data
is stored externally and how it is to be loaded into the database.
To load data into a database with the Data Manager Load wizard:
See the Data Manager Load online help for information on
the individual pages of the Load wizard.
You must supply a control filename to load data. For information on control files, see the Oracle Server Utilities Guide.
This option specifies that the file is on the remote machine
that contains the connected database. This option uses the Job Scheduling
system and is only available when the Console is running.
The Export, Import, and Load tasks are set up and submitted
with the Oracle Enterprise Manager Job Scheduling system and executed by
Oracle Enterprise Manager Intelligent Agents residing on managed hosts.
The Data Manager tasks are selected in the Task page of the
Create Job property sheet. The parameters are defined in the Parameters
page of the Create Job property sheet. These parameters are similar to
the options available when using the Data Manager wizards. For information
on the specific parameters for the Export, Import, and Load job tasks,
see the online help for the Data Manager tasks.
For information on using the Job Scheduling system, see Chapter
4, "Job Scheduling". For information on specific job tasks, see the
online help for Predefined Job Tasks.