摘要：select * from dual@dblink ORA-00600: 内部错误代码, 参数: [2252], [2934], [296062546], [], [], [], [], [] 数据库用startup force 方式启动出现上面的错误提示，DBLINK不能用 正常启动数据库就可以了 shutdown immediate startup 阅读全文

摘要：oracle 提供了wrap工具加密代码语法如下：wrap iname=input_file oname=output_fileSELECT ascii('D') FROM dual;SELECT ascii(' ') FROM dual;-- create as a text file c: emp\unwrapped.sql CREATE OR REPLACE FUNCTION unwrapped (namein VARCHAR2)RETURN NUMBER IS c PLS_INTEGER := 0; j PLS_INTEGER; l PLS_INTEGE 阅读全文

摘要：MERGE <hint> INTO <table_name>USING <table_view_or_query>ON (<condition>)WHEN MATCHED THEN <update_clause>DELETE <where_clause>WHEN NOT MATCHED THEN <insert_clause>[LOG ERRORS <log_errors_clause> <rej... 阅读全文

摘要：计算schema在原库的空间大小select SEGMENT_TYPE,sum(a.bytes)/1024/1024/1024 from USER_EXTENTS a group by A.SEGMENT_TYPE;建立表空间或扩张新库的表空间CREATE TABLESPACE orcl_index_o1 DATAFILE SIZE 10240M AUTOEXTEND OFF, SIZE 10240M AUTOEXTEND OFFLOGGINGEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEME... 阅读全文

摘要：$ORACLE_HOME\RDBMS\ADMIN\UTLRP.SQL 阅读全文

摘要：MSTR报表某个报表执行极慢，查看报表SQL，自动加了个distinct,而该报表数据量极大， 打开vldb属性，将之前的【使用默认集成值】勾掉，选择【无distinct,无group by】 By default, MicroStrategy considers that the attributes defined are the Primary Key of the respective... 阅读全文

摘要：Force ... Forces The Creation Of A View Even When The View Will Be Invalid. NoForce Is The Default 强制建立一个view,即使创建后该view失效 SQL> select * from xyz; select * from xyz ORA-00942: 表或视图不存在 SQL> SQL> CREAT... 阅读全文

摘要：建立一个日志表CREATE TABLE ddl_log (operation VARCHAR2(30),obj_owner VARCHAR2(30),object_name VARCHAR2(30),sql_text VARCHAR2(64),attempt_by VARCHAR2(30),attempt_dt DATE);在truncate 操作前触发，写日志到ddl_log表CREATE OR REPLACE TRIGGER bf_truncateBEFORE TRUNCATEON SCHEMADECLAREoper ddl_log.operation%TYPE; BE... 阅读全文

摘要：在用oracle10g impdp功能的时候提示 ORA-39001: invalid argument valueORA-01775: looping chain of synonyms 用下面的SQL，查出对象已经不存在的同义词，然后删除掉该同义词 SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = '&owner' AND SYNON... 阅读全文

摘要：drop index inx_01 ORA-02429: cannot drop index used for enforcement of unique/primary keyalter table emp drop constraint inx_01 ;drop index inx_01; 阅读全文

摘要：该图来自:http://kamranagayev.com/2009/08/10/oracle-10gr2-architecture-learn-it-by-heart/ 阅读全文

摘要：操作符：UNION、描述：组合每个查询返回的所有行，并删除重复行SELECT*FROM emp WHERE deptno=10 UNION SELECT*FROM emp WHERE sal>500操作符：UNION ALL、描述：组合每个查询返回的所有行，并包括重复行SELECT*FROM emp WHERE deptno=10 UNION ALL SELECT*FROM emp WHERE s... 阅读全文

摘要： 阅读全文