create temporary tablespace user_temp(临时表空间名称) tempfile "homeoracleapporadata/GSMRuser_temp.dbf" size 50m aut
create temporary tablespace user_temp(临时表空间名称) tempfile "homeoracleapporadata/GSMRuser_temp.dbf" size 50m autoextend on next 50m maxsize 20480m extent management local; create tablespace user_data(数据表空间名称) logging datafile "homeoracleapporadataGSMRuser_data.dbf" size 50m autoextend on next 50m maxsize 20480m extent management local; create user username(用户名) identified by passWord(密码) default tablespace user_data temporary tablespace user_temp; grant connect,resource,dba to username;
--结束END--
本文标题: linux系统下创建oracle表空间和用户权限查询
本文链接: https://www.lsjlt.com/news/7104.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0