Subset inserts across linked server

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to do a subset between two different servers using the linked server options. But we are getting the below error while we are trying to generate the scripts.

Can you please explain what exactly the linked server option is used for?

 

Environment

Release : 4.10

Resolution

To use the linked server option, there should be an database link existing from source to target database. 

The purpose of providing Linked Server option is to allow generation of insert scripts with extra identifier( linked server) appended to the object so that those insert statements can be run from source DB itself.

For Database links we have below information in the documentation:

=======================================================================================

Database link:
Specifies whether to use a link to reference target or source tables, or both. If your target schema does not reside on the same server as source, choose the option to use database links to join the tables. This requires that the database link already exists.
Note: Joining tables across DB Links is usually pretty slow, so this option is not recommended.

=======================================================================================

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/provisioning-test-data/subset-production-data/example-generate-insert-scripts-for-oracle-from-subset.html