当前位置:Gxlcms > 数据库问题 > Oracle创建数据库

Oracle创建数据库

时间:2021-07-01 10:21:17 帮助过:27人阅读

create tablespace PDB_VIDEOS_PACE datafile ‘F:/ORACLE/app/oradata/orcl/PDB_VIDEOS_PACE.dbf‘ size 200M autoextend on next 5M maxsize 3000M;

创建用户并赋值默认表空间create user jsby identified by jsby default tablespace PDB_VIDEOS_PACE;

赋予用户对应权限:grant update any table to jsby;   grant select any table to jsby;   grant create any view to jsby;   grant create any sequence to jsby;   grant create any table to jsby;   grant delete any table to jsby;

          grant insert any table to jsby;   grant connect to jsby;

 

Oracle创建数据库

标签:font   video   sequence   maxsize   efault   def   file   select   tab   

人气教程排行