Backup _ use word to write and export multi-Table statements and word statements
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/42104599
Tutorial objective: to use word to compile and use exp tool to export the writing format for multiple tables
Lab environment:
Operating System: WINDOWS2008 64bit
Database: ORACLE 11G R2 64bit
Software used: word 2010, excel 2010, UltraEdit, PL/SQL Develoer 10
Lab leader:
HYL users have 268 tables, which involve different business layers and have separate photo and video tables. Therefore, during logical backup, to back up a large table separately.
Start the experiment:
The PL/SQL Develoer software is used to copy all table names of HYL users, and the excel software is used to classify them. Copy the table name with a comma from the excel file to the UltraEdit Editor (this removes the line break) and paste it into the word file. This article takes the scott business table under the HYL user as an example. Use word to sort out the table name format:
Then, use word to remove all "line breaks" to make all tables conform to the writing format of the table name in the exp script, as shown below:
1. Click CTRL + H to bring up the "search and replace" menu;
2. Click the "special format" button as follows:
3. Select a paragraph mark, for example:
4. Leave the replacement target blank, as shown in the following figure:
5. Obtain the table name separation format as follows:
Supplement: if there is a space item, you can use the same method to replace "comma space" with "comma" style.
Now, we can use the UltraEdit text editor to write backup scripts for different business tables, such:
------------------------------------
-- Scott business table backup Test
------------------------------------
Exp HYL/HYL @ hyldb buffer = 128000 feedback = 10000 tables = (bonus, dept, emp, salgrade) file = D: \ back \ scott \ data20141212.dmp log = D: \ back \ scott \ data20141212Exp. log
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/42104599