If I have about 500 tables in the schema, how can I move these 500 tables to different schema with this condition: we only want 100 tables out of this 500 with data and the rest without data, and we don't want to do the full exp/imp with data and then truncate the data b/c this may cause FK violation.

Any thoughts???

thanks