Oracle changes database character set encoding UTF8 first: connect sys/orcl as sysdba; www.2cto.com shutdown immediate; startup mount; alter session set SQL _trace = true; alter system enable restricted session; alter system set job_queue_processes = 0; alter system set aq_tm_processes = 0; alter database open; alter database character set internal_use utf8; alter session set SQL _trace = false; shutdown immediate; startup; ====================================== === Tablespace export: exp user name/password file = path + file name. dmpexp user name/password tables = (table 1 ,...... Table n) file = path + file name. dmp tablespace import: imp username/password file = path + file name. dmpimp username/password tables = (table 1 ,...... Table n) file = path + file name. dmp ================================ change the default format of the system date display: alter system set nls_date_format = 'yyyy-mm-dd hh24: mi: ss' scope = spfile; restart the computer to take effect.