Oracle 9i Release 9.2.0.1.0 Name : SYNC_FLAG Datatype : NUMBER Size : 1 Scale : 0 Default Value : 0
--- On Tue, 3/23/10, yulius_wibowo <[email protected]> wrote: From: yulius_wibowo <[email protected]> Subject: [indo-oracle] Re: IMP-00017: following statement failed with ORACLE error 907 To: [email protected] Date: Tuesday, March 23, 2010, 8:44 AM Ada kemungkinan karena bug-nya Oracle. Anda pakai 9i dgn patch set berapa? Boleh tahu type data utk column SYNC_FLAG ? Bowo --- In indo-oracle@ yahoogroups. com, Padang Nadimpu <nadi...@... > wrote: > > Dear all > > Saya melakukan imp dump lwt CMD dgn : > > imp user/passwd file=d:\backup. dmp ignore=y fromuser=user touser=user_ temp > tables=karyawan commit=y indexes=n constraints= n > > Saat proses import tampil error sebagai berikut : > > IMP-00017: following statement failed with ORACLE error 907: > " ALTER TABLE "KARYAWAN" MODIFY ("SYNC_FLAG" DEFAULT 0" > IMP-00003: ORACLE error 907 encountered > ORA-00907: missing right parenthesis > > Periksa hsl import lwt Oracle Enterprise Manager Console, > table karyawan tdk ada pd user_temp > > Saya coba import dgn TOAD for Oracle, pesan error yang ditampilkan juga sama. > > Sbg info, kami menggunakan oracle9i > > Mohon solusi agar dump file dpt diimport ke schema user_temp > > Seandainya tdk bs import krn field "SYNC_FLAG", apakah dimungkinkan import > dump (tables=karyawan) seluruh field kecuali "SYNC_FLAG" > > Atas perkenannya memberi solusi, diucapkan terimakasih > [Non-text portions of this message have been removed]
