Skip Headers
Oracle® Database Data Warehousing Guide
11g Release 2 (11.2)

E25554-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

aggregates, 9.2.1, 19.7.5
computability check, 19.1.3.4
ALL_PUBLISHED_COLUMNS view, 17.9.6
ALTER MATERIALIZED VIEW statement, 9.3
altering dimensions, 11.6
amortization
calculating, 23.5
analysis tools
described, 1.3.1.9
analytic functions, 23.3.5
concepts, 22.1
analytic processing
materialized views, 10.2
applications
data warehouses
star queries, 20.3
decision support systems (DSS), 7.1.1
architecture
data warehouse, 1.2
asynchronous Autolog publishing
source database performance impact, 17.6.2, 17.6.2, 17.6.2
asynchronous AutoLog publishing
latency for, 17.6.2, 17.6.2
location of staging database, 17.6.2, 17.6.2
requirements for, 17.6.1.1
setting database initialization parameters for, 17.6.3.4
asynchronous Change Data Capture
archived redo log files and, 17.11.1
ARCHIVELOGMODE and, 17.11.1
supplemental logging, 17.11.2
supplemental logging and, 17.2.2
Asynchronous Change Data Capture
columns of built-in Oracle datatypes supported by, 17.11.4
asynchronous change sets
disabling, 17.9.2.2
enabling, 17.9.2.2
exporting, 17.9.5.1
importing, 17.9.5.1
managing, 17.9.2
recovering from capture errors, 17.9.2.4
example of, 17.9.2.4.1, 17.9.2.4.2
removing DDL, 17.9.2.4.2
specifying ending values for, 17.9.2.1
specifying starting values for, 17.9.2.1
stopping capture on DDL, 17.9.2.3
excluded statements, 17.9.2.3
asynchronous change tables
exporting, 17.9.5.1
importing, 17.9.5.1
asynchronous Hotlog publishing
source database performance impact, 17.6.2
asynchronous HotLog publishing
latency for, 17.6.2
location of staging database, 17.6.2
requirements for, 17.6.1.1
setting database initialization parameters for, 17.6.3.2, 17.6.3.3, 17.6.3.4, 17.6.3.4
attributes, 2.2, 11.2
Automatic Storage Management, 4.2

B

bind variables
with query rewrite, 19.3.11
bitmap indexes, 7.1
nulls and, 7.1.3
on partitioned tables, 7.1.4
parallel query and DML, 7.1.1, 7.1.1
bitmap join indexes, 7.1.5
B-tree indexes, 7.2
bitmap indexes versus, 7.1.2
build methods, 9.3.4
business intelligence
queries, 24
business rules
violation of, 15.4.1

C

capture errors
recovering from, 17.9.2.4
cardinality
degree of, 7.1.2
CASE expressions, 22.7.3
cell referencing, 23.2.4
Change Data Capture, 13.2.3
asynchronous
Streams apply process and, 17.6.4
Streams capture process and, 17.6.4
benefits for subscribers, 17.1.3.2
choosing a mode, 17.6.2
effects of stopping on DDL, 17.9.2.3
latency, 17.6.2
location of staging database, 17.6.2
modes of data capture
asynchronous AutoLog, 17.2.2.3
asynchronous Distributed HotLog, 17.2.2.2
asynchronous HotLog, 17.2.2.1
synchronous, 17.2.1
Oracle Data Pump and, 17.9.5
removing from database, 17.12
restriction on direct-path INSERT statement, 17.10.1
setting up, 17.6
source database performance impact, 17.6.2
static data dictionary views, 17.5
supported export utility, 17.9.5
supported import utility, 17.9.5
synchronous, 13.2.3.3
systemwide triggers installed by, 17.12
Change Data Capture publisher
default tablespace for, 17.6.1.2
change sets
defined, 17.3
effects of disabling, 17.9.2.2
managing asynchronous, 17.9.2
synchronous Change Data Capture and, 17.3
valid combinations with change sources, 17.3.1
change sources
asynchronous AutoLog Change Data Capture and, 17.2.2.3
asynchronous Distributed HotLog Change Data Capture and, 17.2.2.2
database instance represented, 17.3.1
defined, 17.1.3.1, 17.1.3.1
HOTLOG_SOURCE, 17.2.2.1
SYNC_SOURCE, 17.2.1
valid combinations with change sets, 17.3.1
change tables
adding a column to, 17.9.6
control columns, 17.9.4.2
defined, 17.1.3.1
dropping, 17.9.4.7
dropping with active subscribers, 17.9.4.7
effect of SQL DROP USER CASCADE statement on, 17.9.4.7
exporting, 17.9.5
granting subscribers access to, 17.9.4.5
importing, 17.9.5
importing for Change Data Capture, 17.9.5.3
managing, 17.9.4
purging all in a named change set, 17.9.4.6
purging all on staging database, 17.9.4.6
purging by name, 17.9.4.6
purging of unneeded data, 17.9.4.6
source tables referenced by, 17.9.4.1
tablespaces created in, 17.9.4.1
change-value selection, 17.1.1
columns
cardinality, 7.1.2
COMMIT_TIMESTAMP$
control column, 17.9.4.2
common joins, 19.1.3.1.1
COMPLETE clause, 9.3.7
complete refresh, 16.3.1
complex queries
snowflake schemas, 20.3.1
composite
columns, 21.6
compression
See data segment compression, 9.3.3
concatenated groupings, 21.7
concatenated ROLLUP, 21.10.1
configuration
bandwidth, 4.1.1
constraints, 8.1, 11.4
foreign key, 8.3.2
RELY, 8.3.3
states, 8.2
unique, 8.3.1
view, 8.3.7, 19.3.6
with partitioning, 8.3.6
with query rewrite, 19.7.1
control columns
used to indicate changed columns in a row, 17.9.4.3
controls columns
COMMIT_TIMESTAMP$, 17.9.4.2
CSCN$, 17.9.4.2
OPERATION$, 17.9.4.2
ROW_ID$, 17.9.4.2
RSID$, 17.9.4.2
SOURCE_COLMAP$, 17.9.4.2
interpreting, 17.9.4.3
SYS_NC_OID$, 17.9.4.2
TARGET_COLMAP$, 17.9.4.2
interpreting, 17.9.4.3
TIMESTAMP$, 17.9.4.2
USERNAME$, 17.9.4.2
XIDSEQ$, 17.9.4.2
XIDSLT$, 17.9.4.2
XIDUSN$, 17.9.4.2
cost-based rewrite, 19.1.1
CREATE DIMENSION statement, 11.2
CREATE MATERIALIZED VIEW statement, 9.3
enabling query rewrite, 18.2
CREATE SESSION privilege, 17.6.1.1
CREATE TABLE privilege, 17.6.1.1
CSCN$
control column, 17.9.4.2
CUBE clause, 21.3
partial, 21.3.3
when to use, 21.3.1
cubes
hierarchical, 10.2.1
materialized views, 10.2.1
CUME_DIST function, 22.2.1.3

D

data
partitioning, 5.1
purging, 16.2.3, 16.2.3
sufficiency check, 19.1.3.2
transformation, 15.3
transportation, 14.2.1
data compression
See data segment compression, 9.3.3
data cubes
hierarchical, 21.7.1
data densification, 22.5
time series calculation, 22.6
with sparse data, 22.5.2
data dictionary
asynchronous change data capture and, 17.7.4
data extraction
with and without Change Data Capture, 17.1.2
data marts, 1.2.3
data rules
violation of, 15.4.2
data segment compression, 3.2.3.1
materialized views, 9.3.3
partitioning, 3.2.3.1
data transformation
multistage, 15.1.1.1
pipelined, 15.1.1.2
data warehouse, 9.1
architectures, 1.2
dimension tables, 9.1.6
dimensions, 20.3
fact tables, 9.1.6
logical design, 2.2
physical design, 3.1
refresh tips, 16.3.9
star queries, 20.3
database
staging, 9.1
database initialization parameters
adjusting when Streams values change, 17.6.4
date folding
with query rewrite, 19.3.5
DBA role, 17.6.1.1
DBMS_ADVISOR.TUNE_MVIEW package, 9.3.5
DBMS_CDC_PUBLISH package, 17.1.3.1
privileges required to use, 17.6.1.1
DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE PL/SQL procedure, 17.9.4.7
DBMS_CDC_PUBLISH.PURGE PL/SQL procedure, 17.9.4.6, 17.9.4.6
DBMS_CDC_PUBLISH.PURGE_CHANG_SET PL/SQL procedure, 17.9.4.6
DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE PL/SQL procedure, 17.9.4.6
DBMS_CDC_SUBSCRIBE package, 17.1.3.2
DBMS_CDC_SUBSCRIBE.PURGE_WINDOW PL/SQL procedure, 17.9.4.6
DBMS_ERROR package, 15.4.2.2
DBMS_JOB package, 17.9.4.6
DBMS_MVIEW package, 16.3.5, 16.3.5
EXPLAIN_MVIEW procedure, 9.7.1
EXPLAIN_REWRITE procedure, 19.6.2
REFRESH procedure, 16.3, 16.3.6
REFRESH_ALL_MVIEWS procedure, 16.3
REFRESH_DEPENDENT procedure, 16.3
DBMS_STATS package, 19.1.1
decision support systems (DSS)
bitmap indexes, 7.1.1
degree of cardinality, 7.1.2
DENSE_RANK function, 22.2.1.1
densification
data, 22.5
design
logical, 3.1
physical, 3.1
dimension levels
skipping, 11.2
dimension tables, 2.4, 9.1.6
normalized, 11.2.3
dimensional modeling, 2.2
dimensions, 2.4.2, 11.1, 11.4
altering, 11.6
analyzing, 21.1.1
creating, 11.2
definition, 11.1
dimension tables, 9.1.6
dropping, 11.7
hierarchies, 2.4.2.1
hierarchies overview, 2.4.2.1
multiple, 21.1.1
skipping levels, 11.2
star joins, 20.3
star queries, 20.3
validating, 11.5
with query rewrite, 19.7.2
direct-path INSERT statement
Change Data Capture restriction, 17.10.1
disk redundancy, 4.1.3
DML access
subscribers, 17.9.4.5
downstream capture, 17.7.4
drilling down, 11.1
hierarchies, 11.1
DROP MATERIALIZED VIEW statement, 9.3
prebuilt tables, 9.4
dropping
dimensions, 11.7
materialized views, 9.6
dropping change tables, 17.9.4.7

E

ENFORCED mode, 18.2.3
entity, 2.2
error logging, 15.4
table, 15.4.2.2
errors
handling, 15.4
ORA-31424, 17.9.4.7
ORA-31496, 17.9.4.7
ETL. See extraction, transformation, and loading (ETL), 12.1
EXCHANGE PARTITION statement, 8.3.6
EXECUTE privilege, 17.6.1.1
EXECUTE_CATALOG_ROLE privilege, 17.6.1.1
execution plans
star transformations, 20.4.2.2
EXPAND_GSET_TO_UNION hint, 19.3.8.2, 19.7.10.4
EXPLAIN PLAN statement, 19.6.1
star transformations, 20.4.2.2
EXPLAIN_REWRITE procedure, 19.6.2
exporting
a change table, 17.9.5
asynchronous change sets, 17.9.5.1
asynchronous change tables, 17.9.5.1
EXP utility, 13.3.1.3
expression matching
with query rewrite, 19.3.10
external tables, 15.2.2
extraction, transformation, and loading (ETL), 12.1
overview, 12.1
process, 8.1
extractions
data files, 13.3.1
distributed operations, 13.3.2
full, 13.2.1
incremental, 13.2.1.2
OCI, 13.3.1.2
online, 13.2.2.1
overview, 13.1
physical, 13.2.2
Pro*C, 13.3.1.2
SQL*Plus, 13.3.1.1

F

fact tables, 2.4, 2.4.1
star joins, 20.3
star queries, 20.3
facts, 11.1
FAST clause, 9.3.7
fast refresh, 16.3.2
restrictions, 9.3.7.1
with UNION ALL, 16.3.18
features, new, Preface
files
ultralarge, 3.2.2
filling gaps
with data, 22.5.6
FIRST_VALUE function, 22.2.5.1
FIRST/LAST functions, 22.3.2
FOR loops, 23.3.1
FORCE clause, 9.3.7
foreign key
constraints, 8.3.2
joins
snowflake schemas, 20.3.1
frequent itemsets, 22.7.4
functions
analytic, 23.3.5
COUNT, 7.1.3
CUME_DIST, 22.2.1.3
DENSE_RANK, 22.2.1.1
FIRST_VALUE, 22.2.5.1
FIRST/LAST, 22.3.2
GROUP_ID, 21.4.4
GROUPING, 21.4
GROUPING_ID, 21.4.3
LAG/LEAD, 22.2.4
LAST_VALUE, 22.2.5.1
linear regression, 22.3.5
LISTAGG, 22.3.1
NTH_VALUE, 22.2.5.2
NTILE, 22.2.1.5
PERCENT_RANK, 22.2.1.4
RANK, 22.2.1.1
ranking, 22.2.1
RATIO_TO_REPORT, 22.2.3.1
REGR_AVGX, 22.3.5.2
REGR_AVGY, 22.3.5.2
REGR_COUNT, 22.3.5.1
REGR_INTERCEPT, 22.3.5.3
REGR_SLOPE, 22.3.5.3
REGR_SXX, 22.3.5.5
REGR_SXY, 22.3.5.5
REGR_SYY, 22.3.5.5
reporting, 22.2.3
ROW_NUMBER, 22.2.1.6
WIDTH_BUCKET, 22.7.1, 22.7.1.1
window, 23.3.5
windowing, 22.2.2

G

GRANT statement, 17.9.4.5
GROUP_ID function, 21.4.4
grouping
compatibility check, 19.1.3.3
conditions, 19.7.6
GROUPING function, 21.4
when to use, 21.4.2
GROUPING_ID function, 21.4.3
GROUPING_SETS expression, 21.5
GT GlossaryTitle, Glossary

H

hierarchical cubes, 10.2.1, 21.10.1
in SQL, 21.10
hierarchies, 11.1
how used, 2.4.2.1
multiple, 11.2.2
overview, 2.4.2.1, 2.4.2.1
rolling up and drilling down, 11.1
high boundary
defined, 17.1.3.2
hints
EXPAND_GSET_TO_UNION, 19.3.8.2, 19.7.10.4
NOWRITE, 19.7.10.1
query rewrite, 18.2, 19.7.10.1
REWRITE, 19.7.10.1
REWRITE_OR_ERROR, 19.7.10.2
histograms
creating with user-defined buckets, 22.7.3.1
HOTLOG_SOURCE change sources, 17.2.2.1
hypothetical rank, 22.3.4

I

importing
a change table, 17.9.5, 17.9.5.3
asynchronous change sets, 17.9.5.1
asynchronous change tables, 17.9.5.1
data into a source table, 17.9.5.3
indexes
bitmap indexes, 7.1.4
bitmap join, 7.1.5
B-tree, 7.2
cardinality, 7.1.2
nulls and, 7.1.3
partitioned tables, 7.1.4
initcdc.sql script, 17.12
initialization parameters
JOB_QUEUE_PROCESSES, 16.3.9
OPTIMIZER_MODE, 16.3.11, 18.2.1
PARALLEL_MAX_SERVERS, 16.3.11
PGA_AGGREGATE_TARGET, 16.3.11
QUERY_REWRITE_ENABLED, 18.2, 18.2.1
QUERY_REWRITE_INTEGRITY, 18.2.1
STAR_TRANSFORMATION_ENABLED, 20.4.1
integrity constraints, 8.1
invalidating
materialized views, 10.4
itemsets
frequent, 22.7.4

J

Java
used by Change Data Capture, 17.12
JOB_QUEUE_PROCESSES initialization parameter, 16.3.9
join compatibility, 19.1.3.1
joins
star joins, 20.3
star queries, 20.3

K

key lookups, 15.5.1
keys, 9.1.6, 20.3

L

LAG/LEAD functions, 22.2.4
LAST_VALUE function, 22.2.5.1
level relationships, 2.4.2.1
purpose, 2.4.2.1.2
levels, 2.4.2, 2.4.2.1.1
levels in a dimension
skipping, 11.2
linear regression functions, 22.3.5
LISTAGG function, 22.3.1
local indexes, 7.1.1, 7.1.4
logging
error, 15.4
logical design, 3.1
logs
materialized views, 9.3.9
lookup tables
See dimension tables, 9.1.6, 9.1.6
low boundary
defined, 17.1.3.2

M

manual
refresh, 16.3.5
manual refresh
with DBMS_MVIEW package, 16.3.5
materialized view logs, 9.3.9
materialized views
aggregates, 9.2.1
altering, 10.6
analytic processing, 10.2
build methods, 9.3.4
checking status, 16.3.13
containing only joins, 9.2.2
creating, 9.3
cubes, 10.2.1
data segment compression, 9.3.3
delta joins, 19.1.3.1.3
dropping, 9.4, 9.6
invalidating, 10.4
logs, 13.2.3.3
multiple, 19.2.8
naming, 9.3.2
nested, 9.2.3
Partition Change Tracking (PCT), 10.1.1
partitioned tables, 16.4
partitioning, 10.1
prebuilt, 9.3
query rewrite
hints, 18.2, 19.7.10.1
matching join graphs, 9.3.6
parameters, 18.2.1
privileges, 18.2.4
refresh dependent, 16.3.8
refreshing, 9.3.7, 16.3
refreshing all, 16.3.7
registration, 9.4
restrictions, 9.3.6.1
rewrites
enabling, 18.2
schema design, 9.1.7
schema design guidelines, 9.1.7
security, 10.5, 10.5
set operators, 10.2.4
storage characteristics, 9.3.3
types of, 9.2
uses for, 9.1
with VPD, 10.5.1
measures, 9.1.6, 20.3
MERGE statement, 16.2.1
Change Data Capture restriction, 17.10.1
MODEL clause, 23.1
cell referencing, 23.2.4
data flow, 23.1.1
keywords, 23.2.3
parallel execution, 23.4.1
rules, 23.2.5
monitoring
refresh, 16.3.12
mortgage calculation, 23.5
multiple hierarchies, 11.2.2
multiple materialized views, 19.2.8
MV_CAPABILITIES_TABLE table, 9.7.1.2

N

nested materialized views, 9.2.3
refreshing, 16.3.17
restrictions, 9.2.3.4
net present value
calculating, 23.5
NEVER clause, 9.3.7
new features, Preface
nonvolatile data, 1.1.3
NOREWRITE hint, 18.2, 19.7.10.1
NTH_VALUE function, 22.2.5.2
NTILE function, 22.2.1.5
nulls
indexes and, 7.1.3

O

ON COMMIT clause, 9.3.7
ON DEMAND clause, 9.3.7
OPERATION$
control column, 17.9.4.2
optimizations
query rewrite
enabling, 18.2
hints, 18.2, 19.7.10.1
matching join graphs, 9.3.6
query rewrites
privileges, 18.2.4
optimizer
with rewrite, 18.1
OPTIMIZER_MODE initialization parameter, 16.3.11, 18.2.1
ORA-31424 error, 17.9.4.7
ORA-31496 error, 17.9.4.7
Oracle Data Pump
using with Change Data Capture, 17.9.5
ORDER BY clause, 9.3.8
outer joins
with query rewrite, 19.7.3

P

packages
DBMS_ADVISOR, 9.1.4
DBMS_CDC_PUBLISH, 17.1.2
DBMS_CDC_SUBSCRIBE, 17.1.2
DBMS_DIMENSION, 11.3.2
DBMS_ERROR, 15.4.2.2
DBMS_ERRORLOG, 15.4.2.2, 15.5.3
DBMS_JOB, 17.9.4.6
DBMS_MVIEW, 9.7.1.1, 16.3
DBMS_STATS, 19.1.1
paragraph tags
GT GlossaryTitle, Glossary
parallel DML
bitmap indexes, 7.1.1
parallel execution, 6.1
parallel query
bitmap indexes, 7.1.1
PARALLEL_MAX_SERVERS initialization parameter, 16.3.11
parallelism, 6.1
Partition Change Tracking (PCT), 10.1.1, 16.4.1, 19.2.7
refresh, 16.3.3
with Pmarkers, 19.2.7.4
partitioned outer join, 22.5
partitioned tables
materialized views, 16.4
partitioning, 13.2.3.2
data, 5.1
in data warehouses, 5
materialized views, 10.1
prebuilt tables, 10.1.3
partitions
bitmap indexes, 7.1.4
PERCENT_RANK function, 22.2.1.4
PGA_AGGREGATE_TARGET initialization parameter, 16.3.11
physical design, 3.1
structures, 3.2.1
pivoting, 15.5.4, 15.5.4, 22.4
operations, 22.4
plans
star transformations, 20.4.2.2
PL/SQL procedures
DBMS_CDC_PUBLISH_DROP_CHANGE_TABLE, 17.9.4.7
DBMS_CDC_PUBLISH.PURGE, 17.9.4.6, 17.9.4.6
DBMS_CDC_PUBLISH.PURGE_CHANGE_SET, 17.9.4.6
DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE, 17.9.4.6
DBMS_CDC_SUBSCRIBE.PURGE_WINDOW, 17.9.4.6
Pmarkers
with PCT, 19.2.7.4
prebuilt materialized views, 9.3
privileges required
to publish change data, 17.6.1.1
publication
defined, 17.1.3.1
publishers
components associated with, 17.1.3.1
defined, 17.1.3
determining the source tables, 17.1.3.1
privileges for reading views, 17.5
purpose, 17.1.3.1
table partitioning properties and, 17.9.4.1
tasks, 17.1.3.1
publishing
asynchronous AutoLog mode
step-by-step example, 17.7.4
asynchronous HotLog mode
step-by-step example, 17.7.2
synchronous mode
step-by-step example, 17.7.1
publishing change data
preparations for, 17.6
privileges required, 17.6.1.1
purging change tables
automatically, 17.9.4.6
by name, 17.9.4.6
in a named changed set, 17.9.4.6
on the staging database, 17.9.4.6
publishers, 17.9.4.6
subscribers, 17.9.4.6
purging data, 16.2.3

Q

queries
star queries, 20.3
query delta joins, 19.1.3.1.2
query rewrite
advanced, 19.4
checks made by, 19.1.3
controlling, 18.2.2
correctness, 18.2.3
date folding, 19.3.5
enabling, 18.2, 18.2
hints, 18.2, 19.7.10.1
matching join graphs, 9.3.6
methods, 19.1
parameters, 18.2.1
privileges, 18.2.4
restrictions, 9.3.6.2
using equivalences, 19.4
using GROUP BY extensions, 19.3.8.1
using nested materialized views, 19.3.1
using PCT, 19.2.7
VPD, 10.5.1.1
when it occurs, 18.1.1
with bind variables, 19.3.11
with DBMS_MVIEW package, 19.6.2
with expression matching, 19.3.10
with inline views, 19.3.2
with partially stale materialized views, 19.3.10.1
with selfjoins, 19.3.4
with set operator materialized views, 19.3.7
with view constraints, 19.3.6
query tools
described, 1.3.1.9
QUERY_REWRITE_ENABLED initialization parameter, 18.2, 18.2.1
QUERY_REWRITE_INTEGRITY initialization parameter, 18.2.1

R

RANK function, 22.2.1.1
ranking functions, 22.2.1
RATIO_TO_REPORT function, 22.2.3.1
recovery
from asynchronous change set capture errors, 17.9.2.4
redo log files
archived
asynchronous Change Data Capture and, 17.11.1
determining which are no longer needed by Change Data Capture, 17.11.1
reference tables
See dimension tables, 9.1.6
refresh
monitoring, 16.3.12
options, 9.3.7
Partition Change Tracking (PCT), 16.3.3
scheduling, 16.3.14
with UNION ALL, 16.3.18
refreshing
materialized views, 16.3
nested materialized views, 16.3.17
partitioning, 16.1
REGR_AVGX function, 22.3.5.2
REGR_AVGY function, 22.3.5.2
REGR_COUNT function, 22.3.5.1
REGR_INTERCEPT function, 22.3.5.3
REGR_R2 function, 22.3.5.4
REGR_SLOPE function, 22.3.5.3
REGR_SXX function, 22.3.5.5
REGR_SXY function, 22.3.5.5
REGR_SYY function, 22.3.5.5
RELY constraints, 8.3.3
removing
Change Data Capture from source database, 17.12
reporting functions, 22.2.3
restrictions
fast refresh, 9.3.7.1
nested materialized views, 9.2.3.4
query rewrite, 9.3.6.2
result set, 20.4.2
REVOKE statement, 17.9.4.5
REWRITE hint, 18.2, 19.7.10.1, 19.7.10.1
REWRITE_OR_ERROR hint, 19.7.10.2
rewrites
hints, 19.7.10.1
parameters, 18.2.1
privileges, 18.2.4
query optimizations
hints, 18.2, 19.7.10.1
matching join graphs, 9.3.6
rmcdc.sql script, 17.12
rolling up hierarchies, 11.1
ROLLUP, 21.2
concatenated, 21.10.1
partial, 21.2.3
when to use, 21.2.1
root level, 2.4.2.1.1
ROW_ID$
control column, 17.9.4.2
ROW_NUMBER function, 22.2.1.6
RSID$
control column, 17.9.4.2
rules
in MODEL clause, 23.2.5
in SQL modeling, 23.2.5
order of evaluation, 23.2.6

S

schema-level export operations, 17.9.5.1
schema-level import operations, 17.9.5.1
schemas, 20.1
design guidelines for materialized views, 9.1.7
snowflake, 2.3
star, 2.3
third normal form, 20.1, 20.2
scripts
initcdc.sql for Change Data Capture, 17.12
rmcdc.sql for Change Data Capture, 17.12
SELECT_CATALOG_ROLE privilege, 17.5, 17.6.1.1
set operators
materialized views, 10.2.4
simultaneous equations, 23.5
SKIP WHEN NULL clause, 11.2
skipping levels in a dimension, 11.2
snowflake schemas, 20.3.1
complex queries, 20.3.1
source database
defined, 17.1.3.1
source systems, 13.1
source tables
importing for Change Data Capture, 17.9.5.3
referenced by change tables, 17.9.4.1
SOURCE_COLMAP$
control column, 17.9.4.2
interpreting, 17.9.4.3
sparse data
data densification, 22.5.2
SQL modeling, 23.1
cell referencing, 23.2.4
keywords, 23.2.3
order of evaluation, 23.2.6
performance, 23.4
rules, 23.2.5
rules and restrictions, 23.3.7
staging
areas, 1.2.2
databases, 9.1
files, 9.1
staging database
defined, 17.1.3.1
STALE_TOLERATED mode, 18.2.3
star joins, 20.3
star queries, 20.3
star transformation, 20.4.2
star schemas
advantages, 2.3.1
defining fact tables, 2.4.1.1
dimensional model, 2.3.1, 20.3
star transformations, 20.4.2
restrictions, 20.4.2.6
STAR_TRANSFORMATION_ENABLED initialization parameter, 20.4.1
statistics, 19.7.9
Streams apply process
asynchronous Change Data Capture and, 17.6.4
Streams capture process
asynchronous Change Data Capture and, 17.6.4
striping, 4.1.2
subscriber view
defined, 17.1.3.2
returning DML changes in order, 17.9.4.2, 17.9.4.2
subscribers
access to change tables, 17.9.4.5
ALL_PUBLISHED_COLUMNS view, 17.9.6
components associated with, 17.1.3.2
controlling access to tables, 17.9.4.5
defined, 17.1.3
DML access, 17.9.4.5
privileges, 17.1.3.2
purpose, 17.1.3.2
retrieve change data from the subscriber views, 17.1.3.2
tasks, 17.1.3.2
subscribing
step-by-step example, 17.8
subscription windows
defined, 17.1.3.2
subscriptions
changes to change tables and, 17.9.6
defined, 17.1.3.2
effect of SQL DROP USER CASCADE statement on, 17.9.4.7
summary management
components, 9.1.5
summary tables, 2.4.1
supplemental logging
asynchronous Change Data Capture, 17.11.2
asynchronous Change Data Capture and, 17.2.2
SYNC_SET predefined change set, 17.3
SYNC_SOURCE change source, 17.2.1
synchronous Change Data Capture
change sets and, 17.3
synchronous change sets
disabling, 17.9.2.2
enabling, 17.9.2.2
synchronous publishing
latency for, 17.6.2
location of staging database, 17.6.2
requirements for, 17.7.1
setting database initialization parameters for, 17.6.3.1
source database performance impact, 17.6.2
SYS_NC_OID$
control column, 17.9.4.2

T

table differencing, 17.1.1
table partitioning
publisher and, 17.9.4.1
tables
detail tables, 9.1.6
dimension tables (lookup tables), 9.1.6
dimensions
star queries, 20.3
external, 15.2.2
fact tables, 9.1.6
star queries, 20.3
lookup, 20.3
tablespace
specifying default for Change Data Capture publisher, 17.6.1.2
tablespaces
change tables and, 17.9.4.1
transportable, 13.2.2.2, 14.2.3, 14.2.3.2
TARGET_COLMAP$
control column, 17.9.4.2
interpreting, 17.9.4.3
text match, 19.2.1
with query rewrite, 19.7.4
third normal form
queries, 20.2.1
schemas, 20.2
time series calculations, 22.6
TIMESTAMP$
control column, 17.9.4.2
timestamps, 13.2.3.1
transformations, 15.1
scenarios, 15.5
SQL and PL/SQL, 15.3.1
SQL*Loader, 15.2.1
transportable tablespaces, 13.2.2.2, 14.2.3, 14.2.3.2
transportation
definition, 14.1
distributed operations, 14.2.2
flat files, 14.2.1
triggers, 13.2.3.3
installed by Change Data Capture, 17.12
TRUSTED mode, 18.2.3

U

ultralarge files, 3.2.2
unique
constraints, 8.3.1
identifier, 2.2, 3.2
update frequencies, 9.1.9
UPDATE statement, 23.2.8
update windows, 9.1.9
UPSERT ALL statement, 23.2.8
UPSERT statement, 23.2.8
USERNAME$
control column, 17.9.4.2

V

validating dimensions, 11.5
view constraints, 8.3.7, 19.3.6
VPD
and materialized views, 10.5.1
restrictions with materialized views, 10.5.1.2

W

WIDTH_BUCKET function, 22.7.1, 22.7.1.1
window functions, 23.3.5
windowing functions, 22.2.2

X

XIDSEQ$
control column, 17.9.4.2
XIDSLT$
control column, 17.9.4.2
XIDUSN$
control column, 17.9.4.2