FLUSH

The FLUSH command write all tables loaded until this checkpoint to disk and makes the in-operable for joins, updates, delete and other statements. Tables flushed to disk will be available in the final in-memory datastore and can be used in TARGIT.

/* Write the table to disk and release memory */
FLUSH

/* Import other tables where we don't need to worry about memory */
DO PARALLELIMPORT LOCATIONS=oracledb.{SELECT * FROM LOCATIONS}IMPORT DEPARTMENTS=oracledb.{SELECT * FROM DEPARTMENTS}IMPORT PRODUCTS=oracledb.{SELECT * FROM PRODUCTS}IMPORT EMPLOYEES=oracledb.{SELECT * FROM EMPLOYEES}
END PARALLEL