dcdh

echo SET PAGESIZE 0&echo SET LONG 5000&echo SET ECHO OFF&echo SET FEEDBACK OFF&echo SET HEADING OFF&echo SET LINESIZE 32767&echo SPOOL C:\path\to\export\all_tables_ddl.sql&echo @echo off&echo for /f "tokens=*" %%a in ('sqlplus -s username/password@database @ - ^<^<EOF
echo SET PAGESIZE 0
echo SET LONG 5000
echo SET ECHO OFF
echo SET FEEDBACK OFF
echo SET HEADING OFF
echo SET LINESIZE 32767
echo DECLARE
echo   CURSOR tables_cur IS
echo     SELECT table_name