During an import operation, the Oracle Data Pump Import utility uses these files to locate each database object in the dump file set.īecause the dump files are written by the server, rather than by the client, you must create directory objects that define the server locations to which files are written. The files are written in a proprietary, binary format. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. You can import the dump file set on the same system, or import it to another system, and loaded there. You can import a dump file set only by using the Oracle Data Pump Import utility. You can use syntax diagrams to understand the valid SQL syntax for Oracle Data Pump Export. Syntax Diagrams for Oracle Data Pump Export You can use these common scenario examples to learn how you can use Oracle Data Pump Export to move your data. Use Oracle Data Pump parameters for Export (expdp) to manage your data exports.Ĭommands Available in Data Pump Export Interactive-Command ModeĬheck which command options are available to you when using Data Pump Export in interactive mode.Įxamples of Using Oracle Data Pump Export Parameters Available in Data Pump Export Command-Line Mode This capability helps you limit the type of information that is exported. Oracle Data Pump Export provides data and metadata filtering capability. Start the Oracle Data Pump Export utility by using the expdp command. Oracle Data Pump Export is a utility for unloading data and metadata into a set of operating system files that are called a dump file set. The Oracle Data Pump Export utility is used to unload data and metadata into a set of operating system files, which are called a dump file set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |