Go to Windows Oracle Export table structure

Analyze how to export all tables for a user under Oracle It's possible that many customers who use Oracle will encounter a situation where they want to export all the tables of a user, and this article provides a way to help you solve this problem easily.
First, under Sqlplus, log in to the Oracle database, and then paste the following into the Sqlplus:
Set feedback off; 　　　　Set pagesize 0; 　　　　Set heading off; 　　　　Set verify off; 　　　　Set Linesize 200; Set Trimspool on;

Spool c:/database backup. bat;

Select ' Exp username/[email protected]//username/password/database name 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

When you are finished, locate the c:/database backup. bat file, edit the batch file, delete the first and last lines, and then run the batch file after saving to export all the tables under that user.

Go to Windows Oracle Export table structure