In SQL Server there is a nice feature which lets you generate an SQL script from any database using the SQL Enterprise Manager. Oracle can do the same using sqlplusw:

  • Start sqlplusw and login to your Oracle TSN
  • spool c:dump.log
  • set lines 7000;
  • set trimspool on;
  • select * from user_tab_columns;
  • select * from user_views;
  • spool off