Oracle: Extend Tablespace
Description
This plugin is designed to extend a Tablespace by adding datafile or tempfile into Oracle Database located on Windows Server. The Tablespace is created based on the below input criteria provided by the user.
- SID/Service name of the Oracle Database.
- Name of Tablespace.
- Name and Size of Datafile.
- AutoExtend
Prerequisites
- Oracle 11g/12c environment on Windows
- Oracle 12c environment on Linux.
- Sufficient privileges to create the tablespace (preferably sysbda privileges).
- ojdbc6.jar must be present in lib folder of Process Studio as well as AE agent.
- While testing on Oracle 12c Windows/Linux the pluggable database should be open before performing any action.
- For connecting to the Oracle Server, OracleOraDB12homeTNSListener & OracleServiceORCL should be started.
Configurations
| Field name | Description |
|---|---|
| Step Name | Specify a unique step name. |
| CONNECTION | |
| Server Name/IP | The port number of the Oracle database. Port number should only be positive integer. Port Number is mandatory. |
| SID/ Service name | The SID of the Oracle database that uniquely identifies the database instance. SID is mandatory. |
| Username | The username having permission to create new Tablespace. For example: sysdba. Username is mandatory. |
| Password: | |
| Accept Values from fields | Enable this checkbox to accept Password value from a field in the previous steps of the stream using a dropdown list. |
| Password | The password for the Oracle username to authenticate. This field is mandatory. Password is entered using a widget called SecuredComboVar. The widget handles both Text Var(static value or environment variable) and Combo (dropdown containing values from previous steps). This field is mandatory. If checkbox above is enabled Password field appears as Text Var. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps. |
| Test Connection | Verifies whether the connection is established or not. Note: Test Connection button does not work for previous step variables. Test Connection button only works with static values and environment variables. |
| INPUT TAB: | Input fields |
| Tablespace Name | The unique datafile name. Tablespace Name is mandatory. |
| Datafile Name | The size of datafile greater than Zero (0M). It is not required to mention the extensions of datafile in the plugin. It will be handled internally depend upon the type of tablespaces. Datafile size should not be Lesser than or equal to Zero. Datafile Name is mandatory. |
| Datafile Size | Size of datafile automatically extends if Autoextend for datafile if set to ON in the database. In this plugin Datafile size should not be Lesser than or equal to Zero. The size of datafile should be greater than Zero (0). Datafile Size is mandatory. |
| Size Unit(K/M/G/T) | A size unit such K, M, G or T should be provided in the Size Unit field for the Datafile size chosen above. This is visible in a tool tip as well. This field is mandatory. |
| AutoExtend | Automatically extends the size of datafile if set to ON. It should be entered as On or Off. This is visible in a tool tip. AutoExtend is mandatory. |
| OUTPUT TAB: | Output field |
| Result | Output field to hold the result of the successful plugin execution. |