The core element of any statement within a distributed query is the database segment. Using the syntax of both of these segments, you can specify a remote database server, database, or database object.
The Database Name segment is used to specify the name of a database. The following examples show different ways of specifying a remote database:
empinfo@personnel '//personnel/empinfo'
The Database Object Name segment is used to specify the name of a database object, including constraints, indexes, triggers, any synonyms. The following examples show how to access remote objects:
empinfo@personnel:markg.emp_names empinfo@personnel:emp_names
If you are running a distributed query where Extended Parallel Server is both the coordinator and participant, you can specify a coserver as part of the database and database object segments. The following examples show how to specify the coserver id:
orders@stores.2 empinfo@personnel.3:emp_names