#ORACLE EXPORT PARAMETER FILE TABLE LIST HOW TO#

You can also display the contents of an export file without actually performing an import. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file. The files can also be used as backups in addition to normal backup procedures.Įxport dump files can only be read by the Oracle Import utility. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. Text description of the illustration sut81001.gifĪn Export file is an Oracle binary-format dump file that is typically located on disk or tape. The extracted data is written to an Export file, as illustrated in Figure 1-1. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. Using Different Releases and Versions of Export.Using Export and Import to Partition a Database Migration.

Considerations When Exporting Database Objects.Character Set and Globalization Support Considerations.Conventional Path Export Versus Direct Path Export.Warning, Error, and Completion Messages.This chapter discusses the following topics: This file is stored outside the database, and it can be read into another Oracle database using the Import utility (described in Chapter 2).

#ORACLE EXPORT PARAMETER FILE TABLE LIST HOW TO#

This chapter describes how to use the Export utility to write data from an Oracle database into an operating system file in binary format.

Oracle export parameter file table list