set feedback off;

set pagesize 0;

set heading off;

set verify off;

set linesize 200;

set trimspool on;

spool c:\数据库备份.bat;



select 'exp username/ffffff@yourdb 

TABLES='||table_name||' FILE='||table_name||'.dmp 

TRIGGERS=N' from user_tables;



spool off;

set feedback on;

set pagesize 9999;

set heading on;

set verify on;



exit