SELECT OWNER,
OBJECT_NAME AS TABLE_NAME,
NAME AS COLUMN_NAME
FROM SYSCOLUMNS, (SELECT OBJECT_ID,
OWNER,
OBJECT_NAME
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = ‘TABLE’
AND OWNER NOT IN (‘SYSAUDITOR’,
‘SYS’,
‘SYSJOB’))
WHERE ID = OBJECT_ID
AND INFO2 = 1;