建表 授权 和建立表空间以及导入用户对象

sqlplus  sys/sys as sysdba


create user otabase identified by otabase;

create user otazj identified by otazj;

grant dba to otabase;
<!--create session-->
grant create session to rjm;
<!--授权使用表空间-->
alter user rjm quota unlimited on 表空间;
<!--删除用户-->
drop user otabase cascade;
<!-- 授权建立sequence权限 -->
grant create sequence to rjm
<!--授权建立trigger权限 -- >
grant create trigger to rjm
grant dba to otazj;

commit;


imp otabase/otabase fromuser=otabase touser=otabase file=C:\otabase.dmp


imp otabase/otabase fromuser=otabase touser=otabase file=C:\otabase.dat

imp otazj/otazj fromuser=otazj touser=otazj file=C:\otazj.dmp





-------------------------------------------------------------------------
建立表空间
create tablespace OTASP logging datafile 'D:\oracle\product\10.2.0\oradata\orcl\OTASP.dbf' size 500m autoextend on next 100m maxsize 2000m extent management local;