Oracle Cloud Infrastructure Documentation

Reset the Data Warehouse

Reset your data warehouse when your data source instance is refreshed from another environment, for example, when the environment is refreshed from production to a test environment. You may also want to reset the data warehouse when the data becomes corrupt.

Tutorial icon LiveLabs Sprint

Prior to resetting the data warehouse, you must have at least one activated functional area. After resetting the data warehouse, the last refresh date shows the last increment details. You must reactivate all the data pipelines for the functional areas to load data. See Activate a Data Pipeline for a Functional Area

.
Note

Your data isn't available until Oracle Fusion Data Intelligence completes all the activations after resetting the data warehouse.
  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Enable Features, click Generally Available tab, and then under Pipeline Features, enable Reset Data Warehouse.
  3. Navigate to Data Configuration under Application Administration in the Console.
  4. On the Data Configuration page, under Configurations, click Pipeline Settings.
  5. On the Pipeline Settings page, click Actions and then click Reset Data Warehouse.

    Description of fawag_reset_data_warehouse.png follows

  6. Review the warning message, provide the details, and then click Reset.

    Description of fawag_reset_data_warehouse_warning.png follows