...
Property Name | Property Code | Required | Description |
---|---|---|---|
Oracle Database User |
| Yes | The username that will be used to connect to the target Oracle Database. |
Oracle Database Password |
| Yes | The password for Oracle Database User. |
SQLPlus Path |
| No | Provide the sqlplus path (Required if sqlplus is not on PATH environment). ( Ex: |
SQLPlus Source Script |
| No | Source Script with full path. (Ex: |
Oracle SID |
| No | Provide the Oracle SID (optional if it is already set in the source script). |
...
This operation will randomly execute on one of the endpoints identified during selection.
Special Considerations
login.sql
The script that you provided in the input FDSQLPLUS_INP_LOGIN_SQL_FILE
will be created as the login.sql file in the current working directory. The login.sql script file in SQLPlus is executed automatically whenever you start SQLPlus. It can be used to set up your SQL*Plus environment, including setting formatting options, environment variables, and other session settings.below
Below the is the example script . we can customize based on requirement
...