Pro Oracle Database 11g Administration (108 page)

DBMS_MVIEW, vs. DBMS_REFRESH, 409–410

DBA_REGISTERED_MVIEWS view, 407

DBMS_REDEFINITION package, 261, 290

DBA_RGROUP view, 365, 410

DBMS_REFRESH, vs. DBMS_MVIEW, 409–410

DBA_ROLE_PRIVS view, 130, 232, 234

DBMS_SCHEDULER package, 570, 573–574

DBA_ROLES view, 232, 234

DBMS_SPACE package, 155

DBA_SCHEDULER_JOBS view, 571, 574

DBMS_SPACE statement, testing for space

DBA_SEGMENTS view, 214

below high-water mark with, 156–159

DBA_SEQUENCES view, 208

DBMS_SPACE.SPACE_USAGE package,

266–267

dba_setup file, 69

DBMS_STATS package, 226, 298

648

■ INDEX

DBMS_UNDO_ADV package, 621

DEGREE parameter, 226

--dbname option, 564

del command, 47

DB_NAME parameter, 221

--del option, 584

dbname parameter, 564

DELETE command, 473, 482

dbname variable, 434–435

DELETE NOPROMPT OBSOLETE command,

DB_NAME variable, 543

472, 482

dbora script, 583–585

DELETE OBSOLETE command, 472

dbora service, 584

delete statement, 72, 140, 153–154, 169, 299, 399

DBPITR (database point-in-time recovery), 449,

DELETE statement, removing data from tables

529

with, 153

DB_RECOVERY_FILE_DEST parameter,

deleting Oracle Scheduler jobs, 574

424–425, 459, 525

DELIMITED BY parameter, 353

DB_RECOVERY_FILE_DEST_SIZE parameter,

dep_dyn_.sql script, 237

424, 459

dep_dyn_.txt file, 238

DB_SECUREFILE setting, 247

DEPT table, 162, 164, 196–197

dbshut script, 585

DEPT_ID column, 162, 164–165, 196

dbstart script, 585

DEPTREE_FILL procedure, 238

dbstart utility, 27

DESCRIBE command, 111

dbstop utility, 27

DESCRIBE statement, 391

DB_UNIQUE_NAME parameter, 221

DESTROY parameter, 343

DB_WRITER_PROCESSES parameter, 105

DESTROY procedure, DBMS_REFRESH

D_COMPANIES table, 237

package, 411

D_CUSTOMERS table, 181

DETAIL clause, 513

D_DATE_DTT column, 275

DETERMINISTIC keyword, 177

D_DATE_ID column, 274–275, 289, 293, 300,

/dev/null device, 581, 588

302

/dev/null file, 600

DDL (Data Definition Language)

dev_1 directory, 14, 17

base-table, 385–388

df command, 13

creating file, 336

df utility, 597, 603

displaying for tables, 150–151

diagnostic repository, and OFA, 4

DDL_LOCK_TIMEOUT parameter, 147, 189

DIAGNOSTIC_DEST parameter, 537, 598

decision support system (DSS), 278

DICT_COLUMNS view, 217

DEDUPLICATE clause, 252

DICTIONARY view, 217

deduplicating SecureFile LOBs, 257–258

differences mode, watch utility, 605

DEDUPLICATION column, DBA/ALL_LOBS

DIRECT parameter, 342

view, 263

directories, granting access to, 311

DEFAULT DIRECTORY clause, 348

directory objects, creating and granting access,

DEFAULT list, 279

348

DEFAULT partition, 292

DIRECTORY option, 317

DEFAULT profile, 119, 124–126, 128, 589

DIRECTORY parameter, 311

default users, 112–114

DISABLE procedure, 573

DEFAULT_PWD$ view, 113

DISABLE ROW MOVEMENT clause, 290

deferred segment creation, of tables, 141–142

DISABLE STORAGE IN ROW clause, 255

DEFERRED_SEGMENT_CREATION parameter,

DISABLE_POLICY procedure, 634

142

disabling

649

■ INDEX

auditing, 630–631

drop_dyn.sql script, 395

constraints, 167–168

DROP_JOB procedure, 574

Oracle Scheduler jobs, 573

dropping

DISCARDFILE parameter, 353

columns, 149–150

dis_dyn.sql file, 168

databases, 46–47

disk fullness, troubleshooting, 597–600

indexes, 191

locating alert log and trace files, 597–599

MVs, 384–385

removing files, 599–600

partitions, 297–298

DISPLAY not set error, 12

sequences, 209

DISPLAY variable, 12, 19, 22, 25

synonyms, 204

DISPLAY variable, remotely installing Oracle,

tables, 151

21–22

tablespaces, 78–80

displaying size of tablespaces, 81–82

users, 122–123

DML (Data Manipulation Language), 123, 133,

views, 200

174, 194, 214, 387, 451

DROP_POLICY procedure, 634

DML usage, troubleshooting auditing, 627–628

D_SOURCE_ID column, 175

documentation, for data dictionary, 216–218

D_SOURCES table, 175

Domain index type, 173

DSS (decision support system), 278

DOMAIN_NAMES table, 238

DTE (data transfer element), 567

DOSKEY utility, 58

du utility, 603

DOWNGRADE parameter, 43

dump files

DP_DIR directory, 313

compressing, 356

DPUMP_DIR2 directory, 317

encrypting, 356–357

DROP ANY TABLE privilege, 151

listing contents of, 317

DROP CATALOG command, 485

specifying, 335

DROP DATABASE command, 47

dump/trace files, creating required directories

DROP DATABASE statement, 46

for, 537

DROP INDEX statement, 191

DUMPFILE parameter, 342–343

DROP MATERIALIZED VIEW command, 384

DUPLICATE DATABASE command, 534

DROP MATERIALIZED VIEW LOG ON

dynamic performance views, for data

statement, 395

dictionary, 215–216

DROP MATERIALIZED VIEW statement, 378,

407, 411

■ E

DROP operation, 149

\e variable, bash shell, 53

DROP SEQUENCE statement, 209

echo command, 22, 488, 577

DROP SUBPARTITION clause, 297

ECHO parameter, 481

DROP SYNONYM statement, 204

ECHO, setting, 488–489

DROP TABLE statement, 151–153, 160, 385

edds command, 561

DROP TABLESPACE ... INCLUDING

CONTENTS AND DATAFILES

EDIT command, 55

statement, 80

editions, of OSB, 545–546

DROP TABLESPACE statement, 79

EDITOR variable, 55, 579, 601

DROP UNUSED clause, 150

emacs utility, 59

DROP USER statement, 123, 485

EMP table, 164–165, 196, 628, 633

DROP VIEW statement, 200

EMP_DEPT_V view, 197

650

■ INDEX

EMP_ID column, 196

top.sql script, 66–67

EMP_NAME column, 177

users.sql script, 67–68

ENABLE procedure, DBMS_SCHEDULER

setting command editor, 59–60

package, 573

shortcuts for frequently used commands

ENABLE QUERY REWRITE clause, 380

using aliases, 55–56

ENABLE ROW MOVEMENT clause, 290

using function, 56–57

ENABLE STORAGE IN ROW clause, 255

environment variables, 25–29

ENABLED column, 573

setting manually, 26

enabling

setting through Oracle, 26–27

auditing, 626–627

setting with oraset script, 27–29

constraints, 168

ESTIMATE_ONLY parameter, 317

Oracle Scheduler jobs, 573

ESTIMATE_PERCENT parameter, 226

ENCRYPT clause, 258

/etc/cron.allow file, 576–577

ENCRYPT column, DBA/ALL_LOBS view, 263

/etc/cron.d directory, 576–577

ENCRYPT keyword, 259

/etc/cron.daily directory, 576

ENCRYPTED_COLUMNS_ONLY option, 337

/etc/cron.deny file, 576–577

encrypting

/etc/cron.hourly directory, 576

columns, 376

/etc/cron.monthly directory, 576

data, 337

/etc/crontab file, 575–576

dump files, 356–357

/etc/cron.weekly directory, 576

SecureFile LOBs, 258–260

/etc directory, 12, 14, 26, 28

encryption, configuring, 477

/etc/group file, 5

ENCRYPTION option, ACCESS PARAMETERS

/etc/init.d/crond script, 575–576

clause, 356

/etc/init.d directory, 583

ENCRYPTION parameter, 337, 359

/etc/init.d/observiced start command, 568

ENGDEV database, 403

/etc/init.d/observiced stop command, 568

environment configuration, 51–70

/etc/init.d/OracleBackup start command, 568

customizing command prompt, 52–53

/etc/init.d/OracleBackup stop command, 568

customizing SQL prompt, 54

/etc/inittab file, 585–586

rerunning commands, 57–59

/etc/oratab file, 46, 583

listing command history, 58–59

/etc/passwd file, 6

pressing Ctrl+P and Ctrl+N, 58

/etc/rc.d directory, 584

scrolling with arrow keys, 58

/etc/rc.d/init.d/OracleBackup start command,

searching in reverse, 59

568

scripts for common tasks

/etc/rc.d/init.d/OracleBackup stop command,

configuring startup file, 69

568

conn.bsh script, 64–65

/etc/rc.d/init.d/sshd script, 586

creating directories for, 68–69

/etc/rc.d/rc5.d/S55sshd script, 586

dba_fcns script, 61–62

/etc/rc.d/rc.d directory, 586

dba_setup script, 60–61

exa.csv.gz file, 358

filesp.bsh script, 65–66

EXADATA_ET table, 349, 351

lock.sql script, 67

EXA_INFO table, 350

login.sql script, 66

EXCEPTIONS INTO clause, 169

tbsp_chk.bsh script, 62–64

EXCEPTIONS table, 169

651

■ INDEX

EXCLUDE clause, 326

taking exports, 311

EXCLUDE command, 493

table, index, constraint, and trigger DDL,

EXCLUDE parameter, 324, 326–328

327–328

EXCLUDE=CONSTRAINT parameter, 343

tablespaces and datafiles, 321–323

EXCLUDE=CONSTRAINTS parameter, 342

changing segment and storage

EXCLUDE=GRANT parameter, 342

attributes, 322–323

EXCLUDE=INDEXES parameter, 343

changing size of datafiles, 323

EXCLUDE=OBJECT_GRANT parameter, 343

exporting tablespace metadata, 322

EXCLUDE=TRIGGER parameter, 342

specifying different datafile paths and

names, 322

ex.csv file, 348, 351

export.log file, 311, 338

EXECUTE statement, 298

EXTENT MANAGEMENT LOCAL clause, 73

EXEC[UTE] statement, 396

EXTERNAL job type, 571

EXECUTING state, 340

external table type, 134

EXECUTING status, 338

external tables, 345–359

EXIT command, 313, 316, 552

loading CSV files into databases, 347–350

EXIT_CLIENT command, 313, 316

creating, 348–349

EXLUDE parameter, 325

creating directory objects and granting

EXP method, 290–291

access, 348

exp process, 312

loading regular tables from, 349–350

exp utility, mapping to, 341–342

viewing external-table metadata, 349

exp01.dmp file, 334

performing advanced transformations,

exp02.dmp file, 334

350–352

expd method, 291

preprocessing, 357

expdat.dmp file, 311, 318

vs. SQL*Loader, 345–346

exp.dmp file, 309, 311

unloading and loading data using, 354–357

expdp job, 311

compressing dump files, 356

EXPDP method, 290

encrypting dump files, 356–357

expdp utility, 308, 313

using parallelism to reduce elapsed

expfull.sql file, 317

time, 356

EXPLAIN_MVIEW procedure, DBMS_MVIEW

viewing text files from SQL, 352–353

package, 381–383, 385

EXPLAIN_REWRITE procedure, DBMS_MVIEW

■ F

package, 380

F command, 606

exp.log file, 309

F constraint code, 230

export command, 26, 69

-f option, 561, 563, 565

export files

-f switch, 600

excluding objects from, 325–326

FAILED_LOGIN_ATTEMPTS setting, 125

including only specific objects in, 327

export jobs, estimating size of, 317

exporting

data, 310–311

creating database directories, 310–311

granting access to directories, 311

percentage of, 325

652

■ INDEX

failures

FLASHBACK TABLE TO BEFORE DROP, 452

listing, 512–513

to restore points, 453–454

repairing, 514–515

to SCN, 453

fast-recovery area.
See
FRA

to timestamps, 453

fast recovery area, RMAN backups of, 493

--folow option, 565

fast-refreshable MV, 369–374

FOR DROP clause, 84

F_DOWN_DOM_FK9 index, 190

FORCE command, 519

FEEDBACK parameter, 342–343

FORCE LOGGING mode, 144

FGA (fine-grained auditing), 633

FORCE option, 525, 573

FGA_LOG$ table, 634

FORCE parameter, 43

FILE# column, V$DATAFILE view, 521

foreign-key constraints, creating, 164–165

FILE parameter, 342–343

FORMAT column, DBA/ALL_LOBS view, 263

files, determining which need to be backed up,

FORMAT command, 466, 471

431

FRA (fast-recovery area), 425–426

FILESIZE command, 313

using for archive log files, 424

FILESIZE parameter, 343

using FRA for archive log files, 425

filesp.bsh script, 65–66

free column, 605

filtering data and objects, 324–328

free utility, 603

excluding objects from export files, 325–326