Performing General tasks for a single table/view
Although the descriptions in this section only refer to tables, the procedures describe herein are applicable to views as well. When a task is being performed for a view, the word "View(s)" will appear in the UI instead of the word "Table(s)"
The General tab in the Table Settings window displays basic information about the selected table and allows you to define new names for the table/schema on the target as well as override the default tablespace for the table and its index (Oracle target only).
To edit the general table settings:
- Open the Table Settings window.
-
Click the General tab on the left side of the window, as shown below.
In the Map to target table section, the following options are available:
- Table Schema: Specify the schema in which you want the table to be created on the target.
- Table Name: Specify a new name for the table on the target.
-
Table tablespace: This option is only available when the task is defined with an Oracle target endpoint.
Specify the name of the tablespace in which you want the table to be created on the target. By default (i.e. when this field is empty), the table will either be created in the source table tablespace on the target (when replicating from an Oracle source) or in the default tablespace (when replicating from any other source).
-
Index tablespace: This option is only available when the task is defined with an Oracle target endpoint.
Specify the name of the tablespace in which you want the table's index to be created on the target. By default (i.e. when this field is empty), the index will either be created in the source table tablespace on the target (when replicating from an Oracle source) or in the default tablespace (when replicating from any other source).