Oracle 创建表空间 

 1 /*第1步：创建临时表空间 */
 2 create temporary tablespace user_temp 
 3 tempfile 'D:\DataBase\Oracle\app\Administrator\product\11.2.0\dbhome_1\oradata\user_temp.dbf' 
 4 size 50m 
 5 autoextend on 
 6 next 50m maxsize 20480m 
 7 extent management local; 
 8 
 9 /*第2步：创建数据表空间 */ 
10 create tablespace python 
11 logging 
12 datafile 'D:\DataBase\Oracle\app\Administrator\product\11.2.0\dbhome_1\oradata\python.dbf'
13 size 50m 
14 autoextend on 
15 next 50m maxsize 20480m 
16 extent management local;
17 
18 /*第3步：创建用户并指定表空间 */
19 create user python identified by python 
20 default tablespace python 
21 temporary tablespace user_temp; 
22 
23 /*第4步：给用户授予权限 */ 
24 grant connect,resource,dba to python;

 

posted @ 2020-05-04 10:10  潇湘梦白  阅读(99)  评论(0)    收藏  举报