Oracle Data Pump Export If I want to export all the tables in a schema, can I just specify the schema parameter in the parfile or do I also need to list out all the tables individually in the tables parameters? I tried specifying just the schema parameter but the export keeps failing, so I want to confirm whether there is another mistake I am making or if it's because you need to explicitly specify the tables that you want to export.

Thanks!
It is enough to specify the schemas parameter.

expdp \'/ as sysdba\' schemas=siddhu


If you want to export only the tables, you can also add include=table:

expdp \'/ as sysdba\' schemas=siddhu include=table


The above exports the tables with indexes and triggers, but it skips procedures, sequences and other objects not directly related to tables.