1.生成确认表和表数据的SQL。
SELECT 'SELECT ''' || TABLE_NAME || ''' , COUNT(*) FROM XXXX.'||TABLE_NAME||' UNION' FROM DBA_TABLES WHERE OWNER = 'XXX' ORDER BY TABLE_NAME;
2.查看Sequence的SQL
SELECT SEQUENCE_NAME,LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER='XXXX' ORDER BY SEQUENCE_NAME;
3.在数据库中,执行下面SQL,生成删除数据库中Seq的SQL
SELECT 'DROP SEQUENCE NEW_XXX.' || SEQUENCE_NAME || ';' AS DROP_SEQUENCE_DDL
FROM ALL_SEQUENCES
WHERE SEQUENCE_OWNER = 'XXX';
4. 在数据库中,执行下面SQL,生成创建Seq的SQL
SELECT 'CREATE SEQUENCE NEW_XXX.' || SEQUENCE_NAME || ' MINVALUE '
|| MIN_VALUE || ' MAXVALUE ' || MAX_VALUE || ' INCREMENT BY 1 START WITH '
|| (LAST_NUMBER + CACHE_SIZE * 5) || ' CACHE 20 NOORDER NOCYCLE NOPARTITION ;' AS CREATE_SEQUENCE_DDL<
Oracle DB确认表数据,SEQ,INDEX等的SQL
最新推荐文章于 2022-10-31 10:02:32 发布
本文提供了Oracle数据库管理的SQL查询示例,包括获取表数据统计、查看序列状态、生成删除和创建序列的SQL、检查索引状态及重建无效索引的操作。
摘要由CSDN通过智能技术生成