加载中…
个人资料
冰山一角
冰山一角
微博
  • 博客等级：
  • 博客积分：0
  • 博客访问：6,779
  • 关注人气：44
  • 获赠金笔：0支
  • 赠出金笔：0支
  • 荣誉徽章：
正文 字体大小：大 中 小

alter database character set INTERNAL_CONVERT

(2009-01-09 16:05:51)
标签：

it

 分类： Oracle DBA

alter database character set INTERNAL_CONVERT UTF8
Updating character set in controlfile to UTF8
 SYS.SNAP$ (REL_QUERY) - CLOB representation altered
 SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
 SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered
 XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
 ODM.ODM_PMML_DTD (DTD) - CLOB representation altered
 OE.WAREHOUSES (SYS_NC00003$) - CLOB representation altered
 PM.ONLINE_MEDIA (SYS_NC00042$) - CLOB representation altered
 PM.ONLINE_MEDIA (SYS_NC00062$) - CLOB representation altered
 PM.ONLINE_MEDIA (PRODUCT_TEXT) - CLOB representation altered
 PM.ONLINE_MEDIA (SYS_NC00080$) - CLOB representation altered
 PM.PRINT_MEDIA (AD_SOURCETEXT) - CLOB representation altered
 PM.PRINT_MEDIA (AD_FINALTEXT) - CLOB representation altered
Completed: alter database character set INTERNAL_CONVERT UTF8
Fri Nov 28 10:28:00 2008
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CON

----------------------------zhuan-----------------------------------

Oracle非公开的命令:

 

http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />alter database character set INTERNAL_CONVERT/ INTERNAL_USE ZHS16GBK

 

这个命令是当你选择了使用典型方式创建了种子数据库以后，Oracle会根据你选择的字符集设置，把当前种子数据库的字符集更改为期望字符
集，这就是这条命令的作用.

在使用这个命令时，Oracle会跳过所有子集及超集的检查，在任意字符集之间进行强制转换，所以，使用这个命令时你必须十分小心，你必须
清楚这一操作会带来的风险.
我们之前讲过的内容仍然有效，你可以使用csscan扫描整个数据库，如果在转换的字符集之间确认没有严重的数据损坏，或者你可以使用有效
的方式更改，你就可以使用这种方式进行转换.
我们来看一下具体的操作过程及Oracle的内部操作:

 

http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> shutdown immediate
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Database closed.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Database dismounted.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />ORACLE instance shut down.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> startup mount
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />ORACLE instance started.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Total System Global Area  135337420 bytes
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Fixed Size                   452044 bytes
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Variable Size             109051904 bytes
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Database Buffers           25165824 bytes
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Redo Buffers                 667648 bytes
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Database mounted.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />System altered.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />System altered.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />System altered.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> ALTER DATABASE OPEN;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Database altered.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> alter session set events '10046 trace name context forever,level 12';
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Session altered.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL> alter database character set INTERNAL_USE ZHS16CGB231280
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />Database altered.
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />SQL>
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdatabase character set INTERNAL_CONVERT" />

 

这是alert.log文件中的记录信息:

Tue Oct 19 16:26:30 2004

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Completed: ALTER DATABASE OPEN

Tue Oct 19 16:27:07 2004

alter database character set INTERNAL_USE ZHS16CGB231280

Updating character set in controlfile to ZHS16CGB231280

Tue Oct 19 16:27:15 2004

Thread 1 advanced to log sequence 118

  Current log# 2 seq# 118 mem# 0: /opt/oracle/oradata/primary/redo02.log

Tue Oct 19 16:27:15 2004

ARC0: Evaluating archive   log 3 thread 1 sequence 117

ARC0: Beginning to archive log 3 thread 1 sequence 117

Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/oradata/primary/archive/1_117.dbf'

ARC0: Completed archiving  log 3 thread 1 sequence 117

Tue Oct 19 16:27:20 2004

Completed: alter database character set INTERNAL_USE ZHS16CGB231280

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 1

Tue Oct 19 16:29:06 2004

ALTER DATABASE CLOSE NORMAL


 

喜欢

0

阅读┊ 收藏 ┊ 喜欢▼ ┊打印┊举报/Report
  

新浪BLOG意见反馈留言板　欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

Copyright © 1996 - 2022 SINA Corporation, All Rights Reserved

新浪公司 版权所有