- Jul 29 Thu 2010 22:04
CREATE MATERIALIZED VIEW
- Jul 29 Thu 2010 22:03
ORA-01950: no privileges on tablespace XXX
- Jul 28 Wed 2010 20:04
Query Locked Objects from v$locked_object
- Jul 28 Wed 2010 20:04
Unix DB Instance Startup / Stop
- Jul 28 Wed 2010 20:02
[ID 744125.1] Connections Fail with ORA-12640 or ORA-21561 due to Windows Desktop heap sizing issue.
[ID 744125.1] Connections Fail with ORA-12640 or ORA-21561 due to Windows Desktop heap sizing issue.
- Jul 28 Wed 2010 19:59
Bug 4433936 Queries with FULL / LEFT OUTER join are involved with remote tables and these fail can fail with ORA-907 or ORA-933
Bug 4433936 Queries with FULL / LEFT OUTER join are involved with remote tables and these fail can fail with ORA-907 or ORA-933
- Jul 09 Fri 2010 17:51
C# function 執行失敗時, 重複執行
- Jun 27 Sun 2010 16:33
dbms_stats VS analyze
在 oracle 的 analyse 說明中清楚的說明, 於 8i 後建議不要用 analyse command 了, 而建議使用 dbms_stat. 以下是摘錄部份的說明.
Do not use the COMPUTE and ESTIMATE clauses of ANALYZE to collect optimizer statistics. These clauses are supported for backward compatibility. Instead, use the DBMS_STATS package, which lets you collect statistics in parallel, collect global statistics for partitioned objects, and fine tune your statistics collection in other ways. The cost-based optimizer, which depends upon statistics, will eventually use only statistics that have been collected by DBMS_STATS. See PL/SQL Packages and Types Reference for more information on the DBMS_STATS package.
- Jun 25 Fri 2010 18:40
Create/Alert Partition Table
一、 概念：
為強化資料庫大表格的管理，ORACLE推出了partition talbe。partition將表分離在若干不同的表空間上，用限制每個partition的空間，不只達到空間管理也增進了效能。更方便維護、備份、恢復、事務及查詢性能。
為強化資料庫大表格的管理，ORACLE推出了partition talbe。partition將表分離在若干不同的表空間上，用限制每個partition的空間，不只達到空間管理也增進了效能。更方便維護、備份、恢復、事務及查詢性能。
- Jun 08 Tue 2010 22:12
SQL 從另一個表格更新資料
Update data in one table with data from another table.
假設 History table 只有 Product_id, 現在新增 Product_Name column, 但資料再另一個 table 有, 要怎樣更新.
