Oracle Replay feature in Teradata?

Database
Enthusiast

Oracle Replay feature in Teradata?

Is there a way to record Production SQL queries and workloads so that they can be replayed in another environment?

Kind regards,

Steven

Tags (3)
4 REPLIES
Junior Supporter

Re: Oracle Replay feature in Teradata?

Steven:

You may take a look at Teradata System Emulation Tool.

HTH.

Cheers.

Carlos.

Enthusiast

Re: Oracle Replay feature in Teradata?

Thanks Carlos I will do.

Steven

Enthusiast

Re: Oracle Replay feature in Teradata?

I can see that the tool has a degree of control over connectivity but is it possible to schedule and monitor SET exports/imports from the command line?

Also how long would it take to complete a SET export/import a 100TB database - days/hours/minutes?

Kind regards,

Steven

Junior Supporter

Re: Oracle Replay feature in Teradata?

Steven:

If you want to move big volumes between systems, you could try Datamover or you could write your own processes. The time will vary depending on many factors (hardware, communications, etc...)

HTH.

Cheers.

Carlos.