oracle 创建用户,表空间,索引.

采用oracle创建用户并授予dba权限

 注意点：

1.如果在PL/SQL 等工具里打开的话，直接修改下面的代码中[斜体加粗部分]执行

2.确保路径存在，比如【D:\oracle\oradata\Oracle9i\】也就是你要保存文件的路径存在

1）创建用户： create user wmlt identified by wmlt;

 

2）授予dba权限  grant connect,resource,dba to wmlt;

创建表空间.

create tablespace tclusterdata
logging  
datafile '/oracle/oradata/tcluster/EAIUAT/datafile/tclusterdata.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

创建索引
DROP TABLESPACE TCLUSTERINDX INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE TCLUSTERINDX DATAFILE 
  '/oracle/oradata/tcluster/EAIUAT/datafile/tclusterindx.dbf' SIZE 400M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

/*第3步：创建用户并指定表空间  */

create user username identified by password  

default tablespace user_data  

temporary tablespace user_temp;