1、安装Oracle时选择不创建数据库
2、安装完成后用“Database Configuration Assistant”创建数据库
3、创建数据库后用“Net Configuration Assistant”创建监听。
4、安装PLSQL后即可利用监听用sys和system用户登录。(要能用PLSQL登录同时需要保证“C:\java\Oracle9i\network\admin\tnsnames.ora”内的配置正常。)
5、接下来
--创建表空间
create tablespace PMS_tabSpa
logging datafile 'C:\java\Oracle9i\oradata\leo\PMS.dbf'
size 50m
autoextend on next 50m maxsize 20480m
extent management local;
--创造临时表空间
CREATE TEMPORARY TABLESPACE PMS_tabSpa_temp
TEMPFILE 'C:\java\Oracle9i\oradata\leo\PMS_temp.dbf' SIZE 50M ;
--创造用户
create user pms_user identified by pms_user
default tablespace PMS_tabSpa
temporary tablespace PMS_tabSpa_temp;
--给用户授权
grant connect,resource to pms_user;
--删除各项
drop user pms_user;
drop tablespace PMS_tabSpa_temp including contents and datafiles CASCADE CONSTRAINTS;
DROP TABLESPACE PMS_tabSpa including contents and datafiles CASCADE CONSTRAINTS;