Oracle基本操作
- 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;