| Problem in importing database [message #72256] |
Thu, 24 April 2003 17:12 |
Raja
Messages: 57
Registered: March 2000
|
Member |
|
|
when i tried to import one database, which was export from a working database user I got the following error message
"IMP-00017: following statement failed with ORACLE error 1741:
"CREATE TABLE "CANDIDATE" ("CANDIDATE_KEY" NUMBER(8, 0), "FIRST_NAME" VARCHA"
"R2(25) NOT NULL ENABLE, "MIDDLE_NAME" VARCHAR2(10) NOT NULL ENABLE, "LAST_N"
"AME" VARCHAR2(25), "FATHER_NAME" VARCHAR2(50), "DATE_OF_BIRTH" DATE NOT NUL"
"L ENABLE, "GENDER" VARCHAR2(1), "MARRITIAL_STATUS" VARCHAR2(1), "PERMANENT_"
"ADDRESS" ""."ADDRESS", "CONTACT_ADDRESS" ""."ADDRESS", "EMAIL_ID" VARCHAR2("
"50), "QUALIFICATION_KEY" NUMBER(8, 0) NOT NULL ENABLE, "SPECIALIZATION_KEY""
" NUMBER(8, 0) NOT NULL ENABLE, "TOTAL_EXPERIENCE" NUMBER(5, 2), "IT_EXPERIE"
"NCE" NUMBER(5, 2), "POST_APPLYING" NUMBER(8, 0) NOT NULL ENABLE, "CURRENT_S"
"ALARY" NUMBER(8, 2), "EXPECTED_SALARY" NUMBER(8, 2), "SUBMIT_CREDENTIALS" V"
"ARCHAR2(1), "SUBMIT_PASSPORT" VARCHAR2(1), "CONTRACT_PERIOD" NUMBER(5, 2), "
""EXTRA_CURRICULAR_ACT" VARCHAR2(100), "REFERENCE_INFORMATION" VARCHAR2(50),"
" "SELECT_STATUS" VARCHAR2(10), "EXPECTED_JOIN_DATE" DATE) PCTFREE 10 PCTUS"
"ED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 10240 NEXT 10240 MINE"
"XTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER"
"_POOL DEFAULT) TABLESPACE "USER_DATA""
IMP-00003: ORACLE error 1741 encountered"
Pls provied one soloution for this
Regards
Raja RR
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
