Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
Backup and Recovery
|
49
The following parameters are available:
ATTACH [= [schema_name.]job_name]
Attaches the client session to an existing job and automat-
ically places you in the interactive-command interface.
CONTENT = {ALL | DATA_ONLY | METADATA_ONLY}
Allows you to filter Export or Import. Specifies whether
Data Pump operates on data only, metadata only, or
both. The default exports or imports both data and
metadata. DATA_ONLY exports or imports only table
row data; no database object definitions are included.
METADATA_ONLY exports or imports only database
object definitions; no table row data is included.
DIRECTORY = directory_object
Specifies the location to which Export writes the dump
file set and the log file. The directory_object is the name
of a database directory object (not the name of an actual
directory) that was previously created by the DBA using
the SQL CREATE DIRECTORY command.
DUMPFILE = [directory_object:]file_name[, ...]
Specifies the names and, optionally, the directory objects
of dump files for a job.
ESTIMATE = {BLOCKS | STATISTICS}
For Export, specifies the method that will be used to esti-
mate how much disk space each table in the export job
will consume (in bytes). For Import, specifies the method
that will be used to estimate the amount of data to be
imported. The estimate is for table row data only; it does
not include metadata. By default, the estimate is calcu-
lated by
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843