摘要：
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... 阅读全文