创建表空间
表空间：
 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;