|
(源自網絡)EBS 11i ORA-01652问题 oracle 重建temp表空间的数据文件 |
|
|
|
|
作者 Administrator
|
|
2009/05/11, Monday |
|
Login as root #su - oraerpp $sqlplus SQL*Plus: Release 9.2.0.3.0 - Production on Mon May 11 11:25:23 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name:system Enter password:manager Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production SQL> SQL>create temporary tablespace TEMP2 TEMPFILE '/oracle/erpp/erppdata/temp02.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; SQL>alter database default temporary tablespace temp2; SQL>drop tablespace temp including contents and datafiles; SQL>create temporary tablespace TEMP TEMPFILE '/oracle/erpp/erppdata/temp01.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; SQL>alter database default temporary tablespace temp; SQL>drop tablespace temp2 including contents and datafiles; SQL>alter user apps temporary tablespace temp;
|