免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

選擇主備

/studio/SdStudioProject/selectMainPlUser.jspx

磨課保存

/studio/SdStudioProject/save.jspx

oracle 創(chuàng)建表空間

create tablespace dzzwpt datafile 'D:\oracle\product\10.2.0\oradata\orcl\dzzwpt.dbf' size 100m autoextend on next 50m;

/*分為四步 */

/*第1步：創(chuàng)建臨時表空間  */

D:\oracle\product\10.2.0\oradata\orcl\dzzwpt.dbf

create temporary tablespace user_temp  

tempfile 'D:\oracle\product\10.2.0\oradata\orcl\user_temp.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

/*第2步：創(chuàng)建數(shù)據(jù)表空間  */

create tablespace user_data  

logging  

datafile 'D:\oracle\product\10.2.0\oradata\orcl\user_data.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

/*第3步：創(chuàng)建用戶并指定表空間  */

create user username identified by password  

default tablespace user_data  

temporary tablespace user_temp;  

 

/*第4步：給用戶授予權(quán)限  */

grant connect,resource,dba to username;

該語句用于創(chuàng)建臨時表空間

create temporary tablespace user_temp1 tempfile 'D:\oracle\product\10.2.0\oradata\orcl\user_temp1.dbf' size 50m autoextend on  next 50m maxsize 20480m  extent management local;

用于創(chuàng)建數(shù)據(jù)表空間

create tablespace user_data1 logging datafile 'D:\oracle\product\10.2.0\oradata\orcl\user_data1.dbf' size 50m autoextend on next 50m maxsize 20480m  extent management local;

創(chuàng)建用戶并指定表空間

create user username identified by password  1121 tablespace user_data1 temporary tablespace user_temp1;  

給用戶授權(quán)

grant connect,resource,dba to username;

create temporary tablespace user_temp  

tempfile 'D:\oracle\product\10.2.0\oradata\orcl\user_temp1.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  ;

 create tablespace dzzwpt datafile 'D:\oracle\product\10.2.0\oradata\orcl\dzzwpt.dbf' size 100m autoextend on next 50m;

1

create temporary tablespace user_temp1 tempfile 'D:\oracle\product\10.2.0\oradata\orcl\user_temp1.dbf' size 50m autoextend on  next 50m maxsize 20480m  extent management local;

create tablespace user_data1 logging datafile 'D:\oracle\product\10.2.0\oradata\orcl\mis_base.dbf' size 50m autoextend on next 50m maxsize 20480m  extent management local;

create user mis_base identified by 123456  default tablespace mis_base temporary tablespace user_temp1; 

grant connect,resource,dba to mis_base;