(源自網絡)EBS 11i ORA-01652问题 oracle 重建temp表空间的数据文件

詳細內容

分類: Oracle

發佈: 2009-05-11, 週一 11:31

作者 Super User

點擊數: 33194

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;