--创建表空间
CREATE TABLESPACE CSS_SPDATA
LOGGING
DATAFILE 'D:\app\fc\oradata\orcl\Ju.DBF'
SIZE 100M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--在表空间中建立用户
CREATE USER fuchao
IDENTIFIED BY fuchao
DEFAULT TABLESPACE "CSS_SPDATA" ACCOUNT UNLOCK;
--给用户进行授权
GRANT CONNECT TO fuchao WITH ADMIN OPTION;
GRANT DBA TO fuchao WITH ADMIN OPTION;
Oracle建立表空间、用户、授权
最新推荐文章于 2023-06-25 16:21:10 发布