pipe data???

[wallace]

just a quick newbie question ...
i want to pipe data from an oracle test instance to an oracle prod instance. is "export/import" the best way to do this. how about "data generator"???

thanks,
wallace.

 

[Marco Kalter]

The data generator will generate pseudo random data for testing and optimization purposes, so that is not a good choice. You can indeed use Export/Import for this.

 

[William Robertson]

Or see Oracle Data Pump . You don't mention your Oracle version so I assume it is 10g