Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
