Index

C

command termination

in SQL Commands, 3.5.4

Create Lookup Table, 1.4.3

D

data

exporting from database, 4.2.3

loading, 4.2

loading into database, 4.2.2

unloading, 4.2, 4.2.3

data dictionary

browsing, 4.4.5

database

loading data into, 4.2

monitoring, 4.8

unloading data from, 4.2

database definition language

generating DDL statements, 4.3

database link

browsing, 1.13.2

creating, 1.13.1

testing, 1.13.2.1

Database Monitor

I/O, 4.8.1.4

Locks, 4.8.1.2

Long Operations, 4.8.4

Open Cursors, 4.8.1.6

Sessions, 4.8.1, 4.8.1.1

SQL, 4.8.1.5

Top SQL, 4.8.3

Waits, 4.8.1.3

database monitoring

system statistics, 4.8.2

database objects

purging, 4.5

restoring, 4.5

database security

Column Privileges report, 4.4.2

Role Privileges report, 4.4.2

System Privileges report, 4.4.2

DDL

generating, 4.3

E

Excel

importing, 4.2.2.2

Explain Plan

using, 3.11, 3.11.2

Export XML Wizard, 4.2.3.2

exporting data

summary of available methods, 4.1.1

F

function

browsing, 1.11.2

compiling, 1.11.4

creating, 1.11.1

downloading, 1.11.5

dropping, 1.11.6

editing, 1.11.3

I

imported text data

viewing, 4.2.4

importing data

summary of available methods, 4.1.1

index

browsing, 1.6.2

creating, 1.6.1

disabling, 1.6.2, 1.6.2.1

dropping, 1.6.3

rebuilding, 1.6.2, 1.6.2.1

statistics about, 1.6.2.1

I/O report, 4.8.1.4

L

Load Data Wizard, 4.2.2.1

Load XML Wizard, 4.2.2.3

loaded text data

deleting, 4.2.4

Locks report, 4.8.1.2

M

materialized view

browsing, 1.14.2

creating, 1.14.1

dependent objects, 1.14.2.1

dropping, 1.14.3

list of grants, 1.14.2.1

report of data, 1.14.2.1

sort by column, 1.14.2.1

viewing object details, 1.14.2.1

O

Object Browser

about, 1.1

accessing, 1.1.1

creating objects, 1.3

Detail pane, 1.1

Hide Objects control, 1.2.2

hiding Object Selection pane, 1.2.2

managing database links, 1.13

managing functions, 1.11

managing indexes, 1.6

managing materialized views, 1.14

managing packages, 1.9

managing procedures, 1.10

managing sequences, 1.7

managing tables, 1.4

managing triggers, 1.12

managing types, 1.8

managing views, 1.5

Object Selection pane, 1.1

searching for objects, 1.2

synonyms, 1.15

Object Reports

All Objects, 4.4.5

All Objects report, 4.4.5

Column Privileges report, 4.4.2

Data Dictionary, 4.4.5

Exception Reports, 4.4.4

Invalid Objects, 4.4.5

Object Calendar, 4.4.5

Object Counts by Type, 4.4.5

PL/SQL Source Code report, 4.4.3.3

Program Unit Arguments report, 4.4.3.1

Role Privileges report, 4.4.2

System Privileges report, 4.4.2

Unit Line Counts report, 4.4.3.2

objects

purging, 4.5

restoring, 4.5

Open Cursors report, 4.8.1.6

Oracle Optimizer

Explain Plan, 3.11, 3.11.2

P

package

compiling, 1.9.4

creating, 1.9.1

downloading, 1.9.2.1, 1.9.5

dropping, 1.9.6

editing, 1.9.2.1, 1.9.3

finding, 1.9.2.1

grants for, 1.9.2.1

object dependencies, 1.9.2.1

package body, 1.9.2.1

related errors, 1.9.2.1

viewing, 1.9.2

procedure

browsing, 1.10.2

compiling, 1.10.4

creating, 1.10.1

downloading, 1.10.5

dropping, 1.10.6

editing, 1.10.3

editing manually, 1.10.3.1

finding, 1.10.2.1

Q

Query Builder, 5

about, 5.1

accessing, 5.1.1

Conditions tab, 5.4

creating joins automatically, 5.5.3

creating joins manually, 5.5.2

creating relationships between objects, 5.5

filtering objects, 5.2.1

hiding objects in Design Pane, 5.3.3

Object Selection pane, 5.2, 5.2.2

removing objects in Design Pane, 5.3.3

resizing panes, 5.3.2.1

Results tab, 5.8

Saved SQL tab, 5.6.2

saving queries, 5.6

searching for objects, 5.2.1

specifying query conditions, 5.4

supported column types, 5.3, 5.3.1

Table Actions, 5.5.3

View Actions, 5.5.3

viewing generated SQL, 5.7

viewing query results, 5.8

R

Recycle Bin

purging, 4.5

searching, 4.5

using, 4.5

viewing objects, 4.5

reports

Data Dictionary, 4.4.5

database objects, 4.4.5

exception reports, 4.4.4

PL/SQL Source Code, 4.4.3.3

Program Unit Arguments, 4.4.3.1

Unit Line Counts report, 4.4.3.2

results, 2.2.1

S

scripts

creating in editor, 2.3.1

deleting from editor, 2.5.2

deleting from SQL Scripts page, 2.5.1

executing, 2.7

executing from SQL Scripts page, 2.7.2

executing in editor, 2.7.1

export, 2.2.1

exporting, 2.9

importing, 2.9

results, 2.2.1

SQL Script editor, 2.4

uploading to another account, 2.2.1

uploading to SQL Scripts, 2.3.2

viewing repository quotas, 2.10

Security reports

Column Privileges report, 4.4.2

sequence

altering, 1.7.2.1

browsing, 1.7.2

creating, 1.7.1

dependent objects, 1.7.2.1

dropping, 1.7.3

grants associated with, 1.7.2.1

session

killing, 4.8.1.1

Session report, 4.8.1.1

spreadsheets

importing, 4.2.2.2

SQL Commands

command termination, 3.5.4

Explain Plan, running, 3.11, 3.11.2

home page, 3.4

transaction support, 3.5.2

SQL report, 4.8.1.5

SQL Scripts

accessing, 2.2

creating script in editor, 2.3.1

deleting script from editor, 2.5.2

deleting script from SQL Scripts home page, 2.5.1

executing script from SQL Scripts page, 2.7.2

executing script in editor, 2.7.1

exporting scripts, 2.9

importing scripts, 2.9

script editor, 2.4

SQL Scripts page, 2.2.1

uploading script, 2.3.2

viewing quotas, 2.10

viewing script results, 2.8.1

SQL Scripts page

accessing Manage Script Results, 2.2.1

Show Quotas, 2.2.1

Task list, 2.2.1

SQL Scripts page Task list

export scripts, 2.2.1

uploading scripts, 2.2.1

SQL Workshop

about, 3.2

SQL*Plus command support, 3.5.3

SQL*Plus commands

unsupported, 3.5.3

synonym

creating, 1.15.1

dropping, 1.15.3

viewing, 1.15.2

T

tab-delimited file

loading, 4.2.2.1

tables

add column, 1.4.3

browsing, 1.4.2

constraints, 1.4.2.1

copy, 1.4.3

creating, 1.4.1

drop column, 1.4.3

dropping, 1.4.4

editing, 1.4.3

exports data to spreadsheet, 1.4.2.1

grants on, 1.4.2.1

indexes associated, 1.4.2.1

insert row, 1.4.2.1

modify column, 1.4.3

remove all rows, 1.4.3

rename, 1.4.3

rename column, 1.4.3

report of number of rows, 1.4.2.1

sort by column, 1.4.2.1

statistics about, 1.4.2.1

user interface defaults, 1.4.2.1

viewing data, 1.4.2.1

Text Data Load Repository, 4.2.4

text file

loading, 4.2.2.1

transaction support, 3.5.2

trigger

browsing, 1.12.2

compiling, 1.12.4

creating, 1.12.1

downloading, 1.12.5

dropping, 1.12.6

editing, 1.12.3

type

browsing, 1.8.2

creating, 1.8.1

dropping, 1.8.3

grants associated with, 1.8.2.1

list of synonyms, 1.8.2.1

U

Unload to Text Wizard, 4.2.3.1

Unload to XML Wizard, 4.2.3.2

Utilities

Data Dictionary, 4.4.5

utilities

about, 4

comparing schemas, 4

generating DDL, 4

loading data, 4

monitoring the database, 4

restoring dropped objects, 4

unloading data, 4

viewing database details, 4

viewing object reports, 4

V

view

browsing, 1.5.2

compiling, 1.5.4

creating, 1.5.1

dropping, 1.5.5

editing, 1.5.3

grants associated with, 1.5.2.1

objects referenced by, 1.5.2.1

report of data, 1.5.2.1

user interface defaults, 1.5.2.1

W

Waits report, 4.8.1.3

wizards

copying and pasting tab-delimited data, 4.2.2.1

exporting contents of table, 4.2.3.1

exporting text file, 4.2.3.1

exporting XML, 4.2.3.2

importing text, 4.2.2.1

importing XML, 4.2.2.3

X

XML document

exporting to, 4.2.3.2

loading, 4.2.2.3

Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices

Previous