我想升级我的军卫一号系统，请帮帮我。

netfun2000

. . importing table                    "DEF$_CALL"          0 rows imported
. . importing table                "DEF$_CALLDEST"          0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_CALLDEST" ADD  CONSTRAINT "DEF$_CALLDEST_PRIMARY" PRIMARY"
" KEY ("DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","CALLNO","DBLINK" USING INDEX "
"STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 5"
"0 FREELISTS 1 ) TABLESPACE "USER_DATA""
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_DB" IS  'Originating datab"
"ase for the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_ID" IS  'Transaction ID'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."CALLNO" IS  'Unique ID of call within tr"
"ansaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DUMMY_BUFFER_NUMBER" IS  'Used for forei"
"gn key reference only'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
. . importing table             "DEF$_DEFAULTDEST"          0 rows imported
. . importing table             "DEF$_DESTINATION"          0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_TRAN_ID" IS  'Transaction ID of "
"last transaction propagated'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_TRAN_DB" IS  'Source of last tra"
"nsaction propagated'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_ERROR" IS  'Oracle error number "
"from last push'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_MSG" IS  'Error message from las"
"t push'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
. . importing table                   "DEF$_ERROR"          0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_ERROR" ADD  CONSTRAINT "DEF$_ERROR_PRIMARY" PRIMARY KEY ("
""DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","DESTINATION" USING INDEX STORAGE (I"
"NITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELIST"
"S 1 ) TABLESPACE "USER_DATA""
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."DEFERRED_TRAN_DB" IS  'The database origina"
"ting or copying the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."DEFERRED_TRAN_ID" IS  'The ID of the transa"
"ction that originated or copied the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."CALLNO" IS  'Unique ID of call that caused "
"an error'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."ERROR_TIME" IS  'Time error occurred'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name

请教一下，这个错误的原因是什么？

netfun2000

还有一个错误：
old   2:         add datafile '&datafile\sys2orcl.ora'
new   2:         add datafile 'd:\orant\database\sys2orcl.ora'

Tablespace altered.

old   2:         add datafile '&datafile\rbs2orcl.ora'
new   2:         add datafile 'd:\orant\database\rbs2orcl.ora'
alter tablespace rollback_data
*
ERROR at line 1:
ORA-00959: tablespace 'ROLLBACK_DATA' does not exist


old   2:         add datafile '&datafile\tmp2orcl.ora'
new   2:         add datafile 'd:\orant\database\tmp2orcl.ora'
alter tablespace temporary_data
*
ERROR at line 1:
ORA-00959: tablespace 'TEMPORARY_DATA' does not exist

fox600123

ORA-00959: tablespace 'ROLLBACK_DATA' does not exist

ORA-00959: tablespace 'TEMPORARY_DATA' does not exist

lfree

从7.3 到 8.1.7 很容易的。

从7.3  使用emp 取出，注意是全部。
exp system◎foo CONSISTENT=Y LOG=xxx.log FULL=Y file=his.dmp

然后导入：
imp system◎foo file=his.dmp log=yyy.log ignore=Y

注意这里导入的时候要先建立好目录。要保持原来的路径一直。

如果你不喜欢原来的目录（旧），可以先建立好表空间。
另外好像有一个max_enabled_roles的参数要设置大一些。

max_enabled_roles                    integer                100

netfun2000

谢谢版主。
那个7.3的oracle字符集好像是US7ASCII

connect internal/oracle
update props$ set value$='US7ASCII' where name='NLS_CHARACTERSET';
commit;
shutdown immediate
startup
exit

我安装oracle8.1.7的时候，选择自定义安装，在“字符集”和“国家字符集”都选择了US7ASCII，可打开IMP后的数据，发现都是乱码。

lfree

你客户端的字符集定义为什么？

netfun2000

Cb7Q|0|1|1
0|8I|0|1|1
>|H+7Q|2|3|1
9+7Q|1|1|1
R=AF1#OU|1|1|1
WT7Q|1|1|1
H+7Q|1|1|1
<uCb7Q|9|10|1
FdK{|1|1|1
>|0k7Q|1|3|1
>|HK|0|1|1
@M1#|1|1|1

第一列应该是汉字，可现在是这个样子，正常吗？

netfun2000

我是在TOAD里面看的，这个也需要定义字符集吗？

netfun2000

最初由 lfree 发布
[B]你客户端的字符集定义为什么？ [/B]

我是看军惠的ORACLE7.3安装脚本里面是这样写的。

我在老服务器上看ORACLE7.3的字符集是US7ASCII.

netfun2000

好像不是很容易的啊。