![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle DBA
x0ne
这个作者很懒,什么都没留下…
展开
-
Oracle FAQs and Tips
在已建好的table上添加primary key1.建立索引create index test_idx on test(id);2.添加約束alter table testadd constraint test_pk primary key (id)using index test_idx; 在SQLPLUS中登陸時出現以下錯誤ERROR:ORA-12638: Credential retrie原创 2004-07-07 13:46:00 · 1198 阅读 · 1 评论 -
如何在SQL*PLUS中使用Autotrace?
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql SQL> create public synonym plan_table for plan_table;SQL> grant all on plan_table to public;SQL> conn sysSQL> @$ORACLE_HOME/sqlplus/admin/plustrce SQL> gran原创 2004-06-28 21:35:00 · 901 阅读 · 0 评论 -
动态SQL和PL/SQL的EXECUTE IMMEDIATE选项
EXECUTE IMMEDIATE代替了以前Oracle8i中DBMS_SQL package包.它解析并马上执行动态的SQL语句或非运行时创建的PL/SQL块.动态创建和执行SQL语句性能超前,EXECUTE IMMEDIATE的目标在于减小企业费用并获得较高的性能,较之以前它相当容易编码.尽管DBMS_SQL仍然可用,但是推荐使用EXECUTE IMMEDIATE,因为它获的收益原创 2004-07-15 12:25:00 · 2293 阅读 · 0 评论 -
OracleDBA最常碰到的10个Oracle错误
This document contains information about errors frequently encountered bynew DBAs, along with appropriate actions to be taken in each circumstance.+==+Summary:10 COMMON RDBMS ERRORS+=+1) ORA-1547原创 2004-09-02 10:57:00 · 1753 阅读 · 0 评论 -
使用LogMiner
1.创建DBMS_LOGMNR包SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql2.创建相关数据字典SQL>@$ORACLE_HOME/rdbms/admin/dbmslmd.sql3.修改初始化参数UTL_FILE_DIR,指定分析数据的存放处SQL>alter system set UTL_FILE_DIR=/opt/oracle/logminer scop原创 2004-09-23 14:10:00 · 1023 阅读 · 0 评论