PLSQL数据库创建表空间.txt

创建表空间
表空间：
CREATE SMALLFILE TABLESPACE LISCNPC2 DATAFILE 'D:\oracle\bus' SIZE 10M
AUTOEXTEND ON NEXT 10M MAXSIZE 120M
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
用户语句：
create user liscnpc2 identified by liscnpc2 default tablespace liscnpc2;
grant dba to liscnpc2;
grant connect,resource to liscnpc2;
grant select any table to liscnpc2;

删除用户
drop user liscnpc cascade

导入：
cmd/
imp cms/cms file=cms.dmp fromuser=cms