Use this screen to specify your tablespace mapping information.
This screen only appears if you selected the Create option on the Create Repository screen.
Topics:
Click Next when you are finished with your tablespace information. A screen will appear asking you to confirm the creation of tablespaces for any new schemas.
Note:
RCU only creates tablespaces for those components associated with RCU.
After you click OK to continue, a screen indicating the progress of the tablespace creation will appear.
In the Default Tablespace and Temp tablespace columns, you can click on the tablespace cell to select from a list of available additional tablespace names.
The default tablespace mapping for each component is shown in the Repository Creation Utility Schemas, IDs, and Tablespaces topic in the Creating Schemas with the Repository Creation Utility.
Note:
OID tablespace names cannot be user specified.
You can have your components use as many or as few tablespaces as desired to suit your configuration.
To change the default tablespace for a component, select the tablespace name in the Default Tablespace column, then select the tablespace name you want to use from the drop-down list.
To change the temporary tablespace for a component, select the tablespace name in the Temp Tablespace column, then select the tablespace name you want to use from the drop-down list.
Some components have additional tablespaces associated with their schemas, which you can view or change for a component.
If this is the case, the Additional Tablespaces button appears on this screen. If none of the selected components have additional tablespaces, then this button does not appear.
To view additional tablespaces associated with the selected components, click the Additional Tablespaces button.
To change the tablespace you want to use for a component, click in the Tablespace Name column and select the tablespace you want to use from the drop-down list.
To manage your tablespaces and datafiles, click the Manage Tablespaces button.
Only tablespaces that will be created by RCU can be modified or removed. Tablespaces that existed before RCU was launched are visible on this screen but are grayed out and cannot be modified or removed.
Only tablespaces that are used by a component are created. You can specify a new tablespace here, but unless it is actually used by a component it will not be created.
To modify a tablespace, select the tablespace name on the left-hand portion of the screen, and edit the fields as described in this table:
| Field | Description |
|---|---|
|
Name |
Edit the tablespace name this field to change the name of your tablespace. |
|
Type |
Specify whether you want this tablespace to be a temporary tablespace or permanent tablespace. |
|
Block Size (KB) |
Specify the block size (in Kilobytes) to be used for data retrieval. |
|
Storage Type |
Select Use Bigfile Tablespace if you want to create a bigfile tablespace; this is typically used if you have single large files instead of multiple small files. Select Use Automatic Segment Space Management if you want to use bitmaps to manage the free space within segments. |
To add a tablespace, click Add and specify the same details as in the table (for modifying a tablespace) for your new tablespace.
To remove a tablespace, select the tablespace name from the navigation tree, then click Remove. This tablespace will not get created.
In the Datafiles section, specify the datafiles that make up the selected tablespace.
Select one of these procedures for more information:
To add a datafile, click the icon with the plus sign (+).
The Add Datafile screen appears.
| Field | Description |
|---|---|
|
File Name |
Specify the name of the datafile. Note: Datafile names must be less than 30 characters in length, and names with a dash or hyphen (-) character are not permitted. |
|
File Directory |
Specify the location where this datafile will reside. |
|
Size |
Specify the initial size of the datafile. Use the drop-down list to specify the size in kilobytes (KB), megabytes (MB), or gigabytes (GB). |
|
Automatically extend datafile when full (AUTOEXTEND) |
Select Automatically extend datafile when full (AUTOEXTEND) if you want to automatically extend the size of your datafile when it becomes full. In the "Increment" field, specify the size by which your datafile should be increased each time it becomes full. Use the drop-down list to specify the size in kilobytes (KB), megabytes (MB), or gigabytes (GB). If you want to limit maximum size of the datafile, specify this value in the Maximum Size field. |
You can edit a datafile.
To modify or edit a datafile, select the icon next to the datafile name you want to edit, then click the icon with the pencil.
The Edit Datafile screen appears.
Provide the information described in this table:
| Field | Description |
|---|---|
|
File Name |
Specify the name of the datafile. Datafile names must be less than 30 characters in length, and names with a dash or hyphen (-) character are not permitted. |
|
File Directory |
Specify the location where this datafile resides. |
|
Size |
Specify the initial size of the datafile. Use the drop-down list to specify the size in kilobytes (KB), megabytes (MB), or gigabytes (GB). |
|
Automatically extend datafile when full (AUTOEXTEND) |
Select Automatically extend datafile when full (AUTOEXTEND) if you want to automatically extend the size of your datafile when it becomes full. In the Increment field, specify the size by which your datafile should be increased each time it becomes full. Use the drop-down list to specify the size in kilobytes (KB), megabytes (MB), or gigabytes (GB). If you want to limit maximum size of the datafile, specify this value in the "Maximum Size" field. |