- 论坛徽章:
- 0
|
求助（升后还原备份报IMP-00017错）
升级后一共三个问题：
1.升级过程中有此提示不知正常不？
COMP_TIMESTAMP START 02-6？ -09 02.30.51.504000 ？？ +08:00
DOC>######################################################################
DOC>######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error and terminate the SQLPLUS session if the user is not SYS.
DOC> Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#
no rows selected
Package created.
这是相关查询
SQL> show sga
Total System Global Area 1553017424 bytes
Fixed Size 457296 bytes
Variable Size 1283457024 bytes
Database Buffers 268435456 bytes
Redo Buffers 667648 bytes
SHARED_POOL_SIZE='600M'
JAVA_POOL_SIZE='600M'
2.升完级后查询 select comp_name , version from dba_registry;
Oracle9i Catalog Views 9.2.0.8.0
Oracle9i Packages and Types 9.2.0.8.0
Oracle Workspace Manager 9.2.0.1.0（这个还是9.2.0.1？）
。 9.2.0.8.0
。 9.2.0.8.0
3.我恢复数据库未升级前的备份的时候，有些不能恢复，如下：
IMP-00017: following statement failed with ORACLE error 957:
"CREATE FORCE VIEW "BJSGAJXCFJ_AID"."GD_ACCOUNTSEARCH" ("RW"
"ID","BILLTAG","固定资产编号","固定资产卡片编号","名称","未处置","单据日期","
""国标分类代码","分类代码","取得日期","价值","资产类别代码","资产类别","ORGI"
"D","ORGCODE","ORGNAME") AS "
"select H.RWID rwid , H.billTag billtag , H.billcode 固定资产编号, H."
"billstdcode 固定资产卡片编号, H.Stdname 名称, H.WeiCZ 未处置, H.billda"
"te 单据日期,C.Stdcode 国标分类代码,C.StdName 分类代码, H.BuildDate 取得日期"
", H.OrgnValue 价值, T.stdcode 资产类别代码,T.StdCode||'、'||T.Stdname 资产"
"类别, H.OrgID, O.StdCode OrgCode, O.StdName OrgName From GD_AssetCard_H H"
" left outer join JC_AssetCatalog C on C.RWID=H.CatalogId left outer joi"
"n JC_AssetType T on T.RWID=C.ZCLBCWKJID left outer join Sys_OrgUnit O on "
"H.OrgID=O.RwID"
IMP-00003: ORACLE error 957 encountered
ORA-00957: duplicate column name
IMP-00017: following statement failed with ORACLE error 957:
"CREATE FORCE VIEW "BJSGAJXCFJ_AID"."GD_ASSETDPRCT_Q" ("RWI"
"D","BILLTAG","固定资产编号","固定资产卡片编号","资产名称","单据日期","国标分"
"类代码","分类代码","取得日期","折旧方法","价值","使用年限","已提折旧月数",""
"预计残值","残值率","月折旧额","累计折旧","帐面净值","减值准备","资产类别代码"
"","资产类别","ORGID","ORGCODE","ORGNAME") AS "
"select H.RWID rwid , H.billTag billtag , H.billcode 固定资产编号, H."
"billstdcode 固定资产卡片编号, H.Stdname 资产名称, H.billdate 单据日期,C"
".Stdcode 国标分类代码,C.StdName 分类代码, H.BuildDate 取得日期,E.Enumvalue"
" 折旧方法, H.OrgnValue 价值,H.ExptMonth 使用年限,H.UsedMonth 已提折旧月数,"
" H.RMValue 预计残值,H.RMValueRate 残值率,H.DPRCTValue 月折旧额, H.DPRCTTo"
"tal 累计折旧,H.CurrValue 帐面净值,H.DeValue 减值准备, T.stdcode 资产类别"
"代码,T.StdCode||'、'||T.Stdname 资产类别, H.OrgID, O.StdCode OrgCode, O.St"
"dName OrgName From GD_AssetCard_H H left outer join JC_EnumDict E o"
"n E.EnumID=H.DPRCTWayID left outer join JC_AssetCatalog C on C.RWID=H.Cat"
"alogID left outer join JC_AssetType T on T.RWID=C.ZCLBCWKJID left outer "
"join Sys_OrgUnit O on H.OrgID=O.RwID where H.DPRCTState='182'"
IMP-00003: ORACLE error 957 encountered
ORA-00957: duplicate column name
Import terminated successfully with warnings.
[ 本帖最后由 wsjxtn 于 2009-6-2 15:31 编辑 ] |
|
免费注册
发表于 2009-05-31 15:14
我已经答复你了。