ORCALE 安装、配置后，SQL*Plus操作初步？
mengfq2003 | 16 三月, 2005 10:09
- 系统环境：
1、操作系统：Windows 2000
2、数据库： Oracle 8i R2 (
3、安装路径：C:ORACLE
- 说明：
·
· 默认安装完Oracle后，初学者应该了解的一些SQL语句
· 1、连接
· SQL*Plus system/manager
·
· 2、显示当前连接用户
· SQL> show user
·
· 3、查看系统拥有哪些用户
· SQL> select * from all_users;
·
· 4、新建用户并授权
· SQL> create user a identified by a;（默认建在SYSTEM表空间下）
· SQL> grant connect,resource to a;
·
· 5、连接到新用户
· SQL> conn a/a
·
· 6、查询当前用户下所有对象
· SQL> select * from tab;
·
· 7、建立第一个表
· SQL> create table a(a number);
·
· 8、查询表结构
· SQL> desc a
·
· 9、插入新记录
· SQL> insert into a values(1);
·
· 10、查询记录
· SQL> select * from a;
·
· 11、更改记录
· SQL> update a set a=2;
·
· 12、删除记录
· SQL> delete from a;
·
· 13、回滚
· SQL> roll;
· SQL> rollback;
·
· 14、提交
SQL> commit;
Oracle
- 系统环境：
1、操作系统：Windows 2000
2、数据库： Oracle 8i R2 (
3、安装路径：C:ORACLE
- 解释：
·
· Oracle 8i R2 (8.1.6 ) for NT 企业版默认安装完毕后会在所在盘符创建以下三个目录
·
· admin： 记录Oracle实例的配置、运行日志等文件，每个实例一个目录
· Ora81： Oracle系统文件
· oradata：Oracle实例运行所需的所有具体文件（数据文件、日志文件、控制文件），每个实例一个目录
·
·
·
· 一般来讲，Oracle文件分以下几个类型：
·
· 数据文件： 真实数据· 重做日志文件： 联机日志、归档日志· 控制文件： 包含物理文件到数据字典中的逻辑表空间之间的映射· 初始化参数文件： 控制内存· 警告和追踪日志文件：· 备份文件：·
·
·
· C:Oracleadminoradbpfileinit.ora --初始化参数文件
· C:OracleadminoradbbdumporadbALRT.LOG --警告日志文件
· C:OracleadminoradbudumpORA00960.TRC
·
· C:OracleoradataoradbSYSTEM01.DBF --表空间数据文件
· C:OracleoradataoradbUSERS01.DBF
· C:OracleoradataoradbINDX01.DBF
· C:OracleoradataoradbRBS01.DBF
· C:OracleoradataoradbTEMP01.DBF
初始分类 :: 评论 (6) :: 静态链接网址 :: 引用 (0)
最新回复
Onojmj Onojmjebu
| 29/06/2008, 04:47
Whnfqu Whnfqupia
| 29/06/2008, 05:30
from the www.onlinemedscentral.com phentermine cod market. Medeva from the phentermine cod market. Medeva from the [url=www.onlinemedscentral.com]phentermine cod[/url] market. Medeva from the [URL]www.onlinemedscentral.com[/URL] phentermine cod market. Medeva Pharmaceuticals sells www.bestmedsplace.com tramadol ultram the name Pharmaceuticals sells tramadol ultram the name Pharmaceuticals sells [url=www.bestmedsplace.com]tramadol ultram[/url] the name Pharmaceuticals sells [URL]www.bestmedsplace.com[/URL] tramadol ultram the name brand of www.bargainmedsplace.com generic phentermine phentermine called brand of generic phentermine phentermine called brand of [url=www.bargainmedsplace.com]generic phentermine[/url] phentermine called brand of [URL]www.bargainmedsplace.com[/URL] generic phentermine phentermine called Ionamin
珥嚓铎耱忄 眍恹
vioneglergo
| 25/10/2009, 05:00
珥嚓铎耱忄 圄痤滂蜞
slaniataX
| 25/10/2009, 09:25
- 泥
free amature drunk sex videos
Actixtuch
| 28/11/2009, 00:02
free viewer submitted sex videos clip homemade sex video free real girl sex movies xxx amateur bar free asian lesbians porn videos free sex related videos free abused porn movies free porn videos boobs free sex movies bang brothers free porn movies trailors movies neighbors make porn free amateur contributions free amateur porn posts free strap on porn movies free clips amateur hidden sex
dor2.txt;10;15
cqweaas
| 22/01/2010, 10:55
dor2.txt;10;15
新闻聚合
搜索
博客日历
| « | 三月 2010 | » | ||||
|---|---|---|---|---|---|---|
| 一 | 二 | 三 | 四 | 五 | 六 | 日 |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 | ||||
However, in www.nationalwebmeds.com phentermine diet 1997 after However, in phentermine diet 1997 after However, in [url=www.nationalwebmeds.com]phentermine diet[/url] 1997 after However, in [URL]www.nationalwebmeds.com[/URL] phentermine diet 1997 after 24 cases www.myinternetmedications.com phentermine no prescription of heart 24 cases phentermine no prescription of heart 24 cases [url=www.myinternetmedications.com]phentermine no prescription[/url] of heart 24 cases [URL]www.myinternetmedications.com[/URL] phentermine no prescription of heart valve disease www.discountmedsplace.com buy phentermine online in Fen-Phen valve disease buy phentermine online in Fen-Phen valve disease [url=www.discountmedsplace.com]buy phentermine online[/url] in Fen-Phen valve disease [URL]www.discountmedsplace.com[/URL] buy phentermine online in Fen-Phen users, fenfluramine www.onlinemedstoday.com buying viagra and dexfenfluramine users, fenfluramine buying viagra and dexfenfluramine users, fenfluramine [url=www.onlinemedstoday.com]buying viagra[/url] and dexfenfluramine users, fenfluramine [URL]www.onlinemedstoday.com[/URL] buying viagra and dexfenfluramine were voluntarily www.medspointstore.com cheapest viagra taken off were voluntarily cheapest viagra taken off were voluntarily [url=www.medspointstore.com]cheapest viagra[/url] taken off were voluntarily [URL]www.medspointstore.com[/URL] cheapest viagra taken off