FBDA: ORA-08181 During a flashback versions query on an flashback data archive enabled table

(Doc ID 2408006.1)

Last updated on JUNE 06, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

ORA-08181 During a Flashback Version Query against a Flashback Data Archive enabled table.

Error: "ORA-08181: specified number is not a valid system change number " with this query FBVQ:

 SELECT VERSIONS_STARTSCN,
  VERSIONS_STARTTIME,
  VERSIONS_ENDSCN,
  VERSIONS_ENDTIME,
  VERSIONS_XID,
  VERSIONS_OPERATION,
  R_CUST_PART_NUM,
  B_HH_SYS_ID,
  B_MBR_NUM,
  B_SYS_ID,
  B_MBR_BEG_DT,
  B_MBR_END_DT,
  B_HH_ALT_ID,
  B_REL_CD,
  B_HH_SSN_NUM_TX,
  G_AUD_ADD_USER_ID,
  G_AUD_ADD_TS,
  B_ELIG_ACT_DT,
  B_ELIG_VD_IND,
  B_TERM_RSN_CD,
  B_PREG_IND,
  B_PREG_BEG_DT,
  B_PREG_END_DT,
  G_AUD_USER_ID,
  G_AUD_TS,
  B_HH_ALT_ID_CD
  FROM FDAUSER.FDATEST VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;

ORA-08181: specified number is not a valid system change number

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms