Oracle exp exports a large number of tables and the table structure. oracleexp

Oracle exp exports a large number of tables and the table structure. oracleexp

The requirement is: to export the structure of a specified 3 thousand tables, This is generally the case, but the problem is that the table is very large and won't succeed.

Exp user_name/password @ servername rows = n tables = (tab1, tab2, tab3000) file = d:/data. dmp

Use the following methods:

Exp parfile = d: \ test. par

The content of test. par is:

Userid = user_name/password @ servername
File = d: \ data. dmp
Tables = (tab1, tab2, tab3000)
Rows = n