Oracle: Create Tablespace
Description
This plugin is designed to create a Tablespace into Oracle Database installed on Windows Server and Linux Server OS. The Tablespace is created based on the below input criteria provided by the user.
- SID/Service name of the Oracle Database.
- Type of Tablespace.
- Name of Tablespace.
- Name and Size of Datafile.
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 IP or fully qualified domain name of the Oracle database machine. This field is mandatory. |
| Port Number | The port number of the Oracle database. Port number should only be a positive integer. This field is mandatory. |
| SID/ Service name | The SID/Service name of the Oracle database that uniquely identifies the database instance. This field is mandatory. |
| Username | The username of user having permission to create new Tablespace. For example: sysdba. This field 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 (drop down 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 Type | The Type of Tablespace can be selected from options: Permanent/Temporary/Undo. This is visible in a tooltip. |
| Tablespace Name | The unique name of the tablespace to be created. Datafile Size and AutoExtend are mandatory. |
| Datafile Name | The unique datafile name. 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. This field is mandatory. |
| Datafile size | The size of datafile greater than Zero (0) and should be entered. This field 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 tooltip 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 tooltip. This field is mandatory. |
| Tablespace status | The status of Tablespace can be ‘Online/Offline’. The default value is Online. This is visible in a tooltip. It should be entered as Online or Offline. |
| OUTPUT TAB: | Output fields |
| Result | Output field to hold the result returned from Oracle. |