oracle创建表空间

创建表空间
表空间：
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 from user=cms


exp liscnpc/liscnpc@ file=d:\sss.dmp


imp liscnpc/liscnpc file=d:\zhuyong.dmp full=y








crm用户语句：


CREATE SMALLFILE TABLESPACE crm DATAFILE 'D:\oracle\bus1' SIZE 10M
AUTOEXTEND ON NEXT 10M MAXSIZE 120M
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;


create user crm identified by crm default tablespace crm;
grant dba to crm;
grant connect,resource to crm;
grant select any table to crm;