Index_I


I

I/O, and Oracle’s Tuning Methodology, 242

IBM DB2/UDB, 329

identifiers for accounts, 224

IMP. See Import utility (IMP)

implicit conversion, defined, 55

Import utility (IMP)

DBAs and, 276–281, 277

users and, 271–273

IMS, 3

IN operator

Import utility (IMP) and, 79–80

WHERE clause and, 76, 120

incremental backups, RMAN, 284

index-organized tables (IOTs), 246

indexes, 243–251

creating, dropping and maintaining, 208–210, 247–248

data dictionary index information, 250–251

defined, 208

monitoring, 248–250

types of, 244–247, 244, 246

when to create, 243

inheritance, 10

INITCAP function, 53, 54

inner joins, and INTERSECT operator, 132

INSERT statement, 32–33

instances

creating, 171–172, 171–172

defined, 158

failures of, 268

naming, 172, 172–173

OEM and, 176, 176

interface options for reporting, 180–181, 181

INTERSECT set operator, 130–132

intersection tables, 7

IOTs (index-organized tables), 246

IS NULL and IS NOT NULL, 81–82

iSQL*Plus

basics of, 18–20, 19–20

configuration for reporting, 180–184, 180

Change Password, 184

interface options, 180–181, 181

system variables, 182–184, 182

vs. SQL*Plus, 19–20, 19–20

italics in syntax, 24




Oracle9i DBA JumpStart
Oracle9i DBA JumpStart
ISBN: 0782141897
EAN: 2147483647
Year: 2006
Pages: 138
Authors: Bob Bryla

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net