Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Business Analytics Warehouse for Oracle 11i >

Modifying the Last Extract Date


By default, the $$LAST_EXTRACT_DATE is set to 01/01/1970 for Oracle 11i. However, if you need to modify this date, you can do so by modifying the parameterfileOLTP.txt file. After you have modified the file, the next time you run the session, the new Last Extract date is populated.

To modify the Last Extract date

  1. Open the parameterfileOLTP.txt file.
  2. Replace the default Last Extract date with the new Last Extract date.

    Perform this action for all applicable sessions.

  3. Save and close the file.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.