| Importing Constraints... [message #69904] |
Tue, 19 March 2002 00:33  |
Faraz
Messages: 5
Registered: April 1999
|
Junior Member |
|
|
The problem i am having is very strange. i dont know where i am going wrong thats why i am pasting the entinre import log here.
-------------------------------------------------------
C:>imp mdadm/abc fromuser=MDADM touser=MDADM
Import: Release 8.1.6.0.0 - Production on Tue Mar 19 12:48:55 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Personal Oracle8i Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
export client uses JA16SJIS character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
. . importing table "SYN_TSS_ITEMST" 4 rows imported
. . importing table "T_ALT_SKN" 0 rows imported
. . importing table "T_BIZNS_GROUP" 0 rows imported
. . importing table "T_BIZNS_GROUP2" 4 rows imported
. . importing table "T_BUYER" 0 rows imported
. . importing table "T_CATGR" 5 rows imported
. . importing table "T_CATGR_HEKN_SIZE" 1 rows imported
. . importing table "T_CHINRTSTN" 8 rows imported
. . importing table "T_CHINRTSTN_FZK_SKN" 0 rows imported
. . importing table "T_CHINRTSTN_HACHCH" 0 rows imported
. . importing table "T_CHINRTSTN_KANRN_SKN" 0 rows imported
. . importing table "T_DUMMY_SKN" 0 rows imported
. . importing table "T_HANSKBTS" 17 rows imported
. . importing table "T_HANSKBTS_HACHCH" 0 rows imported
. . importing table "T_HONGM" 0 rows imported
. . importing table "T_ITEMST" 0 rows imported
. . importing table "T_MD_PARAM" 6 rows imported
. . importing table "T_MIDR_GOUP_YUSNZYN" 0 rows imported
. . importing table "T_MIDR_GROUP" 7 rows imported
. . importing table "T_MIDR_GROUP2" 16 rows imported
. . importing table "T_MPB" 3 rows imported
. . importing table "T_NIHNG_SYOHN_NM" 4 rows imported
. . importing table "T_PEG_SPACE_HACHCH" 1 rows imported
. . importing table "T_RIYSH_KNGN" 3 rows imported
. . importing table "T_SKN" 78 rows imported
. . importing table "T_SKN2" 0 rows imported
. . importing table "T_SKN_HACHCH" 0 rows imported
. . importing table "T_SKN_SIZE" 0 rows imported
. . importing table "T_SKYPLAN" 4 rows imported
. . importing table "T_SKYPLAN_TEXT_HACHCH" 0 rows imported
. . importing table "T_SONTHCHBTS_HACHCH" 0 rows imported
. . importing table "T_SUB_CATGR" 0 rows imported
. . importing table "T_TANA" 65 rows imported
. . importing table "T_TANA_HACHCH" 1 rows imported
. . importing table "T_TANA_LAYOUT" 0 rows imported
. . importing table "T_TANA_LAYOUT_FUZK_FILE" 0 rows imported
. . importing table "T_TANA_LAYOUT_YUSNZYN" 0 rows imported
. . importing table "T_TENPO" 170 rows imported
. . importing table "T_TEXT_HACHCH" 0 rows imported
. . importing table "T_TOKSYU_SKN" 0 rows imported
. . importing table "T_USERS" 3 rows imported
. . importing table "T_USERS2" 1105 rows imported
. . importing table "T_VENDER" 0 rows imported
. . importing table "T_ZYUK" 139 rows imported
. . importing table "T_ZYUK_ICHI" 0 rows imported
About to enable constraints...
Import terminated successfully without warnings.
C:>
-------------------------------------------------------
now the rpoblem is it imports the tables the null constraints and the primary keys but not the foreign keys. Tell me if the way i am importing is right or not. Plus is it possible that i am doing right but the actual DMP file does not consist of the constraints.???
please help quickly.....i am in deep trouble as its 1:00am in the morning and i am still in the office...:(
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
