创建oracle数据库表空间角色用户的sql语句.docx

《创建oracle数据库表空间角色用户的sql语句.docx》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、创建oracle数据库表空间，角色，用户的sql语句1.创建角色CREATEROLE"QIUDINGROLE"NOTIDENTIFIED;GRANT"CONNECT"TO"QIUDINGROLE";GRANT"DBA"TO"QIUDINGROLE";GRANT"RESOURCE"TO"QIUDINGROLE";2.创建表空间createtablespacesafetempdatafile'D:oracleproduct10.1.0oradatalocalpowersafetemp01.dbf'size32mautoextendonnext32mmaxsizeunlimit

2、edloggingextentmanagementlocalsegmentspacemanagementauto;CREATESMALLFILETABLESPACE"EXAM"DATAFILE'D:Softoracleproduct10.2.0oradataqiudingEXAM'SIZE100MAUTOEXTENDONNEXT1MMAXSIZEUNLIMITEDLOGGINGEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO;BEGINDBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NUL

3、L,NULL,NULL,1,1,NULL,5,'EXAM');END;CREATESMALLFILETEMPORARYTABLESPACE"EXAM_TEMP"TEMPFILE'D:Softoracleproduct10.2.0oradataqiudingEXAM_temp'SIZE100MAUTOEXTENDONNEXT1MMAXSIZEUNLIMITEDEXTENTMANAGEMENTLOCALUNIFORMSIZE1M;BEGINDBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,

4、'EXAM_TEMP');END; 3.创建用户createuserEXAM                                                                        identifiedby"PASSWORD123" defaulttablespace"EXAM" temporarytablespace"EXAM_TEMP" profileDEFAULT ACCOUNTUNLOCK;grantQIUDINGROLEtoEXAM;grantunlimitedtablespacetoEXAM;4.创建备份目录并且付相应权限create

5、directorydump_diras'D:Softoraclebackup';grantread,writeondirectorydump_dirtoEXAM;