Pre-Creating the PeopleSoft Table Structures Using PeopleSoft Data Mover

Sign on to the newly created Oracle database with PeopleSoft Data Mover in bootstrap mode using the database administrator ID and password.

Once signed in, execute the following Data Mover script, substituting output_file with the name of the structural export file you created in PeopleSoft Data Mover previously:

SET NO TRACE;
SET NO DATA;
SET INPUT output_file;
SET LOG log_file;
SET UNICODE ON;
SET STATISTICS OFF;
SET ENABLED_DATATYPE 9.0;
IMPORT *;

This script creates all the tables in the original PeopleSoft database in the new database but with no rows of data. You can speed up the data load time by adding the command SET NO INDEX; If you do that, remember to create them in Application Designer later.

Note:

The ENABLED_DATATYPE 9.0 command applies only if the PeopleSoft application version is 9.0 or higher. With this flag set, the VARCHAR2 columns will use character semantics instead of byte semantics..The ENABLED_DATATYPE command is related to the NLS_CHARACTER_SEMANTICS setting in the init.ora file. The NLS_CHARACTER_SEMANTICS is not set at the beginning of database creation, but is added to the init.ora file before connecting to Data Mover.

To check the effect of these parameters after the structural import, in sqlplus run the command desc PSSTATUS and verify that the CHAR fields are defined as VARCHAR2(n CHAR) rather than VARCHAR2 (nx3).