我公司的oracle版本是9.2,从公司的机器上通过exp导出的表和存储过程,在家里的oracle9.0上无法成功导入,提示logging noexpress的问题,请问这是怎么回事,和oracle版本有关系吗?
解决方案 »
- 这个函数是什么意思 为什么里面还要有1 这是什么意思SUM(CASE WHEN FLDEX1 = '2' THEN 1 END )
- win2003server中安装oracle10g,通过系统服务启动数据库有问题
- 关于这套书 Oracle Developer/2000开发应用系统
- 触发器只更新第一条记录
- 高分求助:ORA-00600: internal error code错,怎么处理?
- 这样的要求怎么去实现呢?
- 有没有方法查看自定义的异常在哪个Trigger中?
- 哪儿有数据库操作时各种错误代号的介绍呀,详细一点的
- cisoc交换机(2950—24)有关VLAN的设置???
- 高分求解:oracle 12c 误删了一个表,如何通过rman备份策略和对应生成的备份文件恢复数据?
- 请问oracle.jdbc.driver.OracleConnection怎样才能新建一个OracleConnection?
- oracle9i透明网关技术
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'TESTER', export_db_nam"
"e=>'UTF8.ORA92.APPEON.NET', inst_scn=>'33079197');"
"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 "APPEON27_DYNAMICSQL3" ("V_ID" VARCHAR2(15) NOT NULL ENABLE, ""
"V_NAME" VARCHAR2(20) NOT NULL ENABLE, "N_SALARY" NUMBER(20, 3), "C_SEX" CHA"
"R(1)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 "
"FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" 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 "BORROWER" ("BORR_SK_SEQ" NUMBER(10, 0) NOT NULL ENABLE, "BORR"
"_REV_NUM" NUMBER(10, 0) NOT NULL ENABLE, "PRIMARY_BORR_FLAG" CHAR(1) NOT NU"
"LL ENABLE, "BORR_TYPE" CHAR(4) NOT NULL ENABLE, "BORROWER_PEER_GROUP_SK_SEQ"
"" NUMBER(10, 0) NOT NULL ENABLE, "ADEQUACY_OF_ASSETS" VARCHAR2(10) NOT NULL"
" ENABLE, "ADEQUACY_OF_EFF_INCOME" VARCHAR2(10) NOT NULL ENABLE, "AGE" VARCH"
"AR2(10) NOT NULL ENABLE, "CAIVR_NUM" VARCHAR2(10) NOT NULL ENABLE, "CORPORA"
"TE_ID" VARCHAR2(10) NOT NULL ENABLE, "CREDIT_ATTRIB" VARCHAR2(10) NOT NULL "
"ENABLE, "CREDIT_RATING" VARCHAR2(10) NOT NULL ENABLE, "DATE_OF_BIRTH" VARCH"
"AR2(10) NOT NULL ENABLE, "FIRST_TIME_BUYER_FLAG" VARCHAR2(10) NOT NULL ENAB"
"LE, "GENDER_TYPE" VARCHAR2(10) NOT NULL ENABLE, "MARITAL_STATUS_TYPE" VARCH"
"AR2(10) NOT NULL ENABLE, "FIRST_NAME" VARCHAR2(10) NOT NULL ENABLE, "MIDDLE"
"_NAME" VARCHAR2(10) NOT NULL ENABLE, "NAME" VARCHAR2(10) NOT NULL ENABLE, ""
"LAST_NAME" VARCHAR2(10) NOT NULL ENABLE, "NUM_OF_DEPENDENTS" VARCHAR2(10) N"
"OT NULL ENABLE, "NUM_IN_FAMILY" VARCHAR2(10) NOT NULL ENABLE, "PREFIX" VARC"
"HAR2(10) NOT NULL ENABLE, "RACE_TYPE" VARCHAR2(10) NOT NULL ENABLE, "SALUTA"
"TION_TYPE" VARCHAR2(10) NOT NULL ENABLE, "SERVICE_NUM" VARCHAR2(10) NOT NUL"
"L ENABLE, "SSN" VARCHAR2(10) NOT NULL ENABLE, "STABILITY_OF_EFF_INCOME" VAR"
"CHAR2(10) NOT NULL ENABLE, "SUFFIX" VARCHAR2(10) NOT NULL ENABLE, "TAX_ID_N"
"UM" VARCHAR2(10) NOT NULL ENABLE, "UNDWTR_CRED_RATE_TYPE" VARCHAR2(10) NOT "
"NULL ENABLE, "YEARS_IN_SCHOOL" VARCHAR2(10) NOT NULL ENABLE, "PREQ_INCOME_A"
"MT" VARCHAR2(10) NOT NULL ENABLE, "PREQ_INCOME_GROSS_AMT" VARCHAR2(10) NOT "
"NULL ENABLE, "PREQ_INCOME_PERIOD_TYPE" VARCHAR2(10) NOT NULL ENABLE, "PREQ_"
"EXPENSE_AMT" VARCHAR2(10) NOT NULL ENABLE, "PREQ_EXPENSE_GROSS_AMT" VARCHAR"
"2(10) NOT NULL ENABLE, "PREQ_EXPENSE_PERIOD_TYPE" VARCHAR2(10) NOT NULL ENA"
"BLE, "CASH_ON_HAND" VARCHAR2(10) NOT NULL ENABLE, "RACE_OTHER_DESC" VARCHAR"
"2(10) NOT NULL ENABLE, "DEMOGRAPH_GIVEN_TYPE" VARCHAR2(10) NOT NULL ENABLE,"
" "RELATION_BORR_TYPE" VARCHAR2(10) NOT NULL ENABLE, "RELATION_BORR_SK_SEQ" "
"VARCHAR2(10) NOT NULL ENABLE, "RELATION_BORR_REV_NUM" VARCHAR2(10) NOT NULL"
" ENABLE, "DIVIDEND_INCOME_AMT" VARCHAR2(10) NOT NULL ENABLE, "DIVIDEND_GROS"
"S_AMT" VARCHAR2(10) NOT NULL ENABLE, "DIVIDEND_PERIOD_TYPE" VARCHAR2(10) NO"
"T NULL ENABLE, "TITLE_HOLDER_FLAG" VARCHAR2(10) NOT NULL ENABLE, "BORR_ON_N"
"OTE_FLAG" VARCHAR2(10) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 M"
"AXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE"
" "USERS" 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 "CMV_TEST1" ("ID" CHAR(10) NOT NULL ENABLE, "NAME" CHAR(20), ""
"SEX" CHAR(20), "YEAR" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
"STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOG"
"GING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "MORTGAGE" ("LOAN_NUM" NVARCHAR2(30), "MTG_SK_SEQ" NUMBER(10, "
"0) NOT NULL ENABLE, "MTG_REV_NUM" NUMBER(10, 0), "RETAIL_WHLSALE_TYPE" CHAR"
"(4), "EST_CLOSING_DATE" DATE, "ACTUAL_CLOSING_DATE" DATE, "APPL_REGISTER_DA"
"TE" DATE) PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 655"
"36 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" 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 "STU" ("ID" CHAR(10) NOT NULL ENABLE, "NAME" CHAR(20), "SEX" C"
"HAR(20), "YEAR" DATE, "VALUE" NUMBER(10, 0)) PCTFREE 10 PCTUSED 40 INITRAN"
"S 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLE"
"SPACE "USERS" 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 "TABLE_EX" ("NAME" VARCHAR2(10) NOT NULL ENABLE, "SCORE" NUMBE"
"R(10, 2) NOT NULL ENABLE, "ID" NUMBER(10, 0) NOT NULL ENABLE) PCTFREE 10 P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIS"
"T GROUPS 1) TABLESPACE "USERS" LOGGING NOCOMPRESS"