Oracle Database 10g New Features (Osborne ORACLE Press Series)

Page 236

I

idle timeout, setting, 25

index-organized tables, 156

indices keyword, 163

IOTs. See index-organized tables

J

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

L

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

M

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

N

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

O

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