Specific solutions for exporting all the tables of a user in the Oracle database

The following articles mainly describe how to export all tables of certain users in Oracle databases. In actual applications, many users may use Oracle, related customers generally want to export all tables of related users. This article provides such a method to help you solve this problem easily.

First, log on to the Oracle database with this user under sqlplus, And Then paste the following content into sqlplus:

 
 

  
  
set feedback off;   
  
  
set pagesize 0;   
  
  
set heading off;   
  
  
set verify off;   
  
  
set linesize 200;   
  
  
set trimspool on;  
 
 

Spool c: \ Oracle database backup. 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  
 
 

After the backup, find the c: \ Oracle database. bat file, edit the batch processing file, delete the first and last lines, save and run the batch processing file to export all tables under the user

Article by: http://database.csdn.net/page/18e91194-59f0-45a3-96a7-d79e955834f5