oralce创建数据库表空间 跟 用户,及赋权
oralce创建数据库表空间 和 用户,及赋权
CREATE TABLESPACE SFGL
DATAFILE 'D:\Oracle\oradata\ORCL\SFGL_DATA.ORA' SIZE 300M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
DEFAULT STORAGE ( INITIAL 50K NEXT 5000k
PCTINCREASE 0
MAXEXTENTS UNLIMITED );
CREATE
TEMPORARY TABLESPACE SFGL_TEMP TEMPFILE
'D:\Oracle\oradata\ORCL\SFGL_TEMP.ORA' SIZE 50M EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1M;
CREATE USER SFGL IDENTIFIED BY SFGL
DEFAULT TABLESPACE SFGL
TEMPORARY TABLESPACE SFGL_TEMP;
grant connect to SFGL;
grant dba to SFGL;