■通过Oracle DB_Link复制数据
delete from @
insert into @ select * from .
,,需替换为具体名称
■Oracle数据库显示乱码问题
Database character set
SQL> conn / as sysdba;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter system set aq_tm_processes=0;
SQL> alter database open;
SQL> alter database character set internal_use AL32UTF8;(ZHS16GBK)
SQL> shutdown immediate;
SQL> startup;
http://www.soidc.net/articles/1213781343264/20091019/1215945666391_1.html
Client character set (修改注册表)
HKEY_LOCAL_MACHINE\SOFTEARE\ORACLE\Key_OraDb10g_home1
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
■SQL Loader使用
http://www.orafaq.com/wiki/SQL%2ALoader_FAQ
Contents
1 What is SQL*Loader and what is it used for?
2 How does one use the SQL*Loader utility?
3 How does one load MS-Excel data into Oracle?
4 Is there a SQL*Unloader to download data to a flat file?
5 Can one load variable and fixed length data records?
6 Can one skip header records while loading?
7 Can one modify data as the database gets loaded?
8 Can one load data from multiple files/ into multiple tables at once?
9 Can one selectively load only the records that one needs?
10 Can one skip certain columns while loading data?
11 How does one load multi-line records?
12 How does one load records with multi-line fields?
13 How can one get SQL*Loader to COMMIT only at the end of the load file?
14 Can one improve the performance of SQL*Loader?
15 What is the difference between the conventional and direct path loader?
16 How does one use SQL*Loader to load images, sound clips and documents?
17 How does one load EBCDIC data?
http://www.cnblogs.com/flish/archive/2010/05/31/1748221.html
Oracle FAQ
http://www.orafaq.com/wiki/Category:Frequently_Asked_Questions