Home » RDBMS Server » Server Utilities » importing table data is not comming (10.2..0.4 , windows xp)
importing table data is not comming [message #455091] Mon, 10 May 2010 02:20 Go to next message
lala_bcs
Messages: 4
Registered: January 2007
Location: N.W.F.P PAKISTAN
Junior Member
i take export of one table (export complet successfully without warnings)
when i am going to import into prduction databae the data in the table no comming i past the table structure and import command and logfile for import.

import command

imp user/user@database file=C:\Temp\userdrop_id10g\t_id_rac_ra_headertables.dmp log=C:\Temp\userdrop_id10g\t_id_rac_ra_headertablesimp.log tables=t_id_rac_ra_header fromuser=user touser=user statistics=none ignore=yes


my table structure in production database is

CREATE TABLE t_id_rac_ra_header
(ra_company VARCHAR2(10) NOT NULL,
ra_key NUMBER NOT NULL,
ra_doc_type VARCHAR2(50) NOT NULL,
ra_doc_number VARCHAR2(25) NOT NULL,
ra_doc_date DATE DEFAULT SYSDATE NOT NULL,
ra_reserve_key NUMBER,
ra_type VARCHAR2(1) DEFAULT 'S' NOT NULL,
ra_mode VARCHAR2(1) DEFAULT 'V' NOT NULL,
ra_trans_type VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_customer_key NUMBER,
ra_customer_doc_key NUMBER,
ra_customer_doc_2_key NUMBER,
ra_customer_address VARCHAR2(240),
ra_rented_by VARCHAR2(1) DEFAULT 'C' NOT NULL,
ra_lease_key NUMBER,
ra_quote_key NUMBER,
ra_group_key NUMBER,
ra_make_key NUMBER,
ra_fleet_key NUMBER,
ra_currency_key VARCHAR2(10) NOT NULL,
ra_reference VARCHAR2(240),
ra_status VARCHAR2(1) DEFAULT 'O' NOT NULL,
ra_rate_updated VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_location_key_open NUMBER NOT NULL,
ra_location_key_close NUMBER,
ra_driver_1_key NUMBER,
ra_driver_2_key NUMBER,
ra_notes VARCHAR2(4000),
ra_slab_from NUMBER DEFAULT 0 ,
ra_slab_to NUMBER DEFAULT 0 NOT NULL,
ra_calc_method VARCHAR2(2),
ra_basic_rate NUMBER DEFAULT 0 NOT NULL,
ra_ex_rate_per_day NUMBER DEFAULT 0 NOT NULL,
ra_free_km NUMBER DEFAULT 0 NOT NULL,
ra_mileage_rate NUMBER DEFAULT 0 NOT NULL,
ra_last_invoice_date DATE,
ra_parent_key NUMBER,
ra_sm_key NUMBER,
ra_created_by NUMBER NOT NULL,
ra_created_on DATE DEFAULT SYSDATE NOT NULL,
ra_modified_by NUMBER,
ra_modified_on DATE,
ra_flex_v_1 VARCHAR2(240),
ra_flex_v_2 VARCHAR2(240),
ra_flex_v_3 VARCHAR2(240),
ra_flex_v_4 VARCHAR2(240),
ra_flex_n_1 NUMBER,
ra_flex_n_2 NUMBER,
ra_flex_n_3 NUMBER,
ra_flex_n_4 NUMBER,
ra_rental_type VARCHAR2(1),
ra_allow_discount VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_image BLOB,
ra_file_name VARCHAR2(100),
ra_delivery_status VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_collection_status VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_upgrade_status VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_sub_lease_type VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_collection_schedule_date DATE,
ra_collection_remarks VARCHAR2(400),
ra_replace_type VARCHAR2(1),
ra_base_key NUMBER NOT NULL,
ra_base_doc_number VARCHAR2(25) NOT NULL,
ra_fleet_registration VARCHAR2(50) NOT NULL,
ra_tariff_group_key NUMBER,
ra_tariff_make_key NUMBER,
ra_replace_fleet_type VARCHAR2(1),
ra_tariff_hdr_key NUMBER,
ra_tariff_dtl_key NUMBER,
ra_sys_calc_tariff_hdr_key NUMBER,
ra_sys_calc_tariff_dtl_key NUMBER,
ra_reserve_group_key NUMBER,
ra_reserve_make_key NUMBER,
ra_driver_charges NUMBER DEFAULT 0,
ra_cdw_charges NUMBER DEFAULT 0,
ra_pai_charges NUMBER DEFAULT 0,
ra_discount_percent NUMBER DEFAULT 0,
ra_is_complement VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_sys_ra_type VARCHAR2(1) NOT NULL,
ra_is_damaged VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_inv_rule_type_key NUMBER NOT NULL,
ra_next_invoice_date DATE,
ra_approve_status VARCHAR2(1) DEFAULT 'N' NOT NULL,
ra_approve_remarks VARCHAR2(400),
ra_approved_by NUMBER,
ra_approved_on DATE
,
CONSTRAINT RACRAHEDER_PK
PRIMARY KEY (ra_key)
USING INDEX)
LOB (RA_IMAGE) STORE AS SYS_LOB0000324737C00053$$
(
NOCACHE LOGGING
CHUNK 8192
)
/


IMPORT log file.
----------------------------
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing user1's objects into user1
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "T_ID_RAC_RA_HEADER" ("RA_COMPANY" VARCHAR2(10) NOT NULL ENABL"
"E, "RA_KEY" NUMBER NOT NULL ENABLE, "RA_DOC_TYPE" VARCHAR2(50) NOT NULL ENA"
"BLE, "RA_DOC_NUMBER" VARCHAR2(25) NOT NULL ENABLE, "RA_DOC_DATE" DATE NOT N"
"ULL ENABLE, "RA_RESERVE_KEY" NUMBER, "RA_TYPE" VARCHAR2(1) NOT NULL ENABLE,"
" "RA_MODE" VARCHAR2(1) NOT NULL ENABLE, "RA_TRANS_TYPE" VARCHAR2(1) NOT NUL"
"L ENABLE, "RA_CUSTOMER_KEY" NUMBER, "RA_CUSTOMER_DOC_KEY" NUMBER, "RA_CUSTO"
"MER_DOC_2_KEY" NUMBER, "RA_CUSTOMER_ADDRESS" VARCHAR2(240), "RA_RENTED_BY" "
"VARCHAR2(1) NOT NULL ENABLE, "RA_LEASE_KEY" NUMBER, "RA_QUOTE_KEY" NUMBER, "
""RA_GROUP_KEY" NUMBER, "RA_MAKE_KEY" NUMBER, "RA_FLEET_KEY" NUMBER, "RA_CUR"
"RENCY_KEY" VARCHAR2(10) NOT NULL ENABLE, "RA_REFERENCE" VARCHAR2(240), "RA_"
"STATUS" VARCHAR2(1) NOT NULL ENABLE, "RA_RATE_UPDATED" VARCHAR2(1) NOT NULL"
" ENABLE, "RA_LOCATION_KEY_OPEN" NUMBER NOT NULL ENABLE, "RA_LOCATION_KEY_CL"
"OSE" NUMBER, "RA_DRIVER_1_KEY" NUMBER, "RA_DRIVER_2_KEY" NUMBER, "RA_NOTES""
" VARCHAR2(4000), "RA_SLAB_FROM" NUMBER, "RA_SLAB_TO" NUMBER NOT NULL ENABLE"
", "RA_CALC_METHOD" VARCHAR2(2), "RA_BASIC_RATE" NUMBER NOT NULL ENABLE, "RA"
"_EX_RATE_PER_DAY" NUMBER NOT NULL ENABLE, "RA_FREE_KM" NUMBER NOT NULL ENAB"
"LE, "RA_MILEAGE_RATE" NUMBER NOT NULL ENABLE, "RA_LAST_INVOICE_DATE" DATE, "
""RA_PARENT_KEY" NUMBER, "RA_SM_KEY" NUMBER, "RA_CREATED_BY" NUMBER NOT NULL"
" ENABLE, "RA_CREATED_ON" DATE NOT NULL ENABLE, "RA_MODIFIED_BY" NUMBER, "RA"
"_MODIFIED_ON" DATE, "RA_FLEX_V_1" VARCHAR2(240), "RA_FLEX_V_2" VARCHAR2(240"
"), "RA_FLEX_V_3" VARCHAR2(240), "RA_FLEX_V_4" VARCHAR2(240), "RA_FLEX_N_1" "
"NUMBER, "RA_FLEX_N_2" NUMBER, "RA_FLEX_N_3" NUMBER, "RA_FLEX_N_4" NUMBER, ""
"RA_RENTAL_TYPE" VARCHAR2(1), "RA_ALLOW_DISCOUNT" VARCHAR2(1) NOT NULL ENABL"
"E, "RA_IMAGE" BLOB, "RA_FILE_NAME" VARCHAR2(100), "RA_DELIVERY_STATUS" VARC"
"HAR2(1) NOT NULL ENABLE, "RA_COLLECTION_STATUS" VARCHAR2(1) NOT NULL ENABLE"
", "RA_UPGRADE_STATUS" VARCHAR2(1) NOT NULL ENABLE, "RA_SUB_LEASE_TYPE" VARC"
"HAR2(1) NOT NULL ENABLE, "RA_COLLECTION_SCHEDULE_DATE" DATE, "RA_COLLECTION"
"_REMARKS" VARCHAR2(400), "RA_REPLACE_TYPE" VARCHAR2(1), "RA_BASE_KEY" NUMBE"
"R NOT NULL ENABLE, "RA_BASE_DOC_NUMBER" VARCHAR2(25) NOT NULL ENABLE, "RA_F"
"LEET_REGISTRATION" VARCHAR2(50) NOT NULL ENABLE, "RA_TARIFF_GROUP_KEY" NUMB"
"ER, "RA_TARIFF_MAKE_KEY" NUMBER, "RA_REPLACE_FLEET_TYPE" VARCHAR2(1), "RA_T"
"ARIFF_HDR_KEY" NUMBER, "RA_TARIFF_DTL_KEY" NUMBER, "RA_SYS_CALC_TARIFF_HDR_"
"KEY" NUMBER, "RA_SYS_CALC_TARIFF_DTL_KEY" NUMBER, "RA_RESERVE_GROUP_KEY" NU"
"MBER, "RA_RESERVE_MAKE_KEY" NUMBER, "RA_DRIVER_CHARGES" NUMBER, "RA_CDW_CHA"
"RGES" NUMBER, "RA_PAI_CHARGES" NUMBER, "RA_DISCOUNT_PERCENT" NUMBER, "RA_IS"
"_COMPLEMENT" VARCHAR2(1) NOT NULL ENABLE, "RA_SYS_RA_TYPE" VARCHAR2(1) NOT "
"NULL ENABLE, "RA_IS_DAMAGED" VARCHAR2(1) NOT NULL ENABLE, "RA_INV_RULE_TYPE"
"_KEY" NUMBER NOT NULL ENABLE, "RA_NEXT_INVOICE_DATE" DATE, "RA_APPROVE_STAT"
"US" VARCHAR2(1) NOT NULL ENABLE, "RA_APPROVE_REMARKS" VARCHAR2(400), "RA_AP"
"PROVED_BY" NUMBER, "RA_APPROVED_ON" DATE, "RA_MANUAL_DOC_NUMBER" VARCHAR2(5"
"0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 131072 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "APP_DATA_SPAC"
"E" LOGGING NOCOMPRESS LOB ("RA_IMAGE") STORE AS (TABLESPACE "APP_DATA_SPAC"
"E" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INIT"
"IAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
Import terminated successfully with warnings.
Re: importing table data is not comming [message #455099 is a reply to message #455091] Mon, 10 May 2010 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
following statement failed because the object already exists:

So either use "ignore=y" or drop the ptable before importing.

Regards
Michel

[Updated on: Mon, 10 May 2010 05:45]

Report message to a moderator

Re: importing table data is not comming [message #455103 is a reply to message #455099] Mon, 10 May 2010 03:19 Go to previous messageGo to next message
lala_bcs
Messages: 4
Registered: January 2007
Location: N.W.F.P PAKISTAN
Junior Member
i use ignore=y but i am importing in an other sytem ... i think no need to drop the table
Re: importing table data is not comming [message #455112 is a reply to message #455103] Mon, 10 May 2010 03:45 Go to previous messageGo to next message
Littlefoot
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If import failed because the object already exists, then I believe that Oracle is right and you're wrong. Perhaps you should check once again what is the target schema (did you provide correct credentials?), whether object with such a name exists and ... do something. You might need to drop that object, rename it, rename source table name ... or something else.
Re: importing table data is not comming [message #455117 is a reply to message #455103] Mon, 10 May 2010 04:26 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
lala_bcs wrote on Mon, 10 May 2010 13:49
i use ignore=y but i am importing in an other sytem ... i think no need to drop the table



You Mean schema?

sriram Smile
Previous Topic: Loading of foreign text
Next Topic: Schema impdb invalid statement error
Goto Forum:
  


Current Time: Sun Sep 19 21:34:01 CDT 2021