Unanswered: create an exact replica of specific tables in one user to another
I have a development env. and production env in the same instance of oracle. I need to copy some of the tables in the test env. to the production env dynamically .i.e, the tables to be ported will be specified in a configurable table in the test env. My procedure should copy the specified tables to the prod. env. when my procedure is excuted.
Please can any one help me on how to do this.