i have a table draft_elements in my oracle 7 database
around 12500 rows are in this table.
description of this table is
DRFT_ELMNT_ELM_ID NOT NULL NUMBER(9)
DRFT_ELMNT_ICD_ELM_ID NOT NULL NUMBER(2)
DRFT_ELMNT_ELM_NAME NOT NULL VARCHAR2(125)
DRFT_ELMNT_ELM_DATA_TYPE_ID NOT NULL NUMBER(4)
DRFT_ELMNT_ELM_START_POSITION NOT NULL NUMBER(2)
DRFT_ELMNT_ELM_END_POSITION NOT NULL NUMBER(2)
DRFT_ELMNT_ELM_STATUS NOT NULL VARCHAR2(15)
DRFT_ELMNT_USER_ID NOT NULL VARCHAR2(10)
DRFT_ELMNT_LAST_UPD_DATE NOT NULL DATE
DRFT_WORD_WRD_WORD_ID NOT NULL NUMBER(9)
DRFT_DATA_TYPE_DT_DATA_TYPE_ID NUMBER(3)
DRFT_ELMNT_ELEMENT_ALIAS_NAME VARCHAR2(50)
DRFT_ELMNT_ELMNT_ELEMENT_ID NUMBER(5)
DRFT_ELMNT_REMARKS VARCHAR2(240)
DRFT_ELMNT_SIGNAL_TYPE VARCHAR2(15)
DRFT_ELMNT_UNITS VARCHAR2(15)
DRFT_ELMNT_NOTE LONG
DRFT_ELMNT_LSB VARCHAR2(15)
DRFT_ELMNT_MSB VARCHAR2(15)
DRFT_ELMNT_LOWER_RANGE NUMBER(15,4)
DRFT_ELMNT_UPPER_RANGE NUMBER(15,4)
DRFT_ELMNT_TOLERANCE NUMBER(10)
before adding some 50 rows, this table was getting exported and
imported properly.
but after addition of some rows it is getting exported successfully.
but while importing it is giving a list of
"UNRECOGNISED STATEMENT IN THE EXPORT FILE: "
statements
followed by some contents of the table.
after the completion it is not stating
"IMPORT TERMINATED SUCCESSFULLY".
but only few rows of the table are getting inserted into the database
(around 250 rows).
what may be the problem?
Received on Fri Feb 21 2003 - 05:30:46 CST
