Backup _ use Word to write and export multiple table statements

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog: http://blog.csdn.net/huangyanlong/article/details/42104599

Experiment Objective: Write format when using the exp tool to export user multiple tables with word

Lab Environment:

Operating system:WINDOWS2008 64bit

Database:ORACLE 11G R2 64bit

Using software:word,Excel,UltraEdit, PL/SQL Develoer

Experimental preamble:

HYL users, have 268 table, and the table involves different business aspects, and there is a separate photo, video class large table, so when doing a logical backup, you want to use a large table to separate backup way.

Start the experiment:

Using PL/SQL develoer software, copy out all the table names under the HYL user and use Excel software to classify them. Then copy the table name with a comma from Excel into the UltraEdit Editor (which removes paragraph breaks), and then paste it into word . This article takes the Scott Business table under the HYL user as an example. Use Word to format the table name, which is the format of the table name after the last paste to word :

Then, use Word to remove all "line breaks" so that all tables conform to the writing format of the table name in the exp script, as follows:

1, click ctrl+h, bring up the "Find and replace" menu;

2, click the "Special format" button, as follows:

3, select the paragraph mark, such as:

4, the replacement target is selected as empty, such as:

5. Get the desired table name delimited format as follows:

Add: If there is a space entry, you can use the same method to replace "comma" with the "comma" style.

At this point, we can use the UltraEdit text editor to write backup scripts for different business tables, such as scripts:

------------------------------------

--scott Business Table Backup test

------------------------------------

Exp Hyl/[email protected] buffer=128000 feedback=10000 tables= (Bonus, dept, EMP, Salgrade) file=d:\back\scott\ Data20141212.dmp Log=d:\back\scott\data20141212exp.log

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/42104599

Backup _ use Word to write and export multiple table statements