- create temporary tablespace user_temp
- tempfile 'C:\oracle\Administrator\product\11.2.0\dbhome_1\oradata\user_temp.dbf'
- size 50m
- autoextend on
- next 50m maxsize 20480m
- extent management local;
-
- create tablespace user_data
- logging
- datafile 'C:\oracle\Administrator\product\11.2.0\dbhome_1\oradata\user_data.dbf'
- size 50m
- autoextend on
- next 50m maxsize 20480m
- extent management local;
-
- create user demo identified by demopwd
- default tablespace user_data
- temporary tablespace user_temp;
-
- grant connect,resource,dba to demo;
posted @
2017-09-03 12:14
sun_0230
阅读(
108)
评论()
编辑
收藏
举报