Oracle常用命令
- 创建表空间,RAC版本的 datafile路径必须要和下面一样(+Data),后面跟着表空间的文件名称
-
create tablespace EAP datafile '+Data\EAP.dbf' size 200m autoextend on next 100m maxsize unlimited extent management local;
create tablespace EAP DATAFILE '+DATA/eap01.dbf' SIZE 7167M autoextend on next 1000M maxsize unlimited; - 创建用户
-
create user EAP identified by password default tablespace EAP;
- 授权用户
-
GRANT connect,resource TO EAP;
- 修改用户密码
-
alter user EAP identified by Eapyy2021;