A file generated with the ORACLE function EXP containing any section of an ORACLE database can be loaded into an ADABAS database by using LOAD.
Syntax:
LOAD executes the definition (DDL) statements contained in the file. When doing so, the ORACLE statement GRANT CONNECT is converted into the ADABAS statement CREATE USER and the username is defined as password. As for CATALOGLOAD ALL, the ORACLE statement CONNECT <user> is used as LOAD statement OWNER <user> to change the current user. All ORACLE statements starting with one of the keywords ALTER, COMMENT, CREATE, or GRANT are executed in SQLMODE ORACLE.
INSERT statements are converted into a DATALOAD or FASTLOAD statement and executed immediately, like the DDL statements. The data to be loaded is in this way read from the following lines of the input file and converted from the available internal ORACLE format.
The statements are recorded in the protocol file in the way in which they are executed by LOAD.
Every user can perform LOAD ORACLEDB as long as database objects are created for this user. If the input file requires a change to another user, the run is aborted when the executing user is not the SYSDBA.