Page 236
idle timeout, setting, 25
index-organized tables, 156
indices keyword, 163
IOTs. See index-organized tables
job classes, 27, 32–33, 221
Job Scheduler, 32–33, 221, 222, 223
See also Scheduler
joins
grouped table outer joins, 208–209
query rewrite and self-joins, 147–150
LDAP, new features, 72
LOBs
increased limits, 37
moving data from BFILEs to, 206
and the before row insert trigger, 206
log_archive_format parameter, 75
logical standby databases, 109
bypassing SQL Apply, 112
data dictionary views, 112
instantiating with zero downtime, 109–110
optimized switchover operations on, 111
skipping a failed transaction, 112
SQL Apply support for data types, 110–111
support for maximum protection mode, 110
See also standby databases
Management Repository, 213
materialized views
alter materialized view log command, 156
column aliasing, 154–155
commenting, 155
dbms_dimension package, 156
dependent Mview refresh and rewrite, 150–152
Enhanced Materialized View partition maintenance, 155
fast refresh, 153–154
grouping statements, 153
partition change tracking, 146–147
See also query rewrite
merge statements
conditional updates and inserts, 142
new on condition, 143
option to omit either the update or insert clause, 141–142
optional delete clause, 143
metasymbols, 165
MMAN, 62, 232
MMML, 50
MMNL, 232
MMON, 50, 232
model clause, 207
MTTR Advisor, 59
Mviews. See materialized views
nested tables
ANSI support for, 178–181
defining the tablespace of, 177–178
equality and inequality predicates, 179–180
in and not in operators, 180–181
OEM Console, 213
OID. See Oracle Internet Directory
OMS. See Oracle Management Service
Oracle collections
changing the VARRAY element size, 177
creating temporary tables with VARRAY columns, 176–177
defining the tablespace of a nested table, 177–178
operators, 181, 182
Oracle Database 10g, upgrading to, 3–6
Oracle Database File Topology, 223
Oracle Data Pump, 230
API, 120
architecture, 114–117
data dictionary views, 118
Data Pump Export utility, 120–127