Tuesday, September 18, 2012

Oracle Schema

Quick way to generate your own schema:
select a.table_name,b.column_name, a.owner,a.tablespace_name
from all_all_tables a
inner join all_tab_columns b
on a.table_name = b.table_name