-- 表
SELECT * FROM ALL_TABLES WHERE OWNER = UPPER('system');
-- 索引
SELECT * FROM ALL_INDEXES WHERE OWNER = UPPER('system');
-- 视图
SELECT * FROM ALL_VIEWS WHERE OWNER = UPPER('system');
-- 过程
SELECT * FROM ALL_PROCEDURES WHERE OWNER = UPPER('system');
-- DB_LINK
SELECT * FROM ALL_DB_LINKS WHERE OWNER = UPPER('system');
-- 触发器
SELECT * FROM ALL_TRIGGERS WHERE OWNER = UPPER('system');
-- 任务
SELECT * FROM ALL_JOBS WHERE PRIV_USER = UPPER('system');
-- 序列
SELECT * FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = UPPER('system');
-- 目录
SELECT * FROM ALL_DIRECTORIES WHERE OWNER = UPPER('system');