{"id":612,"date":"2013-01-15T12:36:25","date_gmt":"2013-01-15T04:36:25","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=612"},"modified":"2013-01-25T17:54:57","modified_gmt":"2013-01-25T09:54:57","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e9%ab%98%e7%89%88%e6%9c%ac%e5%88%b0%e4%bd%8e%e7%89%88%e6%9c%ac%e8%b7%a8%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%bd%8d%e6%95%b0%e8%b7%a8%e7%94%a8%e6%88%b7%e7%9a%84%e6%95%b0","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=612","title":{"rendered":"\u6570\u636e\u5e93\u9ad8\u7248\u672c\u5230\u4f4e\u7248\u672c\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\u8de8\u7528\u6237\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa"},"content":{"rendered":"<p>\u6570\u636e\u5e93\u9ad8\u7248\u672c\u5230\u4f4e\u7248\u672c\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\u8de8\u7528\u6237\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa<br \/>\n\t\u5728\u8fd9\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u4eec\u5c06\u8ba8\u8bbaexp\/imp\u4ee5\u53caexpdp\/impdp\u4ece\u9ad8\u7248\u672c\u5230\u4f4e\u7248\u672c\uff0c\u4ece64\u4f4d\u64cd\u4f5c\u7cfb\u7edf\u523032\u4f4d\u64cd\u4f5c\u7cfb\u7edf\u7684\u6570\u636e\u8fc1\u79fb\u3002\u5f53\u7136\u8fd9\u4e2a\u4e5f\u662f\u4e4b\u524d\u6211\u7684\u5927\u5b66\u540c\u5b66\u6709\u4e00\u6b21\u95ee\u6211\uff0c\u5f53\u65f6\u6709\u70b9\u5fd9\u53ea\u544a\u8bc9\u4e86\u5176\u601d\u8def\u800c\u672a\u5b9e\u9645\u64cd\u4f5c\uff0c\u4e5f\u4e0d\u77e5\u9053\u5176\u540e\u6765\u662f\u5426\u641e\u5b9a\uff0c\u73b0\u5728\u5c31\u6a21\u62df\u4e00\u4e0b\u3002\u6a21\u62df\u573a\u666f\uff1a\u5c06\u6e90\u5e93\uff08\u9ad8\u7248\u672c64\u4f4d\uff09\u7684\u4e00\u4e2a\u7528\u6237\u79fb\u52a8\u5230\u76ee\u6807\u5e93\uff08\u4f4e\u7248\u672c32\u4f4d\uff09\u7684\u53e6\u4e00\u4e2a\u7528\u6237\u4e0b\u3002\u800c\u81f3\u4e8e\u4ece\u4f4e\u7248\u672c\u5230\u9ad8\u7248\u672c\u7684\u8fc1\u79fb\uff0c\u7531\u4e8eoracle\u7684\u5411\u524d\u517c\u5bb9\u6027\uff0c\u4e5f\u662f\u5f88\u65b9\u4fbf\u7684\uff0c\u5728\u8fd9\u91cc\u5c31\u4e0d\u518d\u8ba8\u8bba\u4e86\u3002<\/p>\n<p>\t\u5173\u4e8e\u6570\u636e\u6cf5\u7684\u4f7f\u7528\uff0c\u53ef\u4ee5\u89c1\u6211\u4e4b\u524d\u7684\u535a\u6587\uff1a<br \/>\n\tData Pump\u57fa\u672c\u672f\u8bed\u548c\u6982\u5ff5\uff1ahttp:\/\/www.yallonking.com\/database\/582.html<br \/>\n\tData Pump Export\/Impdp\u64cd\u4f5c\u5b9e\u4f8b\uff1ahttp:\/\/www.yallonking.com\/database\/591.html<br \/>\n\uff08\u4e00\uff09\u73af\u5883\uff1a<br \/>\n\u6e90\u5e93\uff1a64\u4f4d\u768411.2.0.3.4\u7684\u6570\u636e\u5e93\u7248\u672c\uff0c\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@rhl6 ~]# su - oracle\r\n[oracle@rhl6 ~]$ which sqlplus\r\n\/u01\/app\/oracle\/product\/11.2.0\/db_1\/bin\/sqlplus\r\n[oracle@rhl6 ~]$ file \/u01\/app\/oracle\/product\/11.2.0\/db_1\/bin\/oracle\r\n\/u01\/app\/oracle\/product\/11.2.0\/db_1\/bin\/oracle: setuid setgid ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU\/Linux 2.6.18, not stripped\r\n[oracle@rhl6 ~]$ $ORACLE_HOME\/OPatch\/opatch lsinventory -bugs_fixed | egrep -i &#039;PSU|DATABASE PATCH SET UPDATE&#039;\r\n14275605   14275605  Tue Dec 25 00:45:11 CST 2012   DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPU\r\n13923374   13923374  Tue Dec 25 00:44:15 CST 2012   DATABASE PATCH SET UPDATE 11.2.0.3.3 (INCLUDES \r\n13696216   13696216  Tue Dec 25 00:42:27 CST 2012   DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES \r\n13343438   13343438  Tue Dec 25 00:39:18 CST 2012   DATABASE PATCH SET UPDATE 11.2.0.3.1\r\n<\/pre>\n<p>\u76ee\u6807\u5e93\uff1a32\u4f4d\u768410.2.0.1.0\u7684\u6570\u636e\u5e93\u7248\u672c\uff0c\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[root@ora10gr2 ~]# su - oracle\r\n[oracle@ora10gr2 ~]$ which oracle\r\n\/u01\/app\/oracle\/product\/10.2.0\/db_1\/bin\/oracle\r\n[oracle@ora10gr2 ~]$ file \/u01\/app\/oracle\/product\/10.2.0\/db_1\/bin\/oracle\r\n\/u01\/app\/oracle\/product\/10.2.0\/db_1\/bin\/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU\/Linux 2.6.9, dynamically linked (uses shared libs), for GNU\/Linux 2.6.9, not stripped\r\n[oracle@ora10gr2 ~]$ $ORACLE_HOME\/OPatch\/opatch lsinventory -bugs_fixed | egrep -i &#039;PSU|DATABASE PATCH SET UPDATE&#039;\r\n[oracle@ora10gr2 ~]$ sqlplus &quot;\/as sysdba&quot;\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 14 08:05:20 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area  608174080 bytes\r\nFixed Size                  1220844 bytes\r\nVariable Size             197136148 bytes\r\nDatabase Buffers          406847488 bytes\r\nRedo Buffers                2969600 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL&gt; select * from v$version;\r\n\r\nBANNER\r\n----------------------------------------------------------------\r\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod\r\nPL\/SQL Release 10.2.0.1.0 - Production\r\nCORE    10.2.0.1.0      Production\r\nTNS for Linux: Version 10.2.0.1.0 - Production\r\nNLSRTL Version 10.2.0.1.0 - Production\r\n<\/pre>\n<p>\uff08\u4e8c\uff09\u6a21\u62df\u573a\u666f\uff1a\u5c06\u6e90\u5e93\uff08\u9ad8\u7248\u672c64\u4f4d\uff09\u7684\u4e00\u4e2a\u7528\u6237\u79fb\u52a8\u5230\u76ee\u6807\u5e93\uff08\u4f4e\u7248\u672c32\u4f4d\uff09\u7684\u53e6\u4e00\u4e2a\u7528\u6237\u4e0b<br \/>\n2.1 \u9996\u5148\u4f7f\u7528expdp\/impdp\u5de5\u5177<br \/>\n2.1.1 \u9996\u5148\u4f7f\u7528expdp\u5bfc\u51fa\u7528\u6237ora11g<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select * from ora11g.test;\r\n\r\n        ID NAME                 INSERTTIME\r\n---------- -------------------- -------------------\r\n         1 yallonking           2013\/01\/15 10:56:30\r\n\r\n[oracle@rhl6 ~]$ expdp system\/oracle directory=dump_files1 dumpfile=schema_exp.dump schemas=ora11g logfile=schema_exp.log\r\n\r\nExport: Release 11.2.0.3.0 - Production on Tue Jan 15 10:59:24 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nStarting &quot;SYSTEM&quot;.&quot;SYS_EXPORT_SCHEMA_01&quot;:  system\/******** directory=dump_files1 dumpfile=schema_exp.dump schemas=ora11g logfile=schema_exp.log \r\nEstimate in progress using BLOCKS method...\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\nTotal estimation using BLOCKS method: 64 KB\r\nProcessing object type SCHEMA_EXPORT\/USER\r\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\r\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\r\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\r\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\r\n. . exported &quot;ORA11G&quot;.&quot;TEST&quot;                             5.820 KB       1 rows\r\nMaster table &quot;SYSTEM&quot;.&quot;SYS_EXPORT_SCHEMA_01&quot; successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\r\n  \/u01\/app\/oracle\/dump_dir1\/schema_exp.dump\r\nJob &quot;SYSTEM&quot;.&quot;SYS_EXPORT_SCHEMA_01&quot; successfully completed at 11:01:14\r\n<\/pre>\n<p>2.1.2 ftp dump\u5230\u76ee\u6807\u7aef\u540e\u8fdb\u884c\u5bfc\u5165\u64cd\u4f5c<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ~]$ cd \/u01\/app\/oracle\/dump_dir1\/\r\n[oracle@ora10gr2 dump_dir1]$ ls -l\r\ntotal 180\r\n-rw-r--r-- 1 oracle oinstall 180224 Jan 14 19:31 schema_exp.dump\r\n<\/pre>\n<p>2.1.2 \u5e38\u89c4\u65b9\u5f0f\u5bfc\u5165<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ~]$ impdp system\/oracle dumpfile=dump_files1:schema_exp.dump REMAP_SCHEMA=ora11g:test logfile=schema_imp.log\r\n\r\nImport: Release 10.2.0.1.0 - Production on Monday, 14 January, 2013 19:33:41\r\n\r\nCopyright (c) 2003, 2005, Oracle.  All rights reserved.\r\n\r\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\nORA-39001: invalid argument value\r\nORA-39000: bad dump file specification\r\nORA-39142: incompatible version number 3.1 in dump file &quot;\/u01\/app\/oracle\/dump_dir1\/schema_exp.dump&quot;\r\n<\/pre>\n<p>\u6ce8\u610f\uff1a\u6b64\u65f6\u4f1a\u62a5\u7248\u672c\u9519\u8bef\u76f8\u5173\u4fe1\u606f<br \/>\n2.1.3 \u73b0\u5728\u4f7f\u7528\u5e26\u53c2\u6570version\u7684expdp\u5728\u9ad8\u7248\u672c\u4e0a\u5bfc\u51fa\u9ad8\u7248\u672c\u7684\u5e93<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@rhl6 dump_dir1]$ expdp system\/oracle directory=dump_files1 dumpfile=ora11g_exp.dump schemas=ora11g version=10.2.0.1.0\r\n\r\nExport: Release 11.2.0.3.0 - Production on Tue Jan 15 11:56:55 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nStarting &quot;SYSTEM&quot;.&quot;SYS_EXPORT_SCHEMA_01&quot;:  system\/******** directory=dump_files1 dumpfile=ora11g_exp.dump schemas=ora11g version=10.2.0.1.0 \r\nEstimate in progress using BLOCKS method...\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\nTotal estimation using BLOCKS method: 64 KB\r\nProcessing object type SCHEMA_EXPORT\/USER\r\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\r\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\r\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\r\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\r\n. . exported &quot;ORA11G&quot;.&quot;TEST&quot;                             5.632 KB       1 rows\r\nMaster table &quot;SYSTEM&quot;.&quot;SYS_EXPORT_SCHEMA_01&quot; successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\r\n  \/u01\/app\/oracle\/dump_dir1\/ora11g_exp.dump\r\nJob &quot;SYSTEM&quot;.&quot;SYS_EXPORT_SCHEMA_01&quot; successfully completed at 11:58:30\r\n<\/pre>\n<p>\u7531\u4e8eData Pump\u662f\u5728\u670d\u52a1\u7aef\u6267\u884c\u7684\uff0c\u6240\u4ee5\u5176\u4ea7\u751f\u7684dmp\u6587\u4ef6\u5c06\u4f1a\u4fdd\u5b58\u5728\u670d\u52a1\u7aef\u3002<br \/>\n2.1.4 \u5c06dump\u6587\u4ef6ftp\u5230\u76ee\u6807\u7aef\u540e\uff0c\u518d\u6b63\u5e38\u5bfc\u5165\u5230\u5176\u4ed6schema<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 dump_dir1]$ impdp system\/oracle dumpfile=dump_files1:ora11g_exp.dump REMAP_SCHEMA=ora11g:test logfile=ora11g_imp.log\r\n\r\nImport: Release 10.2.0.1.0 - Production on Monday, 14 January, 2013 20:04:03\r\n\r\nCopyright (c) 2003, 2005, Oracle.  All rights reserved.\r\n\r\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\nMaster table &quot;SYSTEM&quot;.&quot;SYS_IMPORT_FULL_01&quot; successfully loaded\/unloaded\r\nStarting &quot;SYSTEM&quot;.&quot;SYS_IMPORT_FULL_01&quot;:  system\/******** dumpfile=dump_files1:ora11g_exp.dump REMAP_SCHEMA=ora11g:test logfile=ora11g_imp.log \r\nProcessing object type SCHEMA_EXPORT\/USER\r\nORA-31684: Object type USER:&quot;TEST&quot; already exists\r\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\r\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\r\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\r\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\n. . imported &quot;TEST&quot;.&quot;TEST&quot;                               5.632 KB       1 rows\r\nJob &quot;SYSTEM&quot;.&quot;SYS_IMPORT_FULL_01&quot; completed with 1 error(s) at 20:04:20\r\n\r\n\r\nSQL&gt; select name from v$database;\r\n\r\nNAME\r\n---------\r\nORA10GR2\r\n\r\nSQL&gt; select * from test.test;                                                                                            \r\n\r\n        ID NAME                 INSERTTIME\r\n---------- -------------------- -------------------\r\n         1 yallonking           2013\/01\/15 10:56:30\r\n\r\n<\/pre>\n<p>2.2 \u4f7f\u7528exp\/imp\u5de5\u5177<br \/>\n\u4f7f\u7528exp\/imp\u60f3\u5b9e\u73b0\u4ee5\u4e0a\u8fc7\u7a0b\uff0c\u9700\u8981\u7528\u4f4e\u7248\u672c\u7684exp\/imp\u5de5\u5177\u53bb\u5904\u7406\u9ad8\u7248\u672c\u7684exp\u4ee5\u53ca\u4f4e\u7248\u672c\u7684imp\u3002<br \/>\n2.2.1 \u9996\u5148\u4f7f\u7528\u4f4e\u7248\u672c\u7684exp\u53bb\u5bfc\u51fa\u9ad8\u7248\u672c\u7684\u5e93\u7684schema<br \/>\n\u5220\u9664\u76ee\u6807\u5e93\u7684\u8868<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; conn test\/test\r\nConnected.\r\nSQL&gt; drop table test;\r\n\r\nTable dropped.\r\n<\/pre>\n<p>\u7136\u540e\u6267\u884c\u5bfc\u51fa<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 ~]$ tnsping ora11gr2x64\r\n\r\nTNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-JAN-2013 20:13:04\r\n\r\nCopyright (c) 1997, 2005, Oracle.  All rights reserved.\r\n\r\nUsed parameter files:\r\n\r\n\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.214)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11gr2)))\r\nOK (20 msec)\r\n[oracle@ora10gr2 ~]$ exp userid=system\/oracle@ora11gr2x64 file=&#039;\/u01\/app\/oracle\/dump_dir1\/ora11g_exp_2.dmp&#039; DIRECT=y ROWS=y OWNER=ora11g LOG=&#039;\/u01\/app\/oracle\/dump_dir1\/ora11g_exp_2.log&#039;\r\n\r\nExport: Release 10.2.0.1.0 - Production on Mon Jan 14 20:21:20 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nExport done in US7ASCII character set and AL16UTF16 NCHAR character set\r\nserver uses ZHS16GBK character set (possible charset conversion)\r\n\r\nAbout to export specified users ...\r\n. exporting pre-schema procedural objects and actions\r\n. exporting foreign function library names for user ORA11G \r\n. exporting PUBLIC type synonyms\r\n. exporting private type synonyms\r\n. exporting object type definitions for user ORA11G \r\nAbout to export ORA11G&#039;s objects ...\r\n. exporting database links\r\n. exporting sequence numbers\r\n. exporting cluster definitions\r\n. about to export ORA11G&#039;s tables via Direct Path ...\r\n. . exporting table                           TEST          1 rows exported\r\n. exporting synonyms\r\n. exporting views\r\n. exporting stored procedures\r\n. exporting operators\r\n. exporting referential integrity constraints\r\n. exporting triggers\r\n. exporting indextypes\r\n. exporting bitmap, functional and extensible indexes\r\n. exporting posttables actions\r\n. exporting materialized views\r\n. exporting snapshot logs\r\n. exporting job queues\r\n. exporting refresh groups and children\r\n. exporting dimensions\r\n. exporting post-schema procedural objects and actions\r\n. exporting statistics\r\nExport terminated successfully without warnings.\r\n[oracle@ora10gr2 dump_dir1]$ ls -l\r\ntotal 188\r\n-rw-r--r-- 1 oracle oinstall  16384 Jan 14 20:21 ora11g_exp_2.dmp\r\n-rw-r--r-- 1 oracle oinstall   1369 Jan 14 20:21 ora11g_exp_2.log\r\n-rw-r--r-- 1 oracle oinstall 167936 Jan 14 20:03 ora11g_exp.dump\r\n<\/pre>\n<p>\u7531\u4e8eexp\/imp\u662f\u5ba2\u6237\u64cd\u4f5c\uff0c\u6240\u4ee5\u5bfc\u51fa\u7684\u6587\u4ef6\u4e5f\u5c31\u653e\u5728\u5ba2\u6237\u7aef\u4e86\uff0c\u54b1\u4eec\u4e5f\u4e0d\u7528\u518dftp\u4e86<\/p>\n<p>2.2.2 \u5bfc\u5165\u5230\u4f4e\u7248\u672c\u5e93\u7684\u5176\u4ed6\u7528\u6237\u4e0b<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ora10gr2 dump_dir1]$ imp userid=system\/oracle file=&#039;\/u01\/app\/oracle\/dump_dir1\/ora11g_exp_2.dmp&#039; FROMUSER=ora11g TOUSER=test LOG=&#039;\/u01\/app\/oracle\/dump_dir1\/ora11g_imp_2.log&#039;\r\n\r\nImport: Release 10.2.0.1.0 - Production on Mon Jan 14 20:26:17 2013\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\n\r\nExport file created by EXPORT:V10.02.01 via direct path\r\nimport done in US7ASCII character set and AL16UTF16 NCHAR character set\r\nimport server uses WE8ISO8859P1 character set (possible charset conversion)\r\n. importing ORA11G&#039;s objects into TEST\r\n. . importing table                         &quot;TEST&quot;          1 rows imported\r\nImport terminated successfully without warnings.\r\n\r\nSQL&gt; select * from test.test;\r\n\r\n        ID NAME                 INSERTTIME\r\n---------- -------------------- -------------------\r\n         1 yallonking           2013\/01\/15 10:56:30\t\t\r\n<\/pre>\n<p>\u81f3\u6b64\uff0c\u5168\u90e8ok\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6570\u636e\u5e93\u9ad8\u7248\u672c\u5230\u4f4e\u7248\u672c\u8de8\u64cd\u4f5c\u7cfb\u7edf\u4f4d\u6570\u8de8\u7528\u6237\u7684\u6570\u636e\u5bfc\u5165\u5bfc\u51fa \u5728\u8fd9\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u4eec\u5c06\u8ba8\u8bbaexp\/imp\u4ee5\u53caexpdp\/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,32],"tags":[52,50,51,49,65,64,66,67,69,68,70],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/612"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=612"}],"version-history":[{"count":7,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/612\/revisions"}],"predecessor-version":[{"id":614,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/612\/revisions\/614"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=612"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}