Oracle Database CHECK NUMBER For tables/views/triggers/function/procedure
2023-09-27 14:25:21 时间
SELECT DISTINCT(TABLESPACE_NAME) FROM ALL_TABLES;
SELECT COUNT(*) FROM ALL_TABLES WHERE TABLESPACE_NAME='xx' ORDER BY TABLE_NAME ASC; --COUNT 384 SELECT COUNT(*) FROM ALL_VIEWS WHERE OWNER='xx'; --COUNT 169 select COUNT(*) from USER_TRIGGERS; --COUNT 134 SELECT OBJECT_NAME,OBJECT_TYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE') AND OWNER='xx'; --COUNT 8
相关文章
- What is the difference between Shrink Database and File?
- 安装Oracle Database 11g 找不到文件“WFMLRSVCApp.ear” .
- Oracle Database 12c Release 2安装详解
- 第八十六章 SQL命令 USE DATABASE
- SQLiteDatabaseLockedException: database is locked (code 5): , while compiling: PRAGMA journal_mode
- Oracle Database 12C 学习之多租户(连载一)
- Oracle Database 12C 学习之多租户(连载四)
- HOW TO BUILD AND RUN ORACLE DATABASE 19C ON DOCKER
- 已发布:Oracle Database 23c 免费版 — 开发人员版!
- EXTRACT FILES AND IMAGES FROM A SHAREPOINT CONTENT DATABASE
- Csharp run sql script create database
- Oracle Database 21c 主要架构
- Graph database_neo4j 底层存储结构分析(4)
- Graph database_neo4j 底层存储结构分析(2)
- oracle 10g standby database 实时应用 redo 数据
- Activiti启报错: Cannot create PoolableConnectionFactory (Could not create connection to database server
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'