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