Cover image for Oracle8i : a beginner's guide
Title:
Oracle8i : a beginner's guide
Author:
Abbey, Michael.
Personal Author:
Publication Information:
Berkeley : Osborne/McGraw-Hill, [1999]

©1999
Physical Description:
xxx, 765 pages : illustrations ; 24 cm
General Note:
Includes index.

"Covers Oracle releases 7.x through 8i"--Cover.
Language:
English
Title Subject:
Subject Term:
ISBN:
9780072122046
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 A24 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

More than just a database server, Oracle8i offers a complete environment for Internet computing. Users will need to learn the considerable new feature set that it delivers, and this guide helps tie together the various applications, from the Java Virtual Machine to the integrated file system.


Table of Contents

Forewordp. XXIII
Acknowledgmentsp. XXV
Introductionp. XXIX
1 What Is Oracle?p. 1
Terminologyp. 3
What Is Oracle?p. 6
Oracle8i Serverp. 16
SQL*Plus-The User-Friendly Interfacep. 30
Oracle Forms-The Front Endp. 32
Oracle Reports-The Report Writerp. 32
SQL*Loaderp. 34
Oracle Using Its Own Tools- The Cooperative Applicationsp. 35
Oracle Designerp. 36
Personal Oracle8ip. 37
Oracle Discovererp. 37
Oracle8i Litep. 38
The Servicesp. 38
Oracle User Groups- Events and Publicationsp. 40
Data Warehousing with Oraclep. 41
What's Nextp. 41
2 The "i" in Oracle8ip. 43
Terminologyp. 44
Why the Internet Computing Modelp. 47
Electronic Businessp. 48
Does Everyone Really Need a Fat Client?p. 49
The Network Computing Architecturep. 52
Internet Computing Productsp. 56
What's Nextp. 58
3 Oracle8i and Object Relational Technologyp. 61
Terminologyp. 62
What Is an Object-Oriented Database?p. 65
Oracle8i-An Overviewp. 71
Oracle8i: Objects and New Database Objectsp. 79
Summaryp. 85
What's Nextp. 85
4 Architecturep. 87
Terminologyp. 88
Why Bother to Learn the Architecture?p. 90
What Is a Database?p. 91
Tablespaces-Oracle's Manila Folderp. 92
Redo Logs-The Transaction Logp. 96
Control Filesp. 99
Programsp. 100
Database Support Processesp. 101
Memory Structure-The Phone Linep. 105
What Is an Oracle Instance?p. 108
Let's Put It All Togetherp. 110
A Closer Look at the Multithreaded Server (MTS)p. 111
What's Nextp. 113
5 Database Objectsp. 115
Terminologyp. 116
Tables-Where Oracle Stores Your Datap. 117
Views-A Special Look at Your Datap. 124
Indexes-A Quick Way to Speed Access to Your Datap. 127
Synonyms-A New Identityp. 130
Grants-May I Please Have Access?p. 131
Roles-A Way to Group Users Togetherp. 134
Other Objects You May Encounter in Oracle8ip. 135
Viewing Object Information in the Data Dictionaryp. 137
What's Nextp. 138
6 Installationp. 141
Terminologyp. 142
The Oracle Universal Installerp. 144
Oracle8i Enterprise Editionp. 145
Oracle Web DBp. 157
Oracle Developerp. 160
Oracle JDeveloperp. 163
Oracle Enterprise Managerp. 167
Oracle8i Clientp. 175
What's Nextp. 181
7 SQL 101p. 183
Terminologyp. 185
Two Types of SQL Statementsp. 186
SQL*Plus: Getting Inp. 188
Number Data Typep. 201
Character Data Typep. 203
Date Data Typep. 204
Converting from One Column Type to Anotherp. 209
Update, Delete, and Alterp. 209
Joining Two Tables Togetherp. 211
Formatting the Outputp. 212
What's Nextp. 223
8 PL/SQLp. 227
Terminologyp. 229
Why Do I Need to Know PL/SQL?p. 231
PL/SQL Character Setp. 231
Variablesp. 233
Reserved Wordsp. 234
Common Data Typesp. 235
PL/SQL Componentsp. 237
Cursorsp. 251
PL/SQL Tablesp. 257
The Look of PL/SQLp. 258
Built-In Packagesp. 260
Compilation Errorsp. 260
Code Examplesp. 262
PL/SQL for the Internetp. 265
What's Nextp. 278
9 Oracle Developerp. 281
Terminologyp. 282
What Is Form Builder?p. 284
Application Tiers and Oracle Developerp. 284
Preparing Your Workstation to Run Form or Report Builderp. 286
Form Builder-A Quick Tourp. 287
Sample Datap. 298
Working with Form Builder-A Primerp. 300
More Hands-On Experience with Form Builderp. 309
Screen Formatting with Form Builderp. 319
Form Builder Runtime-Client/Serverp. 322
Working with the Report Builderp. 322
How Report Builder Processes Queries-A Primerp. 322
Report Builder-Hands Onp. 324
What's Nextp. 327
10 Loaderp. 331
Terminologyp. 332
What Is SQL*Loader?p. 334
SQL*Loader in a DOS Windowp. 334
SQL*Loader Control Filep. 339
SQL*Loader Outputsp. 342
SQL*Loader from OEMp. 346
What's Nextp. 352
11 Application Tuning 101p. 355
Why Tune Oracle Systems?p. 356
Terminologyp. 357
Main Components in the Tuning Processp. 360
Using Statements in the Shared Poolp. 367
Parallel Processingp. 379
Reducing Wait Situationsp. 381
What's Nextp. 382
12 Advanced SQLp. 385
Terminologyp. 386
Functions That Group Resultsp. 387
Query Within a Queryp. 389
Creating Datafiles for Other Programsp. 390
SQL Creating SQLp. 392
The decode Statementp. 393
Defining Variables in SQL*Plusp. 394
Substitution Variables in SQL*Plusp. 395
New SQL*Plus Featuresp. 398
repheader-the Whole Header and Nothing but the Headerp. 399
column-the Whole Column and Nothing but the Columnp. 401
new_valuep. 405
SQL*Plus Set Theoryp. 406
Structured Code Techniquesp. 408
Command Line Editingp. 410
Nulls in SQL*Plusp. 413
What's Nextp. 416
13 Advanced Application Tuningp. 419
Terminologyp. 420
Optimizationp. 421
SQL Statement Processingp. 434
Naming Variablesp. 439
What Should Be Indexed?p. 440
Primary Key Constraintsp. 441
Tools of the Tuning Tradep. 442
What's Nextp. 453
14 DBA 101p. 455
Becoming a Database Administratorp. 457
Terminologyp. 458
Oracle Enterprise Manager- A Quick Tourp. 459
Administration Using OEM 2.0p. 463
Server Managerp. 482
What's Nextp. 488
15 Export and Importp. 491
Terminologyp. 493
What Export and Import Can Do for Youp. 493
Similarities Between Export and Importp. 495
Differences Between Export and Importp. 495
Methods of Operationp. 495
Export and Import Modesp. 509
Using Export and Import with Partitioned Tablesp. 514
Requirements for Running Export and Importp. 515
Error Conditions and Their Solutionsp. 515
Relationship Between Parametersp. 517
Examplesp. 517
Export and Import from OEMp. 518
What's Nextp. 523
16 Backup and Recoveryp. 525
Terminologyp. 526
Protection Provided by Backupp. 527
Export and Import Backupp. 533
Image Backupsp. 538
Recoveryp. 542
A Complete Backup Planp. 552
What's Nextp. 554
17 Database Tuningp. 557
Terminologyp. 558
Initialization Parameter (init.ora) Filep. 559
I/O Streamp. 571
Summaryp. 573
What's Nextp. 574
18 Advanced DBAp. 577
Terminologyp. 579
Startup Optionsp. 580
Operation Modesp. 586
Shutdown Optionsp. 586
Additional User Management Responsibilitiesp. 587
Additional Tablespace Maintenance Responsibilitiesp. 595
Managing Redo Log Groupsp. 600
Rollback Segmentsp. 606
The Initialization Parameter Filep. 611
Control File Responsibilitiesp. 615
Getting the Most from Your Error Messagesp. 621
The Data Dictionaryp. 624
Working with Oracle Worldwide Customer Supportp. 628
"But I Can't See the Forest for the Trees"p. 629
What's Nextp. 629
19 Data Warehouse Featuresp. 631
Terminologyp. 634
Bitmap Indexing (7.3.2 and 8)p. 636
Optimizer Histograms (7.3.2 and 8)p. 639
Parallelizationp. 640
Partitioning Objects (8)p. 644
Materialized Views (8i)p. 646
Transportable Tablespaces (8i)p. 651
Extended Aggregate Operations (8i)p. 654
Star Query Optimization (7.3 and 8)p. 659
What's Nextp. 660
20 WebDBp. 663
Terminologyp. 665
WebDB Architecturep. 668
WebDB Usersp. 670
Navigating WebDBp. 671
Database and WebDBp. 675
Building WeDB Objectsp. 680
Administration of WebDB and the Databasep. 690
Monitoring with WebDBp. 697
WebDB Sitesp. 701
What's Nextp. 703
21 JDeveloperp. 705
Terminologyp. 706
Overview of Javap. 707
What Is JDeveloper?p. 709
Preparing Your Workstation to Run JDeveloper Against Oraclep. 709
JDeveloper-A Quick Tourp. 710
The AppBrowserp. 712
More Hands-On Experience with JDeveloperp. 728
Where Should You Go from Herep. 738
Indexp. 741

Google Preview