Meta Data Manager
create public database link admindb connect to ... identified by ... using '...'; select table_name, comments, num_rows, blocks, avg_space from user_tables@admindb natural join user_tab_comments@admindb and col.table_name = '...' and rownum <= 10; select /*+ rule */ col.table_name, col.column_name, comments, data_type, data_length, data_precision, nullable from user_tab_columns@admindb col left outer join user_col_comments@admindb cmt on col.table_name = cmt.table_name and col.column_name = cmt.column_name and col.table_name = '...' and rownum <= 10 order by table_name, column_id;