SAPDBA - Export/import of multiple tables..

[Former Member]

Hi Team,

We are going to perform DB Reorganization and we need to export and import the tables.

Could you pls let me know how we can specify multiple tables during export of tables using SAPDBA.

We have tried to seperate each table entry by a comma but that did not work..

Can you pls provide your valuable solutions..

Regds,

Satyanarayana N.

[Former Member]

Hi Satyanarayana,

Try this:

while specifying the multiple tables, put them in parenthesis.

ex:

exp user/pwd FILE=exportdata.dmp TABLES=(table1, table2 ... tableN) IGNORE=y

I've not tried this. Check if this works.

Regards,

Srihari

Edited by: Srihari Rao on Aug 18, 2008 6:15 PM