没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle 10g Administration Workshop I
Oracle 10g Administration Workshop I
5星 · 超过95%的资源 需积分: 10 89 下载量 183 浏览量
更新于2023-03-03
评论
收藏 5.66MB PDF 举报
Oracle 10g Administration Workshop I (PDF)
资源详情
资源评论
资源推荐
Oracle Database 10g:
Administration Workshop I
StudentGuide
D17090GC10
Edition 1.0
March 2004
D39126
®
Copyright © 2004, Oracle. All rights reserved.
This documentation contains proprietary information of Oracle Corporation. It is
provided under a license agreement containing restrictions on use and disclosure and
is also protected by copyright law. Reverse engineering of the software is prohibited.
If this documentation is delivered to a U.S. Government Agency of the Department of
Defense, then it is delivered with Restricted Rights and the following legend is
applicable:
Restricted Rights Legend
Use, duplication or disclosure by the Government is subject to restrictions for
commercial computer software and shall be deemed to be Restricted Rights software
under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013,
Rights in Technical Data and Computer Software (October 1988).
This material or any portion of it may not be copied in any formor by any means
without the express prior written permission of Oracle Corporation. Any other copying
is a violation of copyright law and may result in civil and/or criminal penalties.
If this documentation is delivered to a U.S. Government Agency not within the
Department of Defense, then it is delivered with “Restricted Rights,” as defined in
FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).
The information in this document is subject to change without notice. If you find any
problems in the documentation, please report them in writing to Education Products,
Oracle Corporation, 500 Oracle Parkway, Redwood Shores, CA 94065. Oracle
Corporation does not warrant that this document is error-free.
Oracle and all references to Oracle Products are trademarks or registered trademarks
of Oracle Corporation.
All other products or company names are used for identification purposes only, and
may be trademarks of their respective owners.
Authors
RicVan Dyke
Russ Lowenthal
Technical Contributors
and Reviewers
Donna Keesling
S. Matt Taylor
Jean-Francois Verrier
Craig Hollister
Bob Bungenstock
Tony Woodell
Joel Goodman
John Watson
Dairy Chan
Martin Jensen
Janet Stern
Dr. Sabine Teuber
Kyle Hailey
Christopher Lawless
Dominique Laugraud
Isabelle Marchand
Yi Lu
Editor
Elizabeth Treacy
Publisher
Jobi Varghese
1 Introduction
Objectives 1-2
Course Objectives 1-3
Oracle Products 1-4
Relational Database Systems 1-5
How the Data Is Organized 1-6
Integrity Constraints 1-7
Structured Query Language 1-8
Tasks of an Oracle Database Administrator 1-9
Summary 1-10
2 Installing Oracle Database 10g Software
Objectives 2-2
System Requirements 2-3
Optimal Flexible Architecture (OFA) 2-4
Using Optimal Flexible Architecture 2-5
Setting Environment Variables 2-7
PreinstallationChecks 2-9
Oracle Universal Installer 2-10
Inventory and UNIX Group Name 2-11
orainstRoot.sh 2-12
File Locations 2-14
Install Type 2-15
Prerequisite Checks 2-16
Starter Database 2-17
Configuration and Management 2-18
File Storage and Backup Recovery 2-19
Passwords and Summary 2-20
Installation 2-21
Configuration Assistants 2-22
Summary 2-24
Practice 2: Installing the Oracle Software 2-25
3 Creating an Oracle Database
Objectives 3-2
Database Architecture 3-3
Exploring the Storage Structure 3-4
Control Files 3-5
Redo Log Files 3-6
TablespacesandDatafiles 3-7
Segments, Extents, and Blocks 3-8
Contents
i
Oracle Instance Management 3-9
Oracle Memory Structures 3-10
Oracle Processes 3-12
Data Dictionary 3-13
Database Control 3-14
Grid Control 3-15
Database Configuration Assistant (DBCA) Overview 3-16
Creating a Database 3-17
Database Identification 3-18
Management Options 3-19
Passwords and Storage 3-20
File Locations and Backup Recovery 3-21
File Location Variables 3-22
Content and Initialization Parameters 3-23
Database Storage 3-25
Creation Options and Create 3-26
Other Actions with DBCA 3-27
Summary 3-28
Practice 3: Creating an Oracle Database 3-29
4 Database Interfaces
Objectives 4-2
What Is SQL? 4-3
Using SQL 4-4
Enterprise Manager: Seeing the SQL 4-5
What Is SQL*Plus? 4-6
What Is iSQL*Plus? 4-7
Using iSQL*Plus 4-9
Describing Data 4-10
Querying Data 4-11
Sorting the Data 4-12
Joining Tables 4-13
Manipulating Data 4-15
Defining Data 4-16
Overview of Transactions 4-17
Transaction Control Statements 4-18
Locking Data 4-19
Other Statement Categories 4-20
What Is PL/SQL? 4-21
Example PL/SQL Block 4-22
Uses of PL/SQL 4-23
What Is Java? 4-24
Oracle and Java 4-25
ii
What Is OCI? 4-26
Other APIs 4-27
Summary 4-29
Practice 4: Using SQL 4-30
5 Controlling the Database
Objectives 5-2
Starting and Stopping iSQL*Plus 5-3
Management Framework 5-4
Starting and Stopping Database Control 5-5
Accessing Database Control 5-6
SYSOPER and SYSDBA 5-7
Database Home Page 5-8
Changing the Listener Status 5-9
Startup and Shutdown 5-10
Starting Up a Database NOMOUNT 5-11
Starting Up a Database MOUNT 5-12
Starting Up a Database OPEN 5-13
Shutting Down the Database 5-14
SHUTDOWN Options 5-15
Initialization Parameter Files 5-18
Viewing Initialization Parameters 5-19
Viewing the Alert Log 5-20
Summary 5-21
Practice 5: Controlling the Database 5-22
6 Storage Structures
Objectives 6-2
Tablespacesand Data Files 6-3
Space Management inTablespaces 6-4
Creating a NewTablespace 6-5
Storage for Locally ManagedTablespaces 6-7
Tablespacesin thePreconfiguredDatabase 6-9
Altering aTablespace 6-11
Actions withTablespaces 6-13
DroppingTablespaces 6-15
ViewingTablespaceInformation 6-16
Summary 6-17
Practice 6: Working withTablespaces 6-18
iii
剩余503页未读,继续阅读
Gugu_Abrams
- 粉丝: 1
- 资源: 100
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- ExcelVBA中的Range和Cells用法说明.pdf
- 基于单片机的电梯控制模型设计.doc
- 主成分分析和因子分析.pptx
- 共享笔记服务系统论文.doc
- 基于数据治理体系的数据中台实践分享.pptx
- 变压器的铭牌和额定值.pptx
- 计算机网络课程设计报告--用winsock设计Ping应用程序.doc
- 高电压技术课件:第03章 液体和固体介质的电气特性.pdf
- Oracle商务智能精华介绍.pptx
- 基于单片机的输液滴速控制系统设计文档.doc
- dw考试题 5套.pdf
- 学生档案管理系统详细设计说明书.doc
- 操作系统PPT课件.pptx
- 智慧路边停车管理系统方案.pptx
- 【企业内控系列】企业内部控制之人力资源管理控制(17页).doc
- 温度传感器分类与特点.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1