oracle中创建表空间

 

CREATE TABLESPACE pp_DATA
       DATAFILE 'D:\oracle\product\10.2.0\oradata\bbb\pp_DATA01.DBF' SIZE 100M
       AUTOEXTEND ON NEXT 10M MAXSIZE 4096M
       EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

      
  

CREATE TEMPORARY TABLESPACE pp_TEMP
       TEMPFILE 'D:\oracle\product\10.2.0\oradata\bbb\pp_TEMP01.DBF' SIZE 100M
       AUTOEXTEND ON NEXT  5M MAXSIZE  1024M
       EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;

--Create User
create user pp identified by pp217
       default   tablespace pp_DATA
       temporary tablespace pp_TEMP;

grant connect, resource,dba to pp;

其中'D:\oracle\product\10.2.0\oradata\是oracle的安装路径。