Oracle创建用户和表空间

Oracle基本操作

1. sql命令

   1.创建表空间：
   CREATE Tablespace yqfk logging datafile '/APP/ADMINISTRATOR/ORADATA/ORCL/yqfk.dbf'
   size 100m
   autoextend on next 32m
   maxsize 2048m extent
   management local;
   
   2.创建临时表空间：
   CREATE Temporary tablespace yqfk_temp tempfile '/APP/ADMINISTRATOR/ORADATA/ORCL/yqfk_temp.dbf'
   size 100m
   autoextend on next 32m
   maxsize 2048m extent
   management local;
   
   3.创建用户
   create user yqfk_gxkx identified by "yqfk_gxkx_2020"
   default tablespace yqfk
   temporary tablespace yqfk_temp profile DEFAULT;
   
   4.授权
   grant connect to yqfk_gxkx;
   grant create indextype to yqfk_gxkx;
   grant create job to yqfk_gxkx;
   grant create materialized view to yqfk_gxkx;
   grant create public synonym to yqfk_gxkx;
   grant create sequence to yqfk_gxkx;
   grant create session to yqfk_gxkx;
   grant create table to yqfk_gxkx;
   grant create view to yqfk_gxkx;
   grant unlimited tablespace to yqfk_gxkx;
   grant create any procedure to yqfk_gxkx;
   grant execute any procedure to yqfk_gxkx;
   grant create any trigger to yqfk_gxkx;
   grant create any type to yqfk_gxkx;
   alter user yqfk_gxkx quota unlimited on yqfk;