查找不是主键的字段在哪些表里存在：

select owner, table_name
from dba_tab_columns
where lower(column_name)='firstname';

查找主键的字段在哪些表里存在：

select owner, table_name
from dba_tab_columns
where column_name='firstname';