Oracle9i DBA JumpStart

B

b-tree indexes, 244–246, 244

Backup Wizard, 285, 285

backups, 267–287

database failures, 268

DBA backup and recovery methods, 276–285

cold backups, 281

export and import, 276–281, 277

hot backups, 281–282

Log Miner, 282–284, 283–284

Recovery Manager (RMAN), 284–285, 285

user backup and recovery methods, 268–275

Export utility (EXP), 269–271

flashback query, 273–275

Import utility (IMP), 271–273

BETWEEN operator, and WHERE clause, 76–78

bitmap indexes, 246–247, 246

branch blocks, defined, 244, 244

BREAK command, 189–191

BTITLE command, 187–188

buffer cache

basics of, 163–164, 163

buffer cache advisories, 262–263

built-in single-row functions, 52–65

conversion functions, 60–62

date functions, 58–60

general functions, 62–65

numeric functions, 55–58

string functions, 52–55