Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: not importing properly
harishksh_at_yahoo.com (harish) wrote in message news:<ff46df6e.0302210330.21454de_at_posting.google.com>...
> 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?
The problem is
- you don't show the export command - you don't show the import command - and crystal balls have sold out here
Usually the import buffer is too small and specifying buffer=8192000
should do the trick.
Oracle 7 has been desupped a long time ago.
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Fri Feb 21 2003 - 09:13:55 CST