From Ian Smith of Oracle:
If you go the EXPORT and IMPORT route then may I recommend the following:
It already generates an IMPORT script.
Modify the IMPORT command to redefine any indices you want to change. IMPORT will replace the definitions in the RBR file with those on the command line. BUT make sure they are defined inside the IMPORT command (i.e. Only one semicolon)
In V7.1 you can RMU/LOAD from the RBR file (V18.104.22.168 and later documented next release 🙂
RMU/LOAD/MATCH_NAME personnel employees pers.rbr
You can then submit batch jobs to load from the RBR after creating the database using IMPORT … NO DATA.