--查询当前版本信息
sqlplus /nolog
--查询tablespaces内容
select * from dba_tablespaces;
--检索所有的表用户信息
select * from dba_user;
--
select * from dba_users where username='rpg1';
select * from dba_users where username='rpg2';
--删除用户信息
drop user rpg1 cascade;
drop user rpg2 cascade;
--删除表空间
drop tablespace chss;
--以用户 sys/sys 登录到pl/sql
--创建表空间
create tablespace chss
nologging
datafile 'D:/ORADB/CHSS_DB.dbf'
size 10240m
autoextend on
next 32m maxsize 20480m
extent management local;
--创建两个用户并分配dba权限
create user rpg1 identified by rpg1;
grant dba to CHSS;
create user rpg2 identified by rpg2;
grant dba to NETHIS;
--导入数据库给当前用户rpg1
imp rpg1/rpg1 file='F:/oracle_db/netchss_oracle_20100709.dmp' full=y statistics=none