Oracle8i Supplied Packages Reference -- Index

Advanced Queuing

administrative interface, 4 - 11

DBMS_AQADM package, 5 - 1

altering

priority levels, 34 - 17

propagation method, 34 - 14, 34 - 22

replicated objects, 34 - 16

anonymous PL/SQL blocks

dynamic SQL and, 48 - 2

arrays

BIND_ARRAY procedure, 48 - 6

bulk DML using DBMS_SQL, 48 - 15

asynchronous

DDL, 34 - 57

Calendar package, 1 - 12

catproc.sql script, 1 - 2

character sets

ANY_CS, 17 - 3

CLOB datatype

NCLOBs, 17 - 3

collections

table items, 48 - 15

column groups

adding members to

syntax, 34 - 5

creating

syntax, 34 - 40, 34 - 61

dropping

syntax, 34 - 44

removing members from

syntax, 34 - 45

comparing

tables, 31 - 2

conflicts

resolution

adding method of, 34 - 10

statistics, 34 - 23, 34 - 66

CREATE PACKAGE BODY command, 1 - 2

CREATE PACKAGE command, 1 - 2

creating

column groups

syntax, 34 - 40, 34 - 61

packages, 1 - 2

priority groups, 34 - 41

refresh groups, 32 - 5

replicated object groups

syntax, 34 - 33

replicated objects

generating support for, 34 - 58

snapshot sites, 34 - 38

syntax, 34 - 34

site priority groups

syntax, 34 - 43

snapshot sites

syntax, 34 - 37

cursors

DBMS_SQL package, 48 - 4

data definition language (DDL)

supplying asynchronous, 34 - 57

datatypes

DBMS_DESCRIBE, 11 - 5

DESC_TAB, 48 - 31

NCLOB, 17 - 3

PL/SQL

numeric codes for, 11 - 9

ROWID, 42 - 1

DBMS_ALERT package, 2 - 1

DBMS_APPLICATION_INFO package, 3 - 2

DBMS_AQ package, 4 - 1

DBMS_AQADM package, 5 - 1

DBMS_DDL package, 6 - 1

DBMS_DEBUG package, 7 - 1

DBMS_DEFER package, 8 - 1

DBMS_DEFER_QUERY package, 9 - 1

DBMS_DEFER_SYS package, 10 - 1

DBMS_DESCRIBE package, 11 - 1

DBMS_DISTRIBUTED_TRUST_ADMIN package, 12 - 1

DBMS_HS package, 13 - 1

DBMS_HS_PASSTHROUGH package, 14 - 1

DBMS_IOT package, 15 - 1

DBMS_JOB package, 16 - 1

DBMS_LOB package, 17 - 1

DBMS_LOCK package, 18 - 1

DBMS_LOGMNR package, 19 - 1

DBMS_LOGMNR_D package, 20 - 1

DBMS_MVIEW package

DBMS_SNAPSHOT package, 45 - 1

DBMS_OFFLINE_OG package, 21 - 1

DBMS_OFFLINE_SNAPSHOT package, 22 - 1

DBMS_OLAP package, 23 - 1

DBMS_ORACLE_TRACE_AGENT package, 24 - 1

DBMS_ORACLE_TRACE_USER package, 25 - 1

DBMS_OUTPUT package, 26 - 1

DBMS_PCLXUTIL package, 27 - 1

DBMS_PIPE package, 28 - 1

DBMS_PROFILER package, 29 - 1

DBMS_RANDOM package, 30 - 1

DBMS_RECTIFIER_DIFF package, 31 - 1

DBMS_REFRESH package, 32 - 1

DBMS_REPAIR package, 33 - 1

DBMS_REPCAT package, 34 - 1

DBMS_REPCAT_ADMIN package, 35 - 1

DBMS_REPCAT_INSTANTIATE package, 36 - 1

DBMS_REPCAT_RGT package, 37 - 1

DBMS_REPUTIL package, 38 - 1

DBMS_RESOURCE_MANAGER package, 39 - 1

DBMS_RESOURCE_MANAGER_PRIVS package, 40 - 1

DBMS_RLS package, 41 - 1

DBMS_ROWID package, 42 - 1

DBMS_SESSION package, 43 - 1

DBMS_SHARED_POOL package, 44 - 1

DBMS_SNAPSHOT package

DBMS_MVIEW package, 45 - 1

DBMS_SPACE package, 46 - 1

DBMS_SPACE_ADMIN package, 47 - 1

DBMS_SQL package

locating errors, 48 - 33

DBMS_STATS package, 49 - 1

DBMS_TRACE package, 50 - 1

DBMS_TRANSACTION package, 51 - 1

DBMS_TTS package, 52 - 1

DBMS_UTILITY package, 53 - 1

DEBUG_EXPTOC package, 54 - 1

DefDefaultDest table

adding destinations to, 10 - 3

removing destinations from, 10 - 3, 10 - 4

deferred transactions

DefDefaultDest table

adding destination to, 10 - 3

removing destinations from, 10 - 3, 10 - 4

deferred remote procedure calls (RPCs)

argument types, 9 - 3

argument values, 9 - 6

arguments to, 8 - 4

building, 8 - 2

executing immediately, 10 - 11

re-executing, 10 - 7

removing from queue, 10 - 5

scheduling execution, 10 - 15

starting, 8 - 5

DefError table

deleting transactions from, 10 - 4

DESC_TAB datatype, 48 - 31

differences

between tables, 31 - 2

rectifying, 31 - 5

disabling

propagation, 10 - 17

dropping

column groups

syntax, 34 - 44

master sites, 34 - 69

priority groups, 34 - 49

replicated objects

from master sites, 34 - 48

from snapshot sites, 34 - 54

groups of, 34 - 46

site priority groups, 34 - 52

snapshot sites, 34 - 53

dynamic SQL

anonymous blocks and, 48 - 2

DBMS_SQL functions, using, 48 - 2

errors, locating, 48 - 33

execution flow in, 48 - 4

errors

locating in dynamic SQL, 48 - 33

returned by DBMS_ALERT package, 15 - 3

execution flow

in dynamic SQL, 48 - 4

fine-grained access control

DBMS_RLS package, 41 - 1

generating

snapshot support, 34 - 60

importing

object groups

offline instantiation and, 21 - 3, 21 - 5

snapshots

offline instantiation and, 22 - 2, 22 - 3

status check, 34 - 70

jobs

queues for

removing jobs from, 10 - 19

LOBs

DBMS_LOB package, 17 - 1

master definition sites

relocating, 34 - 67

master sites

creating, 34 - 7

dropping, 34 - 69

propagating changes between, 10 - 15

national language support

NCLOBs, 17 - 3

offline instantiation

replicated object groups, 21 - 2, 21 - 3, 21 - 4, 21 - 5, 21 - 6

snapshots, 22 - 2, 22 - 3

OR REPLACE clause

for creating packages, 1 - 3

Oracle Advanced Queuing (Oracle AQ)

DBMS_AQADM package, 5 - 1

OUTLN_PKG package, 55 - 1

package overview, 1 - 2

packages

creating, 1 - 2

referencing, 1 - 5

where documented, 1 - 6

plan stability, 55 - 1

PL/SQL

datatypes, 11 - 6

numeric codes for, 11 - 9

preface

conventions table sample, xxxiv

Send Us Your Comments, xxix

priority groups

adding members to, 34 - 8

altering members

removing members from, 34 - 49, 34 - 50

site priority groups

adding members to, 34 - 9

propagating changes

altering propagation method, 34 - 22

propagation

disabling, 10 - 17

of changes

altering propagation method, 34 - 14

status of, 10 - 6

purging

RepCatLog table, 34 - 63

statistics, 34 - 63

queuing

DBMS_AQADM package, 5 - 1

quiescing

replicated schemas, 34 - 75

rectifying

tables, 31 - 5

refresh

snapshot sites

syntax, 34 - 64

snapshots, 45 - 7, 45 - 9, 45 - 10

refresh groups

adding members to, 32 - 2

refresh interval

refreshing

removing members from, 32 - 8

RepCatLog view

purging, 34 - 63

RepColumn_Group table

updating, 34 - 24

RepGroup view

updating, 34 - 26

replicated object groups

dropping, 34 - 46

offline instantiation of, 21 - 2, 21 - 3, 21 - 4, 21 - 5, 21 - 6

replicated objects

altering, 34 - 16

creating

master sites, 34 - 34

snapshot sites, 34 - 38

creating master group, 34 - 33

DROP_MASTER_REPOBJECT and, 34 - 48

dropping

snapshot site, 34 - 54

generating support for, 34 - 58

RepObject table

updating, 34 - 28

RepPriority_Group table

updating, 34 - 25

RepResolution table

updating, 34 - 29

RepResolution_Statistics table

purging, 34 - 63

RepSite view

updating, 34 - 27

resuming replication activity, 34 - 71

ROWID datatype

DBMS_ROWID package, 42 - 1

extended format, 42 - 12

SDO_ADMIN package, 1 - 14

SDO_GEOM package, 1 - 14

SDO_MIGRATE package, 1 - 14

SDO_TUNE package, 1 - 14

Send Us Your Comments, xxix

site priority

altering, 34 - 20

site priority groups

adding members to, 34 - 9

creating

syntax, 34 - 43

dropping, 34 - 52

removing members from, 34 - 52

snapshot logs

master table

purging, 45 - 4, 45 - 5

snapshot sites

changing masters, 34 - 76

creating

syntax, 34 - 37

dropping, 34 - 53

propagating changes to master, 10 - 15

refreshing

syntax, 34 - 64

snapshots

offline instantiation of, 22 - 2, 22 - 3

refreshing, 45 - 7, 45 - 9, 45 - 10

SQL statements

larger than 32 KB, 48 - 12

SQL*Plus

creating a sequence, 1 - 5

statistics

collecting, 34 - 66

status

propagation, 10 - 6

stored outlines

OUTLN_PKG package, 55 - 1

tables

comparing, 31 - 2

rectifying, 31 - 5

table items as arrays, 48 - 15

TimeScale package, 1 - 15

TimeSeries package, 1 - 16

TSTools package, 1 - 19

UTL_COLL package, 56 - 1

UTL_FILE package, 57 - 1

UTL_HTTP package, 58 - 1

UTL_PG package, 1 - 20

UTL_RAW package, 59 - 1

UTL_REF package, 60 - 1

Vir_Pkg package, 1 - 21