Import/ Export limitations

Due to space limitations on my development server, I need to create a smaller export of my Oracle Tables.

I can identify 40 - 75 tables which I can reduce the amount of data (to only contain data from the past 2 years). I can use the IMPORT parameters: TABLES = AND QUERY = to limit the data in these Tables.

However, I still have 850 more tables I need to export/ import in another Export File. Is there a way to limit this export so it doesn't contain the 40-75 tables I plan on exporting seperately??

you will have to list all the tables you want to export individually

Thanks.

Do you know if there is a limit to the number of tables I can specify in the EXPORT parameter file?

I've exported over 2000 before