Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Chapter 13. Export and Import

The Oracle database stores information within the confines of its own datafiles, in its own format. Any user can access this data through the use of SQL.

The Oracle database also includes utilities that allow you to extract the data from the database into a binary file (the Export utility) and to bring data into the Oracle database from a binary file (the Import utility). You can use these utilities to capture both the structures and the data in an Oracle database. Import and Export are helpful in moving your data to a different database, as well as in backup and recovery operations. (Note, however, that Oracle provides more comprehensive backup and recovery utilities, described in Chapter 15.)

This chapter describes the syntax and basic operations of the Export and Import utilities.

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 Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page