Oracle Archive Options (Online Help)

Select the archive options.

Data Export Format

• Native

  Store the data in the native database format.

• XML

  Store the data in XML format.

• Parquet

  Store the data in the Parquet format.

Archive Database

Check this box to select the database the data will be archived to.

• Client

  The archive database host. Data is moved here prior to being moved to media.

• Database Name

  The archive database name.

• Connect Details

  The password used to access the Archive Database.

Create uniform view for Archive and History tables

A view is created under the source database that is a union of the source table and archived data.

When the uniform view option is selected the archive job creates views in the source and destination databases as per the archive criteria and UNION ALL of all jobs.

The database views are created by performing a UNION of all jobs by the archive job.

The view is created by default on the destination (archive) database.

The view is created under the same schema used to archive the data, configured at instance properties.

For example if Jobid 100 picks up 2 records with status=’A’ and Jobid 101 picks up 5 records with status=’B’ then both databases have 7 records, using the following:

CREATE OR REPLACE VIEW archiveuser.<table> AS SELECT * FROM source_schema.<table> UNION ALL SELECT * FROM histdb.<table>@<dblink>

Path for the Archive Data Files

The directory path for the archived data file. The datafiles are created in this path.

When you choose to store the data in the XML format, afterr the archive job completes, there are two files per table placed in this directory. There is an xml file type that is in the <Path for Archive Data Files>/Data directory that has the following format:

<SCHEMANAME>.<TABLENAME>.xml

There is an xsd file type that is in the <Path for Archive Data Files>/Config directory that has the following format:

<SCHEMANAME>.<TABLENAME>.xsd

Data Retention Settings

• Archive Tables

  The number of days the data is saved in the history tables on the archive database. The default is 365 days.

• Media

  The number of days the data is saved on the media The default is 1825 days (5 years).

Changing the Column View

All table columns are listed by default. Select the column name and drag it left or right to change the order.

To hide or add columns:

1. Click the Table Menu icon (double arrow that points down) at the last column heading on the right side.

2. Select Choose Columns.

   • To remove a column, select any column with a "√" next to the name. All remaining columns to the right of the removed one are shifted left.

   • To add a column, select any column without a "√" next to the name.