Oracle expdp Export Command Guide

1 year ago
Emily Johnson
2 minutes

In Oracle, you can utilize the expdp command to export data. The following is an example of exporting data using the expdp command:

  1. Export the entire database.
  2. Export data from a database with the given username and password to a dump file named dumpfile.dmp using the expdp command.
  3. This command exports the entire database to a file named dumpfile.dmp.
  4. Export the specified template:
  5. Export data from a specific schema in the database to a dump file using the expdp command with the given username and password.
  6. The command will export the specified schema to a file named dumpfile.dmp.
  7. Export the specified table:
  8. Export data from the table specified in “table_name” from the database named “database_name” using the username and password provided, and store it in a file named “dumpfile.dmp”.
  9. This command will export the specified table to a file named dumpfile.dmp.
  10. Export specified data.
  11. Export data from the database with the specified condition using the expdp command. Save the output in a dumpfile. Use username, password, and database_name to access the database.
  12. This command exports data that meets the specified conditions to a file named dumpfile.dmp.
  13. Export the specified table space:
  14. Export data pump (expdp) command with the given username, password, and database name, specifying the tablespace to be exported and the dumpfile for the output.
  15. This command exports the specified tablespace to a file named dumpfile.dmp.
  16. Export specified users:
  17. Export the specified user’s data from the database using the expdp utility.
  18. The command will export the specified user to a file named dumpfile.dmp.

Please note that in the above command, username refers to the database username, password is the user’s password, database_name is the name of the database, schema_name is the name of the schema, table_name is the name of the table, condition is the query condition, tablespace_name is the name of the tablespace, directory_name is the directory for the export file, and dumpfile.dmp is the name of the export file.

bannerAds