Export/Import using Datapump

For a new installed DBSchema with DBSchemaVersion >= 8.19 you can use Oracle datapump mechanism to export/import historical data.

Additional to the datapump mechanism, the OMF (Oracle managed files ) will also be used. The parameter "path_event", "path_alert", "path_tmp", "path_dbfile" will not be used anymore if datapump is used. If datapump export/import is used, all database files belonging to tablespaces, will be created as oracle managed files (OMF).

Before installing RDB it is required to doublecheck DB_CREATE_FILE_DEST parameter in Oracle Database. This parameter must be set to a valid destination path, otherwise installation will fail. This parameter can be changed without bouncing the database (shut down and start up) .

Alter system set DB_CREATE_FILE_DEST='<destination_path>' scope=BOTH;

A new Oracle View VTablespace_Mon is also created with DBSchemaVersion 8.19. The VTablespace_Mon is used to monitor the space consumption of a tablespace. In case of space pressure a new datafile will be added to the tablespace with less then 15% free space automatically.