How do you export data from multiple tables in Oracle?

You can use the expdp command in Oracle to export data from multiple tables. Here are some steps:

1. Open the command line interface using CMD or Command Prompt.
2. Enter the following command to connect to the Oracle database:
3. Login to the database using the username and password with sqlplus.
4. In this case, username refers to your database username, password is your database password, and database is your database instance name.
5. Use the following command to create a directory object for storing exported data files:
6. Make a directory called dump_dir with the path ‘C:\path\to\directory’.
7. Replace the path C:\path\to\directory with the desired location where you want to store the exported data files.
8. Enter the following command to export data from multiple tables:
9. Export data from tables table1, table2, and table3 in the database using the expdp command with the specified directory and dumpfile options.
10. Replace ‘username’ with your database username, ‘password’ with your database password, ‘database’ with your database instance name, ‘table1,table2,table3’ with the names of the tables you want to export, and ‘tables.dmp’ with the name of the exported data file.
11. Please wait for the export process to complete. The exported data file will be saved in the directory specified in step 3.

Please note that users exporting data must have DATAPUMP_EXP_FULL_DATABASE and DATAPUMP_IMP_FULL_DATABASE privileges.

I hope this helps you!