全部博文
-
编辑 删除
Oracle PL/SQL创建表空间
1.创建临时表空间 CREATE TEMPORARY TABLESPACE itim_temp TEMPFILE 'E:oracleproduct10.2.0oradatamyorclitim_temp01.dbf' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; 2.创建用户表空间 CREATE TABLESPACE itim_data LOGGING DATAFILE 'E:oracleproduct10.2.0oradatamyorclITIM_DATA01.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; 3.创建用户并指定表空间 CREATE USER itsm IDENTIFIED BY itsm DEFAULT TABLESPACE itim_DATA TEMPORARY TABLESPACE iti
