Oracle import export using datapump (data pump) Execute the following commands to create a database directory. This directory must point to a valid directory on the same server as the database
PS: Oracle introduced a default directory from 10g R2, called DATA_PUMP_DIR, that can be used:
Run export:
To import to another schema
Full export mode: You use the FULL parameter when you want to export the entire database in one export session. You need the EXPORT_FULL_DATABASE role to use this mode. • Schema mode: If you want to export a single user’s data and/or objects only, you must use the SCHEMAS parameter. • Tablespace mode: By using the TABLESPACES parameter, you can export all the tables in one or more tablespaces. If you use the TRANSPORT_TABLESPACES parameter, you can export just the metadata of the objects contained in one or more tablespaces. You may recall that you can export tablespaces between databases by first exporting the metadata, copying the files of the tablespace to the target server, and then importing the metadata into the target database. • Table mode: By using the TABLES parameter, you can export one or more tables. The TABLES parameter is identical to the TABLES parameter in the old export utility. Schema mode is the default mode for Data Pump Export and Import jobs. |
OracleDB >