Oracle19c创建用户及表空间


1.创建用户及表空间 https://blog.csdn.net/baidu_38735622/article/details/107447417

CREATE TABLESPACE MOM_LLJ_DEV LOGGING DATAFILE 'D:\DB\Oracle\MOM_LLJ_DEV.dbf' 
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL;


create temporary tablespace MOM_LLJ_DEV_TEMP tempfile 'D:\DB\Oracle\MOM_LLJ_DEV_TEMP.dbf'
size 100m autoextend on next 32m maxsize 500m extent management local;



CREATE USER u_mom_llj_dev_one IDENTIFIED BY MaoBao2022 DEFAULT TABLESPACE MOM_LLJ_DEV TEMPORARY TABLESPACE MOM_LLJ_DEV_TEMP;


grant connect,resource,dba to u_mom_llj_dev;
grant create session to u_mom_llj_dev;

2.Oracle——ORA-65096: 公用用户名或角色名无效

https://www.cnblogs.com/heymonkey/p/12551006.html
https://blog.csdn.net/weixin_36296063/article/details/116508093

相关