資料庫 & ERP
(源自網絡)EBS 11i ORA-01652问题 oracle 重建temp表空间的数据文件
- 詳細內容
- 分類: Oracle
- 發佈: 2009-05-11, 週一 11:31
- 作者 Super User
- 點擊數: 31534
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;