Index_U

U

underlying platform, and Oracle’s Tuning Methodology, 243

UNION ALL set operator, 126–130

UNION keyword, 126

UNION set operator, 126–130

UNIQUE constraints, 146–147

unique indexes, 209, 245

UNKNOWN values, 82

UPDATE statement, 30–31, 30–31

uppercase in syntax, 24

user accounts, creating, 224–227

assigning passwords and, 224–225

default tablespaces and quotas and, 226–227, 227

profiles and, 225–226

USER_ data dictionary views, 212

user-defined functions, 65–67

user-defined views, 210–212

user trace files, 297–301

converting, 300–301, 301

enabling tracing, 298

locating, 298–300, 300

username, defined, 224

users

backup and recovery methods for, 268–275

Export utility (EXP), 269–271

flashback query, 273–275

Import utility (IMP), 271–273

object privileges, 229–231

user errors, 268

user privileges, 228