fuzhaohui 发表于 2013-1-29 15:22:29

创建一个oracle用户sql语句

create temporary tablespace liferay6_temp
tempfile '/opt/oracle/oradata/liferay6_temp.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extentmanagement local;
create tablespace liferay6_data
logging
datafile '/opt/oracle/oradata/liferay6_data.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extentmanagement local;
create user liferay6 identified by liferay6
default tablespace liferay6_data
temporary tablespace liferay6_temp;
grant connect, resource, IMP_FULL_DATABASE, EXP_FULL_DATABASE to liferay6;
页: [1]
查看完整版本: 创建一个oracle用户sql语句