oracle使用初体验

      大概10天前在网上下载了个oracle 10g，当时不知道oracle10g没有图形界面了，所以开始怎么建表，在哪建表都一头雾水。8i,9i都有图形界面工具 DBA STUDIO的。10g 的client也提供这个,需要另外装的。10g已经用website 方式了。

      另外，如果安装过程中全部选择默认的（没有自己配置一些高级选项），有人完成之后不知道用户名和密码，其实oracle自带了默认用户名和密码。

Oracle 10g 默认安装带来的用户名/密码
 

Username	Password	Description	See Also
CTXSYS	CTXSYS	The Oracle Text account	Oracle Text Reference
DBSNMP	DBSNMP	The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database	Oracle Enterprise Manager Grid Control Installation and Basic Configuration
LBACSYS	LBACSYS	The Oracle Label Security administrator account	Oracle Label Security Administrator's Guide
MDDATA	MDDATA	The schema used by Oracle Spatial for storing Geocoder and router data	Oracle Spatial User's Guide and Reference
MDSYS	MDSYS	The Oracle Spatial and Oracle interMedia Locator administrator account	Oracle Spatial User's Guide and Reference
DMSYS	DMSYS	The Oracle Data Mining account.	Oracle Data Mining Administrator's Guide Oracle Data Mining Concepts
OLAPSYS	MANAGER	The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite).	Oracle OLAP Application Developer's Guide
ORDPLUGINS	ORDPLUGINS	The Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema.	Oracle interMedia User's Guide
ORDSYS	ORDSYS	The Oracle interMedia administrator account	Oracle interMedia User's Guide
OUTLN	OUTLN	The account that supports plan stability. Plan stability enables you to maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.	Oracle Database Performance Tuning Guide
SI_INFORMTN_SCHEMA	SI_INFORMTN_SCHEMA	The account that stores the information views for the SQL/MM Still Image Standard	Oracle interMedia User's Guide
SYS	CHANGE_ON_INSTALL	The account used to perform database administration tasks	Oracle Database Administrator's Guide
SYSMAN	CHANGE_ON_INSTALL	The account used to perform Oracle Enterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.	Oracle Enterprise Manager Grid Control Installation and Basic Configuration
SYSTEM	MANAGER	Another account used to perform database administration tasks.	Oracle Database Administrator's Guide

 

我用的是SYSTEM/MANAGER进入的。

在Oracle Enterprise Manager中有个用户－>创建用户就可以创建自己的用户名和密码。

 

要创建表的话，先用SYSTEM/MANAGER进入ORACLE SQL*Plus，然后创建用户：

（1）create user userName identified by pwd;(userName是你的用户名，pwd是你的密码，下同)。

然后给你的用户授予权限：

（2）grant connect,resource to userName;

第三步是连接到你的用户：

（3）conn  userName/pwd;

第四步创建表：

（4）create table test(a number,name varchar(20));

 

另外了解到有个Oracle 的第三方辅助工具（图形界面的）：pl/sql developer，感觉还不错。

 

搞了3－4个小时，终于对Oracle 10g建表的过程有所了解了，至少可以应用在简单的开发当中了，呵呵。