JavaScript+权威指南(英文第5版)(javascript+The+Definitive+Guide).rar
JavaScript+权威指南(英文第5版)(javascript+The+Definitive+Guide).rar
JavaScript+权威指南(英文第5版)(javascript+The+Definitive+Guide).rar
Http协议讲解.rar
Http协议讲解.rar
Http协议讲解.rar
Http协议讲解.rar
Http协议讲解.rar
HTML基础实例.rar
HTML基础实例.rar
HTML基础实例.rar
HTML基础实例.rar
HTML基础实例.rar
html基础教程.rar
html基础教程.rar
html基础教程.rar
html基础教程.rar
html基础教程.rar
html参考手册+CSS参考手册+html资源等12个文件.rar
html参考手册+CSS参考手册+html资源等12个文件.rar
html参考手册+CSS参考手册+html资源等12个文件.rar
《Java+EE编程技术》-源代码和课件下载
《Java+EE编程技术》-源代码和课件下载
《Java+EE编程技术》-源代码和课件下载
《Java+EE编程技术》-源代码和课件下载
J2EE网络编程标准教程
J2EE网络编程标准教程
J2EE网络编程标准教程
J2EE网络编程标准教程
J2EE网络编程标准教程
EJB系统开发实战录
EJB系统开发实战录
EJB系统开发实战录
EJB系统开发实战录
EJB系统开发实战录
Struts2 + Spring 2.5 + Hibernate教程.rar
Struts2 + Spring 2.5 + Hibernate 3.2教程.rar
Struts2 + Spring 2.5 + Hibernate 3.2教程.rar
Struts2 + Spring 2.5 + Hibernate 3.2教程.rar
JAVA解惑.rar JAVA解惑.rar
JAVA解惑.rarJAVA解惑.rar
对于在学习Java中遇到的普遍问题进行详细讲解!
Javascrip5日快速教程.CHM
Javascrip5日快速教程.CHM
Javascrip5日快速教程.CHM
Javascrip5日快速教程.CHM
Javascrip5日快速教程.CHM
Java基础到高级 入门之经典
《Java程序设计》01 第一天 Java程序设计基础.pdf
《Java程序设计》02 第二天 Java程序设计高级技术.pdf
《Java程序设计》03 第三天 上午 GUI与设计模式.pdf
《Java程序设计》03 第三天 下午 持久化.pdf
《Java程序设计》04 第四天 上午 JSP、Structs.pdf
《Java程序设计》04 第四天 下午 SSH.pdf
《Java程序设计》05 第五天 EJB组件模型与J2EE规范 .pdf
Thinking.In.Java.4th.Edition.2007..part2.rar
Bruce.Eckel.Thinking.In.Java.4th.Edition.2007..part2.rar
Thinking.In.Java.4th.Edition.2007..part1.rar
Bruce.Eckel.Thinking.In.Java.4th.Edition.2007..part1.rar
Oracle培训资料(中兴,清晰)
第1章数据库基础......................................................................................................................................1
1.1 基本概念...........................................................................................................................................1
1.1.1 数据.........................................................................................................................................1
1.1.2 数据库.....................................................................................................................................1
1.1.3 数据库管理系统......................................................................................................................1
1.1.4 数据库系统..............................................................................................................................1
1.2 关系数据库.......................................................................................................................................1
1.2.1 关系模型.................................................................................................................................2
1.2.2 关系数据库..............................................................................................................................2
1.3 常见的数据库对象............................................................................................................................3
1.3.1 表.............................................................................................................................................3
1.3.2 索引.........................................................................................................................................3
1.3.3 视图.........................................................................................................................................3
1.3.4 存储过程.................................................................................................................................3
1.4 范式...................................................................................................................................................4
1.4.1 第一范式.................................................................................................................................4
1.4.2 第二范式.................................................................................................................................4
1.4.3 第三范式.................................................................................................................................4
1.5 DML语言...........................................................................................................................................5
1.5.1 查询数据.................................................................................................................................5
1.5.2 插入数据.................................................................................................................................8
1.5.3 修改数据.................................................................................................................................9
1.5.4 删除数据.................................................................................................................................9
第2章 ORACLE SERVER构成..............................................................................................................10
2.1 概述.................................................................................................................................................10
2.2 ORACLE实例..................................................................................................................................10
2.2.1 ORACLE进程.........................................................................................................................11
2.2.2 ORACLE内存结构.................................................................................................................13
2.3 ORACLE数据库...............................................................................................................................14
2.3.1 数据库物理结构.....................................................................................................................15
2.3.2 数据库逻辑结构.....................................................................................................................16
2.4 模式和模式对象...............................................................................................................................19
2.4.1 表............................................................................................................................................19
2.4.2 视图........................................................................................................................................20
2.4.3 聚集........................................................................................................................................20
2.4.4 索引........................................................................................................................................20
2.4.5 程序单元................................................................................................................................21
第3章用户管理........................................................................................................................................22
3.1 创建用户..........................................................................................................................................22
3.2 撤销和改变用户...............................................................................................................................23
3.3 用户权限..........................................................................................................................................23
3.3.1 系统权限................................................................................................................................23
3.3.2 对象权限................................................................................................................................26
3.4 角色..................................................................................................................................................27
3.4.1 创建角色................................................................................................................................27
3.4.2 授予和取消角色.....................................................................................................................28
3.4.3 启用角色................................................................................................................................28
3.5 查询与权限和角色有关的视图.......................................................................................................28
3.6 概要文件..........................................................................................................................................29
3.6.1 创建profile.............................................................................................................................30
3.6.2 查询用户和profile相关信息的数据字典视图.......................................................................31
第4章启动和关闭数据库.........................................................................................................................33
4.1 启动数据库......................................................................................................................................33
4.1.1 正常启动................................................................................................................................33
4.1.2 非加载启动.............................................................................................................................34
4.1.3 加载启动................................................................................................................................35
4.1.4 约束启动................................................................................................................................35
4.1.5 强制数据库启动.....................................................................................................................36
4.2 更改数据库的可用性.......................................................................................................................36
我们的论坛http://forum.meslog.cn
iii
4.2.1 将数据库装入实例................................................................................................................36
4.2.2 打开一个关闭的数据库........................................................................................................36
4.3 关闭数据库.....................................................................................................................................36
4.3.1 用normal选项关闭.................................................................................................................37
4.3.2 用immediate 选项关闭.........................................................................................................37
4.3.3 用transactional 选项关闭......................................................................................................38
4.3.4 用abort选项关闭....................................................................................................................38
4.4 通过诊断文件监控数据库运行......................................................................................................38
4.4.1 后台进程运行跟踪文件........................................................................................................38
4.4.2 警告日志文件........................................................................................................................38
4.4.3 用户跟踪文件........................................................................................................................39
第5章 ORACLE NET.............................................................................................................................40
5.1 ORACLE NET体系结构...................................................................................................................40
5.1.1 客户机/服务器结构...............................................................................................................40
5.1.2 瘦客户机结构........................................................................................................................41
5.2 ORACLE NET服务器端...................................................................................................................43
5.2.1 监听器进程............................................................................................................................43
5.2.2 listener.ora文件.......................................................................................................................43
5.3 UNIX环境下的监听器进程.............................................................................................................44
5.3.1 启动和停止监听器进程........................................................................................................44
5.3.2 查看监听程序运行状况........................................................................................................44
5.3.3 lsnrctl命令的参数...................................................................................................................44
5.4 连接描述符.....................................................................................................................................46
第6章数据字典........................................................................................................................................48
6.1 内部RDBMS(X$)表...................................................................................................................48
6.2 数据字典表.....................................................................................................................................49
6.3 动态性能视图.................................................................................................................................49
6.4 数据字典视图.................................................................................................................................49
6.5 数据字典举例.................................................................................................................................49
6.5.1 数据字典总体信息................................................................................................................49
6.5.2 模式对象信息........................................................................................................................49
6.5.3 空间分配信息.........................................................................................................................49
6.5.4 数据库结构信息.....................................................................................................................50
第7章管理数据库存储.............................................................................................................................51
7.1 ORACLE数据库结构........................................................................................................................51
7.2 ORACLE块.......................................................................................................................................51
7.2.1 ORACLE块结构......................................................................................................................51
7.2.2 理解PCTFREE与PCTUSED..................................................................................................52
7.3 管理表存储区(数据段)...............................................................................................................54
7.3.1 创建表....................................................................................................................................54
7.3.2 STORAGE子句.......................................................................................................................55
7.4 管理表空间......................................................................................................................................55
7.4.1 创建表空间.............................................................................................................................55
7.4.2 表空间的区管理方式.............................................................................................................56
7.4.3 调整表空间的大小.................................................................................................................57
7.5 获取存储结构的信息.......................................................................................................................58
7.5.1 查询DBA_SEGMENTS.........................................................................................................59
7.5.2 查询DBA_EXTENTS.............................................................................................................59
7.5.3 查询DBA_FREE_SPACE......................................................................................................60
第8章备份和恢复....................................................................................................................................62
8.1 逻辑备份..........................................................................................................................................62
8.1.1 Export实用程序.......................................................................................................................62
8.1.2 Import实用程序.......................................................................................................................66
8.2 脱机备份..........................................................................................................................................71
8.3 联机备份..........................................................................................................................................72
8.3.1 归档模式和非归档模式.........................................................................................................72
8.3.2 联机数据库备份.....................................................................................................................73
8.4 数据库恢复......................................................................................................................................75
8.4.1 实例恢复................................................................................................................................75
8.4.2 介质恢复概述.........................................................................................................................75
8.4.3 无归档日志的数据库恢复.....................................................................................................76
8.4.4 有归档日志的数据库完全恢复.............................................................................................77
8.4.5 有归档日志的数据库不完全恢复........................................................................................79
s3c2440a(5-24).rar中文版
s3c2440a(5-24).rar中文版
三星嵌入式微处理机用户手册,中文版
s3c2440a中文datasheet- 第5章 存储控制器
s3c2440a中文datasheet- 第6章 Nandflash
s3c2440a中文datasheet- 第7章 时钟及电源
s3c2440a中文datasheet- 第8章 DMA
s3c2440a中文datasheet- 第10章 PWM及定时器
s3c2440a中文datasheet- 第11章 UART控制器
s3c2440a中文datasheet- 第14章 中断控制
s3c2440a中文datasheet- 第16章 ADC及触摸屏接口
s3c2440a中文datasheet- 第17章 RTC
s3c2440a中文datasheet- 第18章 看门狗
s3c2440a中文datasheet- 第19章 MMC/SD/SDIO 控制器
s3c2440a中文datasheet- 第20章 IIC接口
s3c2440a中文datasheet- 第21章 IIS接口
s3c2440a中文datasheet- 第22章 SPI接口
s3c2440a中文datasheet- 第24章 AC97接口
经典的C++数据结构课件.rar
经典的C++数据结构课件.rar
经典的C++数据结构课件.rar
经典的C++数据结构课件.rar
plsql完美教程(经典完整版)
plsql完美教程
详细讲述了plsql的用法,语法,基本语句等内容,是初学者非常实用的教程,可以参考参考!
Oracle公司内部数据库培训资料.rar
Oracle公司内部数据库培训资料.rar
一共20章,适合于各个层次的学习。
一分不可多得的好资料。
J2EE三大框架学习笔记
J2EE三大框架学习笔记
2-JSP+JDBC_真分页(基于Oracle数据库分页)笔记.pdf
4-Struts入门笔记.pdf
6-Struts标签-BEAN标签笔记.pdf
7-Struts标签 -LOGIC标签笔记.pdf
13-Hibernate入门(上)笔记.pdf
45-Struts+Hibernate完成分页笔记.pdf
.....
(prentice hall 2003) - programming oracle triggers and stored procedures, 3rd ed.rar
(prentice hall 2003) - programming oracle triggers and stored procedures, 3rd ed.rar
Oracle Press - 0072231300 - Effective Oracle Database 10g Security by Design - fly.rar
Oracle Press - 0072231300 - Effective Oracle Database 10g Security by Design - fly.rar
SQL复杂查询语句的使用.rar
复杂查询语句的使用.rar
复杂查询语句的使用.rar
复杂查询语句的使用.rar
dba_script.rar
dba_script.rar
dba_script.rar
dba_script.rar
Oracle触发器与存储过程高级编程-第3版itpub.rar
Oracle触发器与存储过程高级编程-第3版itpub.rar
ORACLE.10G入门与实践.rar
ORACLE.10G入门与实践.rar
初学者的绝好入门学习资料
清华大学计算中心ORACLE培训资料.rar
清华大学计算中心ORACLE培训资料.rar
清华大学计算中心ORACLE培训资料.rar
Thinking+in+java+第四版.rar
Thinking+in+java+第四版.rar
Thinking+in+java+第四版.rar
Thinking+in+java+第四版.rar
Struts中文手册.rar
Struts中文手册.rar
Struts中文手册.rar
Struts中文手册.rar
plsql语法帮助.rar
plsql语法帮助.rar
plsql语法帮助.rar
plsql语法帮助.rar
Oracle专家高级编程.rar
Oracle专家高级编程.rar
Oracle专家高级编程.rar
Oracle专家高级编程.rar
oracle学习.zip
oracle学习.zip
oracle学习.zip
oracle学习.zip
oracle学习.zip
Oracle教程和习题.rar
Oracle教程和习题.rar
Oracle教程和习题.rar
Oracle教程和习题.rar
Oracle dba数据库维护培训经典守则.rar
Oracle dba数据库维护培训经典守则.rar
Oracle dba数据库维护培训经典守则.rar
Oracle 11g 官方中文文档集萃
Oracle 11g 官方中文文档集萃
Oracle 11g 官方中文文档集萃
Oracle 9i&10g 编程艺术
Oracle 9i&10g 编程艺术
Oracle 9i&10g 编程艺术
jsp+java基础知识
jsp+java基础知识
jsp+java基础知识
jsp+java基础知识
jquety验证框架.rar
jquety验证框架.rar
jquety验证框架.rar
jquety验证框架.rar
jquety验证框架.rar
JavaScript圣经.rar
JavaScript圣经.rar
JavaScript圣经.rar
JavaScript圣经.rar
JavaScript圣经.rar