I have a database which has 50000 tables. Now I want to export only 6000 tables out of it.
Usually in exp command, we will use the "Tables" identifier to export number of tables we want. But in above scenario, do we need to mention table names of all 6000 tables??
Is there any other way to accomplish this?
Thanks for the reply.. Oracle version is 10.2.0.1.
Operator can filter only tables with similar name right? if not correct me.
Suppose if all 6000 tables have different names..
Please provide syntax under the above case, if all tables are having different names.
>>Operator can filter only tables with similar name right? if not correct me.
Yes, thats correct you can use the LIKE and IN.
>>Suppose if all 6000 tables have different names..
In Standard Practice there should be some similarity like some prefix/suffix so you can use something like INCLUDE=TABLE:" like '%AB%'"
>>if all tables are having different names.
In that case as you know you have to list all the table you want to backup.
You can use something like this to use the results of a query to drive what is exported: