無.................................................題

l_xiaofeng 2004-11-03 01:18:10

...全文

168 23 打赏收藏转发到动态举报

写回复

23 条回复

切换为时间正序

请发表友善的回复…

发表回复

Dlwxn 2004-11-03

打赏
举报

回复

trainbox 2004-11-03

打赏
举报

回复

lj

Borland_Delphi 2004-11-03

打赏
举报

回复

什么啊？

darkliu 2004-11-03

打赏
举报

回复

有钱人真多

firephoenix007 2004-11-03

打赏
举报

回复

???!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!>>>>>>>>>>>>>>>>????????????????????????????????????????????????????????????????????????????

xufenglong 2004-11-03

打赏
举报

回复

?? ??
!!

firephoenix007 2004-11-03

打赏
举报

回复

不会失恋了吧？唉！

YOHOYOHO 2004-11-03

打赏
举报

回复

刺激

立志做一个佳娃~ 2004-11-03

打赏
举报

回复

★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★

　　　　　　　★★★★★CSDN论坛秀主力站点★★★★★
http://blog.csdn.net/ghyghost

★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★

★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★

　　　　　　　★★★★★CSDN论坛秀主力站点★★★★★
http://blog.csdn.net/ghyghost

★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★

hottey 2004-11-03

打赏
举报

回复

UP

hongqi162 2004-11-03

打赏
举报

回复

jf

hongqi162 2004-11-03

打赏
举报

回复

jf

hongqi162 2004-11-03

打赏
举报

回复

jf

yinzhiw 2004-11-03

打赏
举报

回复

接分

yinzhiw 2004-11-03

打赏
举报

回复

接分

yinzhiw 2004-11-03

打赏
举报

回复

接分

DebugXP 2004-11-03

打赏
举报

回复

有分就接

fim 2004-11-03

打赏
举报

回复

怎么了

firetoucher 2004-11-03

打赏
举报

回复

呀，真的没有了，呵呵。怎么回事·_·

ma369 2004-11-03

打赏
举报

回复

干吗哪？

加载更多回复（3）

Aspose.Cells.dll Aspose.Cells.chm

可用jquery的插件：zclip解决js复制在不同浏览器的支持度。

第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

最新的window7 64位oracle客户端上传限制60mb故使用7z压缩，方便各位下载使用感谢各位支持

Consolas是除了Monaco（下载地址： http://download.csdn.net/detail/jiaoxiaogu/4317959）以外我最喜欢的编程字体。特别是在windows的命令行（CMD）中使用（是的，你没看错，cmd也可以自定义字体）。 Monaco在cmd中略显粗笨，Consolas则相对字符间距都很合适。完美识别0，o；1，l，i。 -------------- 虽然Consolas为windows自带字体，但是在Linux却很难找到。特此备份。 -------------- 无图无真相 https://github.com/woainvzu/Colorful_cmd_Marslo/blob/master/Images/mycmd.png?raw=true

830

社区成员

53,572

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章