CREATE NICKNAME statement - Examples for the Oracle wrapper
Use the CREATE NICKNAME statement to register a nickname for an Oracle table or view that you want to access. This topic provides a complete example with the required parameters.
The following example shows you how to register a nickname for an Oracle table or view using the CREATE NICKNAME statement.
CREATE NICKNAME PARISINV FOR oraserver."vinnie"."inventory" ;
- A unique nickname that is used to identify the Oracle table or view. The nickname consists of the schema and the nickname. If you omit the schema when you register the nickname, the schema of the nickname will be the authorization ID of the user who registers the nickname.
- A three-part identifier for the remote object:
- oraserver is the server definition name that you assigned to the Oracle database server in the CREATE SERVER statement.
- vinnie is the user ID of the owner to which the table or view belongs.
- inventory is the name of the remote table or view that you want to access.
The federated server changes the names of the Oracle schemas and tables to uppercase unless you enclose the names in quotation marks.