My Oracle Support Banner

Answer some questions related to dynamic load queries (Doc ID 1501428.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.8.3 and later
Information in this document applies to any platform.

Goal

Answer some questions regarding to dynamic load queries.

 

NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem discussed in this note.

Here is the cache group configuration:

 

CREATE DYNAMIC ASYNCHRONOUS WRITETHROUGH CACHE GROUP consumerawt
FROM CUSTOMERPNR.DYN_CUSTOMER
(CUSTOMER_ID  VARCHAR2(20 BYTE)  NOT NULL PRIMARY KEY),
CUSTOMERPNR.DYN_PV
(
 EAN            VARCHAR2(15 BYTE),
 USER_ID        VARCHAR2(20 BYTE),
 CUSTOMER_ID    VARCHAR2(20 BYTE)              NOT NULL,
 HIT_TIMESTAMP  TIMESTAMP(6) not null,
 SOURCE_CODE    VARCHAR2(20 BYTE),
primary key (EAN,USER_ID,CUSTOMER_ID),
FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMERPNR.dyn_CUSTOMER(CUSTOMER_ID)),
customerpnr.DYN_OD
(
 CUSTOMER_ID  VARCHAR2(20 BYTE)    DEFAULT '-9'   NOT NULL,
 EAN          CHAR(13 BYTE)        DEFAULT '-9'   NOT NULL,
 ORDER_DATE       DATE                         DEFAULT '1900-jan-01' NOT NULL,
 SOURCE       VARCHAR2(10 BYTE),
primary key (CUSTOMER_ID,EAN,ORDER_DATE),
FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMERPNR.DYN_CUSTOMER(CUSTOMER_ID));

 

 

 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.