loaddb 에러 발생.

by 스팅거 posted Oct 09, 2009

6.4 버전에서 받은 (unloaddb -cs -so ) 파일을  다른 서버에서 로드 하는 중에 발생하는 에러 메시지 입니다.

SRC( Solaris 5.9  Unisql 6.4 ) ==> DEST ( Solaris 5.8 Unisq 6.6 , 7.1)


line 1: syntax error at "call" missing EOF
....
....
invalid token near line 1014 (text was ';')
invalid token near line 1022 (text was ';')
invalid token near line 1024 (text was ';')
invalid token near line 1040 (text was ';')
invalid token near line 1042 (text was ';')
invalid token near line 1070 (text was ';')
invalid token near line 1072 (text was ';')




줄바꿈 문자때문에 발생하는 것으로 생각되서 변환하고 해봐도 마찬가지네요.

create serial pusr_seq
         start with 626798
         increment by 1
         minvalue 1
         maxvalue 99999999
         cycle;
update db_serial set owner = :auser, started=1 where name= 'pusr_seq';

call find_user('XXXX') on class db_user to auser;
create serial seq_num
         start with 5113
         increment by 1
         minvalue 1
         maxvalue 99999
         cycle;
update db_serial set owner = :auser, started=1 where name= 'seq_num';

CREATE CLASS user_tab_comments;
call change_owner('user_tab_comments', 'XXXX') on class db_root;

CREATE CLASS otmp_eng_addr;
call change_owner('otmp_eng_addr', 'XXXX') on class db_root;

CREATE CLASS otmc_counter;
call change_owner('otmc_counter', 'XXXX) on class db_root;

CREATE CLASS otmp_prov_dtl;
call change_owner('otmp_prov_dtl', 'XXXX') on class db_root;


Articles

14 15 16 17 18 19 20 21 22 23