mysql zhs16gbk_谨慎修改Oracle数据库字符集（UTF8<->ZHS16GBK）

1 SQL> select *from dba_directories;2

3 OWNER DIRECTORY_NAME4 ------------------------------ ------------------------------

5 DIRECTORY_PATH6 --------------------------------------------------------------------------------

7 SYS ORACLE_OCM_CONFIG_DIR8 /u01/app/oracle/product/11.2.0/db_1/ccr/state9

10 SYS DATA_PUMP_DIR11 /u01/app/oracle/admin/ogg/dpdump/

12

13 SYS XMLDIR14 /u01/app/oracle/product/11.2.0/db_1/rdbms/xml15

16

17 SQL> create directory datapump as '/u01/';18

19 Directory created.20

21 SQL> grant read,writeon directory datapump to zlm;22 grant read,writeon directory datapump to zlm23 *

24 ERROR at line 1:25 ORA-01749: you may not GRANT/REVOKE privileges to/from yourself26

27

28 SQL> conn /as sysdba29 Connected.30 SQL> grant read,writeon directory datapump to zlm;31

32 Grant succeeded.33

34 SQL>exit35 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -64bit Production36 With the Partitioning option37 [oracle@ogg ~]$ expdp zlm/zlm directory=datapump dumpfile=zlm_datapump_`date +%Y%m%d`.dmp logfile=zlm_datapump_`date +%Y%m%d`.log schemas=zlm38

39 Export: Release 11.2.0.1.0 - Production on Wed Jul 11 12:51:06 2018

40

41 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.42

43 Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -64bit Production44 With the Partitioning option45 Starting "ZLM"."SYS_EXPORT_SCHEMA_01": zlm/******** directory=datapump dumpfile=zlm_datapump_20180711.dmp logfile=zlm_datapump_20180711.log schemas=zlm46 Estimate in progress using BLOCKS method...47 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA48 Total estimation using BLOCKS method: 64 KB49 Processing object type SCHEMA_EXPORT/USER50 Processing object type SCHEMA_EXPORT/SYSTEM_GRANT51 Processing object type SCHEMA_EXPORT/ROLE_GRANT52 Processing object type SCHEMA_EXPORT/DEFAULT_ROLE53 Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA54 Processing object type SCHEMA_EXPORT/TABLE/TABLE55 Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX56 Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT57 Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS58 Processing object type SCHEMA_EXPORT/TABLE/COMMENT59 . . exported "ZLM"."TEST_CHARSET" 5.414 KB 1 rows60 Master table "ZLM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded61 ******************************************************************************62 Dump file set for ZLM.SYS_EXPORT_SCHEMA_01 is:63 /u01/zlm_datapump_20180711.dmp64 Job "ZLM"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:51:3165

66 [oracle@ogg ~]$ cd /u0167 [oracle@ogg u01]$ ls -l68 total 20069 drwxrwxr-x 4 oracle oinstall 4096 May 19 2017 app70 drwxrwxr-x 3 oracle oinstall 4096 Mar 29 15:40 arch71 drwxrwxr-x 14 oracle oinstall 4096 Feb 7 17:01 ogg72 -rw-r----- 1 oracle oinstall 184320 Jul 11 12:51 zlm_datapump_20180711.dmp73 -rw-r--r-- 1 oracle oinstall 1500 Jul 11 12:51 zlm_datapump_20180711.log74 [oracle@ogg u01]$