IMP utility has a bug? when CONSTRAINTS = N [message #71789] |
Sat, 11 January 2003 01:51 |
Sergey
Messages: 7 Registered: December 2002
|
Junior Member |
|
|
When I import data with CONSTRAINTS=n then IMP generates errors "unrecognized commands" showing some garbage characters and broken pieces of table data.
When I set to CONSTRAINTS = Y then the problem disappears.
Dump file is created on UNIX (Ora 8.1.6)->gziped -> FTPed ->extracted with gzip on Win2K (Ora 8.1.7) and then imported.
I've played with gzip and it is out of suspects
Any thoughts?
|
|
|
|
Re: IMP utility has a bug? when CONSTRAINTS = N [message #71800 is a reply to message #71790] |
Wed, 15 January 2003 10:32 |
Sergey
Messages: 7 Registered: December 2002
|
Junior Member |
|
|
THE SAME PATTERN REPEATS FROM LOG TO LOG. SEEMS LIKE IT BREAKS DOWN IN THE SAME PLACE, GENERATES ERRORS, AND THEN GETS BACK TO NORMAL AGAIN UNTIL THE EOF.
ANY THOUGHTS, GENTLMEN?
. . importing table "TABLE_1" 980 rows imported
. . importing table "TABLE_2" 4 rows imported
. . importing table "TABLE_3" 117 rows imported
IMP-00008: unrecognized statement in the export file:
ýÿ <- THIS IS A FUNNY CHARACTER imp.exe POPS OUT
. . importing table "TABLE_4" 672 rows imported
. . importing table "TABLE_5" 1071 rows imported
. importing table "TABLE_5" 4 rows imported
. . importing table "TABLE_6" 3 rows imported
. . importing table "TABLE_7" 93 rows imported
IMP-00008: unrecognized statement in the export file:
ýÿ)
IMP-00008: unrecognized statement in the export file:
.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
þÿ
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
derstanding of the physiologic basis of congestive heart failure.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
program meet the goal of providing a comprehensive review of the role of
IMP-00008: unrecognized statement in the export file:
non-nucleoside reverse transcriptase inhibitors in the clinical managment of
IMP-00008: unrecognized statement in the export file:
HIV disease?
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
and on current approaches for promoting weight loss?
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
referral of potential organ and tissue donors to organ procurement organizations, clinical management of potential organ
IMP-00008: unrecognized statement in the export file:
donors, and education and support of donor families.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
external fixation, and plating
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
ew findings and discussing their practice and research implications.
IMP-00008: unrecognized statement in the export file:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
for treating and preventing influenza
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
treatment of GERD
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
management.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
Diagnose and treat behaviorial disorders, urinary tract infections, and female adolescent health problems.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
Non-Hodgkin's Lymphoma.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
Study.
IMP-00008: unrecognized statement in the export file:
coronary artery disease.
IMP-00008: unrecognized statement in the export file:
cardiovascular disease.
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
energy metabolism and insulin sensitivity.
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
n patients with diabetes.
. . importing table "TABLE_8" 20194 rows imported
IMP-00008: unrecognized statement in the export file:
ýÿ
. . importing table "TABLE_9" 4 rows imported
. . importing table "TABLE_10" 2690 rows imported
. . importing table "TABLE_11" 225 rows imported
|
|
|
|