Try OpenEdge Now
skip to main content
Configuring Multi-tenancy
Managing multi-tenant databases : Managing a multi-tenant database : Loading database contents : Loading table contents to a database
 
Loading table contents to a database
The Database Administration console uses the .d files to load table contents from the sub-directory for tables you specify.
To load table contents:
1. In the management console menu, do one of the following:
*Select Database Administration > Load > Table Contents (.d files).
*Select Database Administration > Go to Database Administration. The Database Administration page appears.
Filter or search for, and select the required database connection. The database connection home page appears.
In the Data Administration section, click Load table contents (.d file).
The Load Table Contents page for the selected database connection appears.
2. In the Database connection field, enter a database connection name that contains the database into which you want to load the table contents.
By default, the last used database connection name appears in the Database connection field.
You can select another database connection by entering a database name in the Database connection field.
Note: If you type the name of the database connection, follow the format used by OpenEdge Management/OpenEdge Explorer to define a connection: AdminServer-name.database-name. A database server must be running for you to connect to the database.
You can also click the Search icon to choose a database for which you are creating the tenant from the Connection Selection dialog.
The Connection Selection dialog displays the connections details in a grid. You can perform the following:
*Filter the connections in the grid by Connection name, AdminServer, and/or Category.
*Select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the connections to appear in the grid.
Note: When you select a database connection name, the Database connection field displays the selected database connection name. Most of the other fields get auto-populated with the default values, based on the selected database connection name.
3. In the Load root directory field, specify a file path of the contents (.d) file. By default, this field displays the work directory C:\OpenEdge\WRK.
4. Select Include LOB to enable importing of large database objects, such as images. By default, this check box is selected.
5. In the LOB sub-directory field, specify a sub-directory name that contains the large database objects that you want to load. By default, this field displays lobs and this sub-directory is contained in the default work directory C:\OpenEdge\WRK.
6. In the Acceptable error percentage field, specify an acceptable error percentage. The default value is 0.
7. In the Group sub-directory field, specify a sub-directory name which contains group contents in.d files. By default, this field displays groups and this sub-directory is contained in the default work directory C:\OpenEdge\WRK.
8. Select the Skip secured tables check box, if you do not want to load secured tables.
9. Select the Do not load group tables check box, if you do not want to load the group tables.
10. Select the Skip missing directories check box, to skip validating the missing sub-directories mentioned under the root directory when loading table contents.
11. Select one of the following options for Tables:
Option
Description
All 1
Load contents to all shared and multi-tenant tables. By default, this option is selected.
All shared tables
Load contents to all shared tables only.
Note: This option is available only for multi-tenant database connections.
All multi-tenant tables
Load contents to all multi-tenant tables only.
Note: This option is available only for multi-tenant database connections.
Selected
Load content either to one or many, shared and/or multi-tenant tables. This option appears both for multi-tenant and non-multi-tenant database connections. Selecting this option displays the Selected Tables section.

1 Databases that are not enabled for multi-tenancy do not have shared or multi-tenant tables.

If you choose the Selected option for Tables, the Selected Tables section appears.
In the Selected Tables section, do the following:
a. In the Table name field, enter a table name. You can specify a keyword, use the wildcard operator *, or a combination of both.
b. In the Database area field, specify a database area name which contains the tables you want to view. When you type a keyword in this field, the console lists database areas matching your keyword. You can select a database area name. For example, if you type Cu, the console lists the database areas Cust_Data and Cust_Index.
c. Select one of the following options (available only for multi-tenant databases):
*Show shared and multi-tenant — to view tables that are both shared and multi-tenant. By default, this option is selected.
*Show shared — to view only shared tables.
*Show multi-tenant — to view only multi-tenant tables.
d. Select the Show hidden check box to view any hidden tables from the database.
e. Click Apply Filter. Based on your search criteria, the Selected Tables section lists the table names and displays the following columns:
Column name
Description
Schema
Displays whether the schema associated with the database table is public or user-defined. The default value is PUB which indicates that the default public schema is assigned to the OpenEdge database.
Table name
Displays the name of tables in an ascending alphabetical order.
Area
Displays the area in the database in which the table resides.
Multi-Tenant
Displays true for multi-tenant tables and false for shared tables.
Description
Displays details associated with the table name. This column is optional. To view this column, click any of the column's drop-down and select Columns > Description check box.
12. Select Tenants based on whether you access the database as a regular or a super user.
Note: In the case of multi-tenant database connections, you must provide either regular or super user credentials to dump or load tenant data. Refer to Managing users in a multi-tenant database. If you do not provide any credentials for database authentication, you can dump or load only default database tables.
*For regular tenant user credentials, Tenants displays a preselected radio button for the regular tenant and you can only load contents to the tables within that specific regular tenant.
*For super-tenant user credentials, Tenants displays two options for you to select and load contents to the tables included within these tenants.
You can choose All to select all the regular tenants or Selected to filter one or more tenants. Upon choosing Selected, the console displays the Selected Tenants section.
You can enter either a keyword, the wildcard operator *, or a combination of the two in the Tenant name field. Click Apply filter to view the Tenant name and the Description in the respective columns. Use the check boxes to select or clear any of the tenant entries.
Optionally, you can click the columns drop-down to select options such as Type, Id, External Id, and Data Enabled to display the respective tenant properties. Similarly, you can clear the check box to remove any of the columns from the Selected Tenants view.
The option for displaying tenants is not available for non-multi-tenant databases.
13. Click Load.
A confirmation dialog appears for table data load displaying the number of shared and multi-tenant tables that will be loaded.
14. Do one of the following:
*Click Commit to load the contents of the selected tables. You can view status of such a task in the Database Administration Tasks page by selecting Database Administration > View > Database Tasks.
*Click Commit & Monitor to load the contents of the selected tables, and view the task page. This page lists the details of the load activity performed.
*Click Cancel to exit the dumping process.
When this operation is successful, the contents from the .d file in the load directory that you specify (in this case, the work directory C:\OpenEdge\WRK) are imported into the database tables.