Table duplication

Anand K · Post by **Anand K** » Thu Jul 29, 2004 11:54 pm

Hi All

I have to create/replicate some tables from one schema to another.
There are no stages between the Source Oracle stage and the Target Oracle stage

If there are 10 tables I am creating 10 different jobs for the same.
Please let me know if there is a work around for the same like parameter substitution or anything of that sort...
Also the structure varies from table to table.

Thanks in advance

Anand K

rasi · Post by **rasi** » Fri Jul 30, 2004 1:45 am

You can't change the metadata dynamically and execute multiple times with different parameter. The best thing is to create sql files and call from datastage by passing parameters

Siva

ray.wurlod · Post by **ray.wurlod** » Fri Jul 30, 2004 4:55 am

This is an example where DataStage is probably unnecessary. Use Oracle bulk unloader to unload to stdout, and pipe that result to Oracle bulk loader to load from stdin.