資料庫 & ERP

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

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;

(源自網絡)Oracle10g DBA 速成課程

Oracle10g DBA 速成課程之一:安裝Oracle軟體並構建資料庫
http://www.jason-tang.com/files/it/database/oracle/oracledba01.pdf

Oracle10g DBA 速成課程之二:Oracle Enterprise Manager 入門
http://www.jason-tang.com/files/it/database/oracle/oracledba02.pdf

Oracle10g DBA 速成課程之三:配置網路環境
http://www.jason-tang.com/files/it/database/oracle/oracledba03.pdf

Oracle10g DBA 速成課程之四:管理 oracle 常式
http://www.jason-tang.com/files/it/database/oracle/oracledba04.pdf

Oracle10g DBA 速成課程之五:管理資料庫存儲結構
http://www.jason-tang.com/files/it/database/oracle/oracledba05.pdf

Oracle10g DBA 速成課程之六:管理用戶和安全性
http://www.jason-tang.com/files/it/database/oracle/oracledba06.pdf

Oracle10g DBA 速成課程之七:管理模式物件
http://www.jason-tang.com/files/it/database/oracle/oracledba07.pdf

Oracle10g DBA 速成課程之八:執行備份和恢復
http://www.jason-tang.com/files/it/database/oracle/oracledba08.pdf

Oracle10g DBA 速成課程之九:監控和調整資料庫
http://www.jason-tang.com/files/it/database/oracle/oracledba09.pdf