Home » RDBMS Server » Server Utilities » How to load cognos dump into Oracle
How to load cognos dump into Oracle [message #338029] Sat, 02 August 2008 10:27 Go to next message
koteshwar
Messages: 7
Registered: October 2006
Location: hyderabad
Junior Member
Hi all,

I was trying to import a cognos dump into Oracle9i.
I need those tables neccesarly.
Please suggest. This is what I get when I import.
Thanks in Advance.


importing GOSL's objects into GOSL
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'GOSL', export_db_name="
">'ORBLT92.US.ORACLE.COM', inst_scn=>'117743864');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "CONVERSION_RATE" ("COUNTRY_CODE" NUMBER(10, 0) NOT NULL ENABL"
"E, "CONVERSION_YEAR" NUMBER(5, 0) NOT NULL ENABLE, "CONVERSION_MONTH" NUMBE"
"R(3, 0) NOT NULL ENABLE, "CONVERSION_TO_LOCAL" NUMBER(18, 4) NOT NULL ENABL"
"E) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FRE"
"ELISTS 1 FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "COUNTRY" ("COUNTRY_CODE" NUMBER(10, 0) NOT NULL ENABLE, "ISO_"
"THREE_LETTER_CODE" VARCHAR2(3) NOT NULL ENABLE, "ISO_TWO_LETTER_CODE" VARCH"
"AR2(2) NOT NULL ENABLE, "ISO_THREE_DIGIT_CODE" VARCHAR2(3) NOT NULL ENABLE,"
" "EURO_IN_USE_SINCE" DATE, "FLAG_IMAGE" VARCHAR2(50) NOT NULL ENABLE) PCTF"
"REE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1"
" FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "COUNTRY_MULTILINGUAL" ("COUNTRY_CODE" NUMBER(10, 0) NOT NULL "
"ENABLE, "LANGUAGE" VARCHAR2(2) NOT NULL ENABLE, "COUNTRY" VARCHAR2(150) NOT"
" NULL ENABLE, "CURRENCY_NAME" VARCHAR2(150) NOT NULL ENABLE) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "EURO_CONVERSION" ("COUNTRY_CODE" NUMBER(10, 0) NOT NULL ENABL"
"E, "EURO_YEAR" NUMBER(5, 0) NOT NULL ENABLE, "EURO_MONTH" NUMBER(3, 0) NOT "
"NULL ENABLE, "EURO_TO_LOCAL" NUMBER(18, 6) NOT NULL ENABLE) PCTFREE 10 PCT"
"USED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST "
"GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "INVENTORY_LEVELS" ("INVENTORY_YEAR" NUMBER(5, 0) NOT NULL ENA"
"BLE, "INVENTORY_MONTH" NUMBER(5, 0) NOT NULL ENABLE, "PRODUCT_NUMBER" NUMBE"
"R(10, 0) NOT NULL ENABLE, "CLOSING_INVENTORY" NUMBER(10, 0) NOT NULL ENABLE"
") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREE"
"LISTS 1 FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "ORDER_DETAILS" ("ORDER_DETAIL_CODE" NUMBER(10, 0) NOT NULL EN"
"ABLE, "ORDER_NUMBER" NUMBER(10, 0) NOT NULL ENABLE, "SHIP_DATE" DATE NOT NU"
"LL ENABLE, "PRODUCT_NUMBER" NUMBER(10, 0) NOT NULL ENABLE, "QUANTITY" NUMBE"
"R(5, 0) NOT NULL ENABLE, "UNIT_COST" NUMBER(19, 2) NOT NULL ENABLE, "UNIT_P"
"RICE" NUMBER(19, 2) NOT NULL ENABLE, "UNIT_SALE_PRICE" NUMBER(19, 2) NOT NU"
"LL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 6"
"5536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "ORDER_HEADER" ("ORDER_NUMBER" NUMBER(10, 0) NOT NULL ENABLE, "
""RETAILER_NAME" VARCHAR2(50) NOT NULL ENABLE, "RETAILER_NAME_MB" VARCHAR2(5"
"0) NOT NULL ENABLE, "RETAILER_SITE_CODE" NUMBER(10, 0) NOT NULL ENABLE, "RE"
"TAILER_CONTACT_CODE" NUMBER(10, 0) NOT NULL ENABLE, "SALES_STAFF_CODE" NUMB"
"ER(10, 0) NOT NULL ENABLE, "SALES_BRANCH_CODE" NUMBER(10, 0) NOT NULL ENABL"
"E, "ORDER_DATE" DATE NOT NULL ENABLE, "ORDER_CLOSE_DATE" DATE NOT NULL ENAB"
"LE, "ORDER_METHOD_CODE" NUMBER(10, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED "
"40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "ORDER_METHOD" ("ORDER_METHOD_CODE" NUMBER(10, 0) NOT NULL ENA"
"BLE, "ORDER_METHOD_EN" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_FR" VAR"
"CHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_DE" VARCHAR2(150) NOT NULL ENABLE"
", "ORDER_METHOD_NL" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_JA" VARCHA"
"R2(150) NOT NULL ENABLE, "ORDER_METHOD_SC" VARCHAR2(150) NOT NULL ENABLE, ""
"ORDER_METHOD_KO" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_CS" VARCHAR2("
"150) NOT NULL ENABLE, "ORDER_METHOD_HU" VARCHAR2(150) NOT NULL ENABLE, "ORD"
"ER_METHOD_PT" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_TC" VARCHAR2(150"
") NOT NULL ENABLE, "ORDER_METHOD_DA" VARCHAR2(150) NOT NULL ENABLE, "ORDER_"
"METHOD_EL" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_FI" VARCHAR2(150) N"
"OT NULL ENABLE, "ORDER_METHOD_IT" VARCHAR2(150) NOT NULL ENABLE, "ORDER_MET"
"HOD_NO" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_PL" VARCHAR2(150) NOT "
"NULL ENABLE, "ORDER_METHOD_RU" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD"
"_SV" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_ES" VARCHAR2(150) NOT NUL"
"L ENABLE, "ORDER_METHOD_TH" VARCHAR2(150) NOT NULL ENABLE, "ORDER_METHOD_MS"
"" VARCHAR2(150), "ORDER_METHOD_ID" VARCHAR2(150)) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
"TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "PRODUCT" ("PRODUCT_NUMBER" NUMBER(10, 0) NOT NULL ENABLE, "IN"
"TRODUCTION_DATE" DATE NOT NULL ENABLE, "PRODUCT_TYPE_CODE" NUMBER(10, 0) NO"
"T NULL ENABLE, "PRODUCTION_COST" NUMBER(18, 2) NOT NULL ENABLE, "MARGIN" FL"
"OAT(126) NOT NULL ENABLE, "PRODUCT_IMAGE" VARCHAR2(150) NOT NULL ENABLE) P"
"CTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELIST"
"S 1 FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "PRODUCT_FORECAST" ("PRODUCT_NUMBER" NUMBER(10, 0) NOT NULL EN"
"ABLE, "YEAR" NUMBER(5, 0) NOT NULL ENABLE, "MONTH" NUMBER(3, 0) NOT NULL EN"
"ABLE, "EXPECTED_VOLUME" NUMBER(10, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED "
"40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "PRODUCT_LINE" ("PRODUCT_LINE_CODE" NUMBER(10, 0) NOT NULL ENA"
"BLE, "PRODUCT_LINE_EN" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_FR" VAR"
"CHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_DE" VARCHAR2(140) NOT NULL ENABLE"
", "PRODUCT_LINE_NL" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_SC" VARCHA"
"R2(140) NOT NULL ENABLE, "PRODUCT_LINE_KO" VARCHAR2(140) NOT NULL ENABLE, ""
"PRODUCT_LINE_JA" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_CS" VARCHAR2("
"140) NOT NULL ENABLE, "PRODUCT_LINE_HU" VARCHAR2(140) NOT NULL ENABLE, "PRO"
"DUCT_LINE_PT" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_TC" VARCHAR2(140"
") NOT NULL ENABLE, "PRODUCT_LINE_DA" VARCHAR2(140) NOT NULL ENABLE, "PRODUC"
"T_LINE_EL" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_FI" VARCHAR2(140) N"
"OT NULL ENABLE, "PRODUCT_LINE_IT" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_L"
"INE_NO" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_PL" VARCHAR2(140) NOT "
"NULL ENABLE, "PRODUCT_LINE_RU" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE"
"_SV" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_ES" VARCHAR2(140) NOT NUL"
"L ENABLE, "PRODUCT_LINE_TH" VARCHAR2(140) NOT NULL ENABLE, "PRODUCT_LINE_MS"
"" VARCHAR2(140), "PRODUCT_LINE_ID" VARCHAR2(140)) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
"TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "PRODUCT_MULTILINGUAL" ("PRODUCT_NUMBER" NUMBER(10, 0) NOT NUL"
"L ENABLE, "LANGUAGE" VARCHAR2(2) NOT NULL ENABLE, "PRODUCT_NAME" VARCHAR2(1"
"50) NOT NULL ENABLE, "DESCRIPTION" VARCHAR2(1000) NOT NULL ENABLE) PCTFREE"
" 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FR"
"EELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "PRODUCT_TYPE" ("PRODUCT_TYPE_CODE" NUMBER(10, 0) NOT NULL ENA"
"BLE, "PRODUCT_LINE_CODE" NUMBER(10, 0) NOT NULL ENABLE, "PRODUCT_TYPE_EN" V"
"ARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_FR" VARCHAR2(150) NOT NULL ENAB"
"LE, "PRODUCT_TYPE_DE" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_NL" VARC"
"HAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_JA" VARCHAR2(150) NOT NULL ENABLE,"
" "PRODUCT_TYPE_SC" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_KO" VARCHAR"
"2(150) NOT NULL ENABLE, "PRODUCT_TYPE_CS" VARCHAR2(150) NOT NULL ENABLE, "P"
"RODUCT_TYPE_HU" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_PT" VARCHAR2(1"
"50) NOT NULL ENABLE, "PRODUCT_TYPE_TC" VARCHAR2(150) NOT NULL ENABLE, "PROD"
"UCT_TYPE_DA" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_EL" VARCHAR2(150)"
" NOT NULL ENABLE, "PRODUCT_TYPE_FI" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT"
"_TYPE_IT" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_NO" VARCHAR2(150) NO"
"T NULL ENABLE, "PRODUCT_TYPE_PL" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TY"
"PE_RU" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_SV" VARCHAR2(150) NOT N"
"ULL ENABLE, "PRODUCT_TYPE_ES" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_"
"TH" VARCHAR2(150) NOT NULL ENABLE, "PRODUCT_TYPE_MS" VARCHAR2(150), "PRODUC"
"T_TYPE_ID" VARCHAR2(150)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
"ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGIN"
"G NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "RETURNED_ITEM" ("RETURN_CODE" NUMBER(10, 0) NOT NULL ENABLE, "
""RETURN_DATE" DATE NOT NULL ENABLE, "ORDER_DETAIL_CODE" NUMBER(10, 0) NOT N"
"ULL ENABLE, "RETURN_REASON_CODE" NUMBER(10, 0) NOT NULL ENABLE, "RETURN_QUA"
"NTITY" NUMBER(5, 0) NOT NULL ENABLE, "ASSIGNED_TO" NUMBER(*,0), "FOLLOW_UP_"
"CODE" NUMBER(*,0), "COMMENTS" VARCHAR2(255), "DATE_ADVISED" DATE) PCTFREE "
"10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FRE"
"ELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "RETURN_REASON" ("RETURN_REASON_CODE" NUMBER(10, 0) NOT NULL E"
"NABLE, "REASON_DESCRIPTION_EN" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCR"
"IPTION_FR" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_DE" VARCHAR2("
"150) NOT NULL ENABLE, "REASON_DESCRIPTION_NL" VARCHAR2(150) NOT NULL ENABLE"
", "REASON_DESCRIPTION_JA" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTIO"
"N_SC" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_KO" VARCHAR2(150) "
"NOT NULL ENABLE, "REASON_DESCRIPTION_CS" VARCHAR2(150) NOT NULL ENABLE, "RE"
"ASON_DESCRIPTION_HU" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_PT""
" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_TC" VARCHAR2(150) NOT N"
"ULL ENABLE, "REASON_DESCRIPTION_DA" VARCHAR2(150) NOT NULL ENABLE, "REASON_"
"DESCRIPTION_EL" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_FI" VARC"
"HAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_IT" VARCHAR2(150) NOT NULL E"
"NABLE, "REASON_DESCRIPTION_NO" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCR"
"IPTION_PL" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_RU" VARCHAR2("
"150) NOT NULL ENABLE, "REASON_DESCRIPTION_SV" VARCHAR2(150) NOT NULL ENABLE"
", "REASON_DESCRIPTION_ES" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTIO"
"N_TH" VARCHAR2(150) NOT NULL ENABLE, "REASON_DESCRIPTION_MS" VARCHAR2(150),"
" "REASON_DESCRIPTION_ID" VARCHAR2(150)) PCTFREE 10 PCTUSED 40 INITRANS 1 M"
"AXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE"
" "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "SALES_BRANCH" ("SALES_BRANCH_CODE" NUMBER(10, 0) NOT NULL ENA"
"BLE, "ADDRESS1" VARCHAR2(50) NOT NULL ENABLE, "ADDRESS1_MB" VARCHAR2(50) NO"
"T NULL ENABLE, "ADDRESS2" VARCHAR2(50), "ADDRESS2_MB" VARCHAR2(50), "CITY" "
"VARCHAR2(40) NOT NULL ENABLE, "CITY_MB" VARCHAR2(40) NOT NULL ENABLE, "REGI"
"ON" VARCHAR2(50), "REGION_MB" VARCHAR2(50), "POSTAL_ZONE" VARCHAR2(10) NOT "
"NULL ENABLE, "COUNTRY_CODE" NUMBER(10, 0) NOT NULL ENABLE) PCTFREE 10 PCTU"
"SED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST G"
"ROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "SALES_STAFF" ("SALES_STAFF_CODE" NUMBER(10, 0) NOT NULL ENABL"
"E, "FIRST_NAME" VARCHAR2(25) NOT NULL ENABLE, "FIRST_NAME_MB" VARCHAR2(25) "
"NOT NULL ENABLE, "LAST_NAME" VARCHAR2(30) NOT NULL ENABLE, "LAST_NAME_MB" V"
"ARCHAR2(30) NOT NULL ENABLE, "POSITION_EN" VARCHAR2(140) NOT NULL ENABLE, ""
"POSITION_FR" VARCHAR2(140) NOT NULL ENABLE, "POSITION_DE" VARCHAR2(140) NOT"
" NULL ENABLE, "POSITION_NL" VARCHAR2(140) NOT NULL ENABLE, "POSITION_JA" VA"
"RCHAR2(140) NOT NULL ENABLE, "POSITION_SC" VARCHAR2(140) NOT NULL ENABLE, ""
"POSITION_KO" VARCHAR2(140) NOT NULL ENABLE, "POSITION_CS" VARCHAR2(140) NOT"
" NULL ENABLE, "POSITION_HU" VARCHAR2(140) NOT NULL ENABLE, "POSITION_PT" VA"
"RCHAR2(140) NOT NULL ENABLE, "POSITION_TC" VARCHAR2(140) NOT NULL ENABLE, ""
"POSITION_DA" VARCHAR2(140) NOT NULL ENABLE, "POSITION_EL" VARCHAR2(140) NOT"
" NULL ENABLE, "POSITION_FI" VARCHAR2(140) NOT NULL ENABLE, "POSITION_IT" VA"
"RCHAR2(140) NOT NULL ENABLE, "POSITION_NO" VARCHAR2(140) NOT NULL ENABLE, ""
"POSITION_PL" VARCHAR2(140) NOT NULL ENABLE, "POSITION_RU" VARCHAR2(140) NOT"
" NULL ENABLE, "POSITION_SV" VARCHAR2(140) NOT NULL ENABLE, "POSITION_ES" VA"
"RCHAR2(140) NOT NULL ENABLE, "POSITION_TH" VARCHAR2(140) NOT NULL ENABLE, ""
"POSITION_MS" VARCHAR2(140), "POSITION_ID" VARCHAR2(140), "WORK_PHONE" VARCH"
"AR2(20) NOT NULL ENABLE, "EXTENSION" VARCHAR2(6), "FAX" VARCHAR2(20) NOT NU"
"LL ENABLE, "EMAIL" VARCHAR2(50) NOT NULL ENABLE, "DATE_HIRED" DATE NOT NULL"
" ENABLE, "SALES_BRANCH_CODE" NUMBER(10, 0) NOT NULL ENABLE, "MANAGER_CODE" "
"NUMBER(10, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
"55 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "GOSL" L"
"OGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "SALES_TARGET" ("SALES_STAFF_CODE" NUMBER(10, 0) NOT NULL ENAB"
"LE, "SALES_YEAR" NUMBER(10, 0) NOT NULL ENABLE, "SALES_PERIOD" NUMBER(10, 0"
") NOT NULL ENABLE, "RETAILER_NAME" VARCHAR2(50) NOT NULL ENABLE, "PRODUCT_N"
"UMBER" NUMBER(10, 0) NOT NULL ENABLE, "SALES_TARGET" FLOAT(126) NOT NULL EN"
"ABLE, "RETAILER_CODE" NUMBER(10, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40"
" INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS "
"1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "TIME_DIMENSION" ("DAY_KEY" NUMBER(10, 0) NOT NULL ENABLE, "DA"
"Y_DATE" DATE NOT NULL ENABLE, "MONTH_KEY" NUMBER(10, 0) NOT NULL ENABLE, "C"
"URRENT_MONTH" NUMBER(3, 0) NOT NULL ENABLE, "QUARTER_KEY" NUMBER(10, 0) NOT"
" NULL ENABLE, "CURRENT_QUARTER" NUMBER(3, 0) NOT NULL ENABLE, "CURRENT_YEAR"
"" NUMBER(5, 0) NOT NULL ENABLE, "DAY_OF_WEEK" NUMBER(3, 0) NOT NULL ENABLE,"
" "DAY_OF_MONTH" NUMBER(3, 0) NOT NULL ENABLE, "DAYS_IN_MONTH" NUMBER(3, 0) "
"NOT NULL ENABLE, "DAY_OF_YEAR" NUMBER(5, 0) NOT NULL ENABLE, "WEEK_OF_MONTH"
"" NUMBER(3, 0) NOT NULL ENABLE, "WEEK_OF_QUARTER" NUMBER(3, 0) NOT NULL ENA"
"BLE, "WEEK_OF_YEAR" NUMBER(3, 0) NOT NULL ENABLE, "WEEKDAY_EN" VARCHAR2(120"
") NOT NULL ENABLE, "WEEKDAY_FR" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_DE""
" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_NL" VARCHAR2(120) NOT NULL ENABLE,"
" "WEEKDAY_JA" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_CS" VARCHAR2(120) NOT"
" NULL ENABLE, "WEEKDAY_HU" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_KO" VARC"
"HAR2(120) NOT NULL ENABLE, "WEEKDAY_PT" VARCHAR2(120) NOT NULL ENABLE, "WEE"
"KDAY_SC" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_TC" VARCHAR2(120) NOT NULL"
" ENABLE, "WEEKDAY_DA" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_EL" VARCHAR2("
"120) NOT NULL ENABLE, "WEEKDAY_FI" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_"
"IT" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_NO" VARCHAR2(120) NOT NULL ENAB"
"LE, "WEEKDAY_PL" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_RU" VARCHAR2(120) "
"NOT NULL ENABLE, "WEEKDAY_SV" VARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_ES" V"
"ARCHAR2(120) NOT NULL ENABLE, "WEEKDAY_TH" VARCHAR2(120) NOT NULL ENABLE, ""
"WEEKDAY_MS" VARCHAR2(120), "WEEKDAY_ID" VARCHAR2(120), "MONTH_EN" VARCHAR2("
"125) NOT NULL ENABLE, "MONTH_FR" VARCHAR2(125) NOT NULL ENABLE, "MONTH_DE" "
"VARCHAR2(125) NOT NULL ENABLE, "MONTH_NL" VARCHAR2(125) NOT NULL ENABLE, "M"
"ONTH_JA" VARCHAR2(125) NOT NULL ENABLE, "MONTH_CS" VARCHAR2(125) NOT NULL E"
"NABLE, "MONTH_HU" VARCHAR2(125) NOT NULL ENABLE, "MONTH_KO" VARCHAR2(125) N"
"OT NULL ENABLE, "MONTH_PT" VARCHAR2(125) NOT NULL ENABLE, "MONTH_SC" VARCHA"
"R2(125) NOT NULL ENABLE, "MONTH_TC" VARCHAR2(125) NOT NULL ENABLE, "MONTH_D"
"A" VARCHAR2(125) NOT NULL ENABLE, "MONTH_EL" VARCHAR2(125) NOT NULL ENABLE,"
" "MONTH_FI" VARCHAR2(125) NOT NULL ENABLE, "MONTH_IT" VARCHAR2(125) NOT NUL"
"L ENABLE, "MONTH_NO" VARCHAR2(125) NOT NULL ENABLE, "MONTH_PL" VARCHAR2(125"
") NOT NULL ENABLE, "MONTH_RU" VARCHAR2(125) NOT NULL ENABLE, "MONTH_SV" VAR"
"CHAR2(125) NOT NULL ENABLE, "MONTH_ES" VARCHAR2(125) NOT NULL ENABLE, "MONT"
"H_TH" VARCHAR2(125) NOT NULL ENABLE, "MONTH_MS" VARCHAR2(125), "MONTH_ID" V"
"ARCHAR2(125)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIA"
"L 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "GOSL" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 2248:
"ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = PLSQL"
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00017: following statement failed with ORACLE error 2248:
"ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = NONE"
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
Import terminated successfully with warnings.
Re: How to load cognos dump into Oracle [message #338030 is a reply to message #338029] Sat, 02 August 2008 10:43 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above


>I was trying to import a cognos dump into Oracle9i.
Why do you think this will succeed?

does TABLESPACE "GOSL" exist within your database?
Re: How to load cognos dump into Oracle [message #338037 is a reply to message #338029] Sat, 02 August 2008 12:06 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
"_LOAD_WITHOUT_COMPILE"

I doubt this parameter exists, it seems Oracle also does not know it.

Regards
Michel
Previous Topic: How to import the table structure to other schema?..
Next Topic: Error during Import
Goto Forum:
  


Current Time: Fri Dec 09 19:16:34 CST 2016

Total time taken to generate the page: 0.08550 seconds