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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
