Try OpenEdge Now
skip to main content
Basic Database Tools
Table Tasks : Loading table contents : Loading data into a multi-tenant database

Loading data into a multi-tenant database

If you are logged in as a super-tenant to a multi-tenant database, the process of loading table data allows you to load data for a specific tenant.
You can choose between all tables, multi-tenant tables, or shared tables. If you choose to dump the contents of a multi-tenant table, you are required you to specify an effective tenant, as follows:
To load table contents into a multi-tenant table:
1. Choose Admin > Load Data and Definitions > Table Contents (.d files) from the menu bar. The Data Dictionary alphabetically lists all the tables defined for your database (hidden tables do not display).
2. Select the table names whose contents you want to load. Use the Select Some and Deselect Some buttons to select or deselect groups of tables. You can narrow your selection by choosing only Multi-tenant tables or only Shared tables.
3. Press GO.
4. Identify the Effective Tenant of the data being loaded. You can enter a name, or choose from a list with Select Tenant.
5. Use Default Location is selected by default, and indicates that data is to be loaded from a subdirectory named after the effective tenant. You can use the current directory as your starting point, or specify a different directory in the Root Directory field.
If you deselect Use Default Location, then Root Directory is inactive, and you must specify the input file.
6. If your load contains large objects, accept the Include LOB default of yes; otherwise, choose no.
7. If you chose yes in Step 6, and also specified Use Default Location, the LOB directory field is inactive. If you did not specify Use Default Location, type in the LOB directory field the name of the directory that contains the LOB.
8. Specify the error rate.
As the Data Dictionary loads records from any files you designate, it might encounter data that cannot be loaded. The Data Dictionary does not load the record. It places all erroneous records in a table.e file (the name of the table with a .e extension). If you specify an error rate of 10 percent, the Data Dictionary must successfully load 90 records from every set of 100 records loaded.
9. Select Output Errors to Screen to view error messages generated while loading table data. The default output for errors is to a file.
10. Choose OK. After loading the table contents, the Data Dictionary displays a status message and prompts you to continue.
11. Choose OK to return to the Data Dictionary main window.
Note: For more information on multi-tenant databases, see OpenEdge Getting Started: Multi-tenancy Overview.