请教:
源数据库:GB18030的编码,
目标数据库:GBK 编码
表中的数据不会乱码,但是视图定义中的中文乱码了,比如
CREATE OR REPLACE FORCE VIEW "PSSAPP"."PSS_ACTIVE_START_CHANGE_APP" ("APP_ID", "APP_NO", "APP_USER_CODE", "USER_CODE", "APPLY_DATE", "APP_TYPE", "APP_FLOW", "APP_STATUS", "ENTRY_ID", "BRANCH_CODE", "SUB_BRANCH_CODE", "APP_USER_NAME")
AS
SELECT pav."APP_ID",
pav."APP_NO",
pav."APP_USER_CODE",
pav."USER_CODE",
pav."APPLY_DATE",
pav."APP_TYPE",
pav."APP_FLOW",
pav."APP_STATUS",
pav."ENTRY_ID",
pav."BRANCH_CODE",
pav."SUB_BRANCH_CODE",
pav."APP_USER_NAME"
FROM pss_change_app_view pav
WHERE pav.app_type = '????'
AND pav.app_status ='Approved'
AND pav.user_code IN
这里的app_type 是中文,乱码了
先在源数据库服务器上 EXP DUMP 的数据
然后拷到另一台机器上,IMP user/passwd@pss_orcl,这里pss_orcl 是远程访问的,不是直接登录操作的机器
[ 本帖最后由 gehuiwin 于 2010-12-17 17:11 编辑 ] |