FLUSH

The FLUSH command writes 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 InMemory datastore and can be used in TARGIT.
Syntax:
FLUSH
Example:
/* In this example we are using the Oracle Managed Data provider // and retrieving data from an Oracle database /LOAD ASSEMBLY 'Oracle.ManagedDataAccess.dll'DATASOURCE oracledb=DOTNET CONNECTION 'Oracle.ManagedDataAccess.Client.OracleConnection' 'data source=(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =myOracleServer)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = )));User Id = oracleLogin; Password = readOraclePassword' / Read the SalesInvoiceLines table with 400 mill rows /IMPORT SalesInvoiceLines=oracledb.{SELECT * FROM SALESINVOICELINES}/ Write the table to disk and release memory /FLUSH / Import other tables where we don't need to worry about memory /DO PARALLEL IMPORT 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 / Commit data to disk */SAVE