创建临时表空间
create temporary tablespace TEMP3 TEMPFILE '/ora_temp/temp03.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
修改用户product的默认临时表空间
alter user product temporary tablespace temp3
创建临时表空间
create temporary tablespace TEMP3 TEMPFILE '/ora_temp/temp03.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
修改用户product的默认临时表空间
alter user product temporary tablespace temp3