I have a set of tables in one user and need this to be moved to another user in the same instance, i need to do this dynamically through my procedure or package. The basic idea is to take a export of the specified tables and to put it in the other user. The list of tables to be ported is determined by the records in a configurable table.

Please can someone help me with some suggestions