📄 dba_recompile_run.sql
字号:
/*************************************************************************
* The contents of this file are subject to the Compiere License. You may
* obtain a copy of the License at http://www.compiere.org/license.html
* Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
* express or implied. See the License for details. Code: Compiere ERP+CPM
* Copyright (C) 1999-2002 Jorg Janke, ComPiere, Inc. All Rights Reserved.
*************************************************************************
* $Id: DBA_Recompile_Run.sql,v 1.10 2003/01/29 05:29:23 jjanke Exp $
***
* Title: Run Recompile and list invalids and disabeled
* Description:
************************************************************************/
BEGIN
DBA_Recompile(NULL);
DBA_Cleanup();
END;
/
-- Check General Status
SELECT Object_Name AS Object_Invalid, Status
FROM User_Objects
WHERE Status <> 'VALID'
--AND Object_Type='VIEW'
/
-- Trigger Info
SELECT Trigger_Name AS Trigger_NotEnabled, Status
FROM User_Triggers
WHERE Status != 'ENABLED'
/
-- Constraint Info
SELECT Constraint_Name AS Constraint_Problem, Status, Validated
FROM User_Constraints
WHERE Status != 'ENABLED' OR Validated != 'VALIDATED'
/
SELECT *
FROM USER_ERRORS
/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -