create tablespace ptsys datafile 'D:\app\Administrator\oradata\orcl\ptsys.dbf' size 200M;
CREATE USER ptsys IDENTIFIED BY ptsys DEFAULT TABLESPACE ptsys TEMPORARY TABLESPACE temp PROFILE DEFAULT;
grant dba,connect,resource,imp_full_database,exp_full_database to ptsys;
alter user ptsys quota unlimited on ptsys;
ALTER DATABASE DATAFILE 'D:\app\Administrator\oradata\orcl\ptsys.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
创建表空间,用户,分配权限
最新推荐文章于 2019-05-21 17:37:42 发布