Pro Oracle Database 11g Administration (109 page)
FREEPOOLS column, DBA/ALL_LOBS view, 262
excluding objects from imports, 328
FREE_SPACE (MB_FREE) column, 624
excluding statistics, 327
F_REGS table, 275, 291
exporting percentage of data, 325
FROM clause, 181, 195
exporting table, index, constraint, and
FROM SEQUENCE clause, 525
trigger DDL, 327–328
FROM_LOCATION variable, 12
including objects in imports, 328
FROMUSER parameter, 343
including only specific objects in export
FS1 parameter, 157
files, 327
FS2 parameter, 157
specifying Query, 324–325
FS3 parameter, 157
find command, 45, 598–599
FS4 parameter, 157
fine-grained auditing, 633–635
F_SALES table, 169, 276, 297–300
fine-grained auditing (FGA), 633
F_SALES_IDX2 index, 302
FIRST_CHANGE# column
F_SHIPMENTS table, 181
V$ARCHIVED_LOG view, 533
full backup, vs. incremental level=0, 490
V$LOG view, 533
FULL mode, 326
V$LOG_HISTORY view, 533
FULL parameter, 322
FIRST_NAME column, 182
function-based indexes, 177–178
FIXED parameter, 353
Function index type, 173
FLASHBACK statement, 453
function, shortcuts for commands using, 56–57
FLASHBACK TABLE statement, 152–153, 451
FUZZY column, V$DATAFILE_HEADER view,
FLASHBACK TABLE TO BEFORE DROP
530
statement, 152, 451–452
-g option, 5
FLASHBACK_SCN parameter, 329–330, 335, 342
FLASHBACK_TIME parameter, 329–330, 342
■
flashing back databases, 454
G
flashing back tables, 451–454
GET_DDL function, 150, 188, 199, 203
653
■ INDEX
GET_DDL procedure, 151
high-water mark, 154–159
GLOBAL keyword, 303
moving table, 158–159
Global partitioned index type, 173
shrinking table, 157
--go option, 561
testing for space below
GO option, 561
overview, 155–156
GRANT ALL statement, 129
using DBMS_SPACE, 156–159
GRANT ANY PRIVILEGE privilege, 128
HIGH_VALUE column, 275, 280, 283
GRANT statement, 128, 224, 235, 311
history command, 58
GRANT SYSDBA statement, 40
\\HKEY_LOCAL_MACHINE\\Software\Oracle
GRANTS parameter, 342–343
key, 12
grep command, 94
HOME/.bashrc file, 56
groupadd command, 5
HOME/.bashrc script, 582
groupdel command, 6
HOME/bin directory, 60–62, 64–65, 68–69
grouping of privileges, for users, 130
HOME/bin/log directory, 68
GROUPING_APP user, 129
HOME directory, 3
groupmod command, 6
/home directory, 14
groups
HOME directory, 52, 56, 68
creating system, before installation, 5–6
home directory, for OFA, 3–4
MVs, 408–411
/home/oracle directory, 3, 14, 559
altering, 409
/home/oracle/oraInventory directory, 3
creating, 408
/home/oracle/scripts directory, 66, 263
DBMS_MVIEW vs. DBMS_REFRESH,
/home/oracle/scripts/rmanbkup.sh file,
409–410
562–563
determining, 410
/home/oracle/temp directory, 559
refresh, 410–411
HOME/scripts directory, 54, 66–69
guidelines, for indexes, 173–175
HOME variable, 6
gunzip utility, 358
HOMEPATH varaible, 602
GV$ view, 213, 215–216
--host option, 564
gzip utility, 358, 428
HOST parameter, 221
hot backups, 430–433
■ H
altering databaseinto backup mode, 432
H command, 606
altering databaseout of backup mode, 432
H constraint code, 230
backing up any archive-redo logs generated
during backup, 433
-h option, 564
backing up control file, 433
\h variable, bash shell, 53
copying datafiles with OS utilities, 432
Hash cluster index type, 173
determining where to copy backup files, 431
hash partition type, 272
determining which files need to be backed
hash, partitioning tables by, 280
up, 431
hbdir varaible, 434–435
ensuring that database is in archivelog
HEADER clause, 517
mode, 431
heap-organized tables, creating, 135–138
maximum sequence number of online-redo
HEERA tablespace, 323
logs, 433
heera user, 40, 115, 118, 331
note maximum sequence number of
HELP command, 313–314
online-redo logs, 431
654
■ INDEX
scripting, 434–436
performing time-based recovery, 532
hotback.sql script, 434
restoring to restore point, 533–534
h.par file, 328
INCREMENT BY setting, 205, 210
-i option, 564, 567
incremental backups, 475, 496–499
incrementally updating backups, 498–499
■ I
overview, 497
id column, 605
using block change tracking, 499
id command, 6, 41, 552
incremental level=0, vs. full backup, 490
IDENTIFIED BY clause, 122
incrementally updated backups, 475
IDLE_TIME setting, 127
IND$ table, 214
IGNORE parameter, 343
index-organized table (IOTs), 161
ignore=y option, 331
indexes, 171–192, 227–229
image copies
creating, 175–185, 374–375
vs. backup sets, RMAN backups, 490–491
avoiding redo generation for, 183
overview, 474–475
B-tree indexes, 175–176
IMMEDIATE clause, 414, 416, 429, 465
bitmap indexes, 179–180
IMMEDIATE option, 315
bitmap join indexes, 180–181
IMMEDIATE parameter, 43–44
concatenated indexes, 176–177
IMP method, 290–291
function-based indexes, 177–178
imp utility, mapping to, 343–344
invisible indexes, 183–185
impdp command, 312
key-compressed indexes, 182
IMPDP method, 291, 293
naming standards for, 185
impdp process, 317
parallelizing index creation, 183
impdp utility, 308, 313
reverse-key indexes, 181
importing
unique indexes, 178–179
data, 311–312
displaying for table, 227–228
tablespaces and datafiles, 321–323
foreign-key columns not indexed, 228–229
changing segment and storage
guidelines for, 173–175
attributes, 322–323
for LOBs, 244–246
changing size of datafiles, 323
maintaining, 187–192
exporting tablespace metadata, 322
displaying code to re-create, 188
specifying different datafile paths and
dropping, 191
names, 322
making unusable, 190
import.log file, 338
monitoring usage of, 190–191
imp.par file, 316
rebuilding, 188–189
in column, 605
renaming, 188
INCLUDE parameter, 324–325, 327–328
partitioning of, 300–304
INCLUDE=INDEXES parameter, 342
differently than tables, 303–304
INCLUDING clause, 161
like tables, 300–302
incomplete recovery, 529–534
specifying tablespaces for, 186–187
determining type of, 531
types of, 172–173
performing change/SCN-based recovery,
when to create, 171–172
533
INDEXES parameter, 342–343
performing log sequenced-based recovery,
INDEXFILE command, 318
532
655
■ INDEX
INDEXFILE parameter, 318, 343
using response files, 8–11
indexing log columns, 392
Oracle Database 10g scenario, 8–10
INDEX_NAME column, DBA/ALL_LOBS view,
Oracle Database 11g scenario, 10–11
262
INSTANCE_NAME parameter, 221
INDEX_TYPE column, 161
instances, shutting down, 416–417
initialization file, configuring, 30–31
INSTEAD OF clause, for views, 197–198
init.ora file
INST_ID column, 216
adding control files when using, 95–96
inst.loc file,
creating, 536–537
\\HKEY_LOCAL_MACHINE\\Software
init
\Oracle key, 12
--inputrequest option, 564
inst.rsp file, 9–10
IN_ROW column
interactive command mode, 313–316
DBA/ALL_LOBS view, 263
attaching to running jobs, 314–315
USER_LOBS view, 255
entering, 313–314
INSERT /*+ APPEND */ INTO
status, 340
SELECT * FROM
stopping and restarting jobs, 315
INSERT AS SELECT statement, 350
terminating jobs, 316
INSERT privilege, 129, 194
interfaces, terminology of OSB, 547
insert statement, 72, 141, 194, 206, 286, 351, 399
INTERVAL calculation, 409
insertvol command, 567
INTERVAL clause, 282
installing, 4–12
interval partition type, 272
applying patches, 17–18
INTERVAL(NUMTOYMINTERVAL(1, 'YEAR'))
checking operating system configuration,
clause, 283
6–7
INV synonym, 201
with copy of existing installation, 12–15
INV table, 155, 157, 201, 325, 354–355, 387, 395,
attaching Oracle home, 14–15
617, 633
copying binaries, 13–14
INV user, 333
creating group and user, 5–6
INV view, 200
downloading, 7
INV1 tablespace, 80
OSB, 549–551
inv2.par file, 325
reinstalling, 16–17
INV_CLOB tablespace, 253
remotely with graphical installer, 18–23
inv.dmp file, 335, 355
copying installation media to remote
INV_DW table, 355
server, 20
INV_DW user, 333
ensuring DISPLAY variable is set, 21–22
INVEN table, 331
executing runInstaller utility, 22
inventory directory, for OFA, 3
installing required software on local PC,
INVENTORY table, 129, 151
19
inventory.xml file, 12, 14–15, 17
logging in to remote computer, 21
INV_ET table, 355
running xhost command, 21
INV_ID column, 206, 325
starting X session, 19–20
INV_IDX1 index, 181
troubleshooting, 22
INV_IDX_MED tablespace, 187
troubleshooting, 11–12
INV_IDX_SMALL tablespace, 187
unzipping files, 7–8
INV_IMAGE column, 253
upgrading, 15–16
INVISIBLE clause, 184
656
■ INDEX
invisible indexes, creating, 183–185
key-compressed indexes, 182
from existing index, 184
kill command, 44, 618
for third-party applications, 184–185
KILL_JOB command, 308, 313–314, 316
INV_LOC column, 386, 388
-L option, 565, 567
INV_MGMT schema, 201
INV_MGMT user, 111, 115, 201
■ L
INV_MGMT_APP user, 129
\l variable, bash shell, 53
INV_MGMT.EMP table, 628
large files, RMAN backups of, 495
INV_MGMT.INV table, 201
large objects.
See
LOBs
INV_MV table, 377, 385
last refresh times, 400–401
INV_OLD view, 200
LAST_DDL_TIME column, 224
inv.par file, 324
LAST_NAME column, CUSTOMERS table, 182,
INVPRDRMAN.log file, 482
332
INV_SEQ sequence, 205
LAST_REFRESH_DATE column, 400–401, 406,
INV_UIDX1 constraint, 178
409
iostat utility, 603
LD_LIBRARY_PATH variable, 30
IOTs (index-organized table), 161
LEFT OUTER JOIN clause, 229
IP_ADDRESS parameter, 221
legacy mode, 341–344
ISDATE function, 149
mapping to exp utility, 341–342
ISDBA parameter, 221
mapping to imp utility, 343–344
ISNUM function, 148
LELLISON user, 130
-j option, 565
--level option, 565
LEVEL pseudo-column, 166
■ J
LIST BACKUP command, 504, 525, 538, 557
\j variable, bash shell, 53
LIST BACKUP SUMARY command, 504
JOB_CLASS parameter, 571
LIST command, 504, 514
jobs
LIST FAILURE command, 512, 514
export, estimating size of, 317
list partition type, 272
monitoring, 338–340
list, partitioning tables by, 279–280
data-dictionary views, 338–339
listener
Data Pump log file, 338
configuring and implementing, 37–39
database alert log, 339
starting and stopping, 583–586
interactive command-mode status, 340
listener.log file, 588–589, 599–600
operating-system utilities, 340
listener.ora file, 4, 37–38
status table, 339
listing failures, 512–513
running, 314–315
loading
stopping and restarting, 315
BLOB, 265
terminating, 316
CLOB, 263–264
JOB_TYPE parameter, 571
loadvol command, 563
JR_DBA role, 130
LOB column, 253
-k option, 566
LOB_DATA tablespace, 253
LOBs (large objects), 243–268
■ K
adding column, 253
BasicFile, 246
KEEP_DUPLICATES clause, 258
657
■ INDEX
caching, 254
LOG_ARCHIVE_DEST_1 parameter, 426, 525,
chunks for, 244–246
537, 588
creating columns of, 248–252
LOG_ARCHIVE_DEST_N parameter, 422–425,
BasicFile LOB column, 248–249
