新建Oracle用户和表空间

来源:互联网 发布:yii2 开源 cms 编辑:程序博客网 时间:2024/05/16 05:42
create user huzmz identified by huzmz default tablespace huzmz temporary tablespace TEMP;grant dba to huzmz;select * from dba_data_files;create tablespace huzmzloggingdatafile 'E:\DATEBASE\ORACLE11G\ORADATA\ORCL\HUZMZ.DBF'size 50mautoextend onnext 50m maxsize 10240mextent management local;

0 0