我有cmd命令导出某个用户中的一张表,出现了错误,求助帮忙指点!
C:\windows\system32>exp netrep/netrep TABLES= SYS_ZB file=d:\1.dmp log=d:\1.log
full=y grants=nExport: Release 10.2.0.1.0 - Production on 星期一 12月 19 15:54:44 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
EXP-00026: 指定了冲突模式
EXP-00000: 导出终止失败netrep是用户,sys_zb是表,请问应该怎么修改呢?
C:\windows\system32>exp netrep/netrep TABLES= SYS_ZB file=d:\1.dmp log=d:\1.log
full=y grants=nExport: Release 10.2.0.1.0 - Production on 星期一 12月 19 15:54:44 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
EXP-00026: 指定了冲突模式
EXP-00000: 导出终止失败netrep是用户,sys_zb是表,请问应该怎么修改呢?
full=y grants=n
导出SCOTT用户下的EMP和DEPT表。
EXP USERID=SCOTT/tiger DIRECT=y TABLE(EMP, DEPT) ROWS=y FILE=C:\expdir\PartTable.dmp log=C:\expdir\PartTabl.log
正在将 NETREP 的对象导入到 CI
MP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "SYS_ZB" ("ZB_GUID" VARCHAR2(32) NOT NULL ENABLE, "TSK_PREFIX""
" VARCHAR2(6), "ZB_NAME" VARCHAR2(50), "ZB_TITLE" VARCHAR2(150), "ZB_ALIAS" "
"VARCHAR2(150), "ZB_TYPE" NUMBER(10, 0), "ZB_SIZE" NUMBER(10, 0), "ZB_PRECIS"
"ION" NUMBER(10, 0), "ZB_DECIMAL" NUMBER(10, 0), "ZB_TABLENAME" VARCHAR2(50)"
", "ZB_FIELDNAME" VARCHAR2(50), "ZB_ISKEY" NUMBER(1, 0), "ZB_KIND" VARCHAR2("
"32), "ZB_UNIQUE" NUMBER(1, 0), "ZB_CANNULL" NUMBER(1, 0), "ZB_REFERENCE" VA"
"RCHAR2(32), "ZB_DEFAULT" VARCHAR2(250), "ZB_CHECK" VARCHAR2(250), "ZB_CALCU"
"LATE" VARCHAR2(250), "DI_GUID" VARCHAR2(32), "ZB_UNIT" VARCHAR2(50), "ZB_CU"
"RRCONVERT" NUMBER(1, 0), "ZB_SUMTYPE" NUMBER(10, 0), "ZB_CHARCASE" NUMBER(1"
"0, 0), "ZB_EDITMASK" VARCHAR2(50), "ZB_SHOWFMT" VARCHAR2(50), "ZB_IMEMODE" "
"NUMBER(10, 0), "ZB_DESCRIPTION" VARCHAR2(1000), "ZB_ORDER" VARCHAR2(10), "Z"
"B_APPLYTYPE" NUMBER(10, 0), "ZB_ISFLOAT" NUMBER(1, 0), "ZB_ISBASE" NUMBER(1"
", 0), "ZB_ISCALCULATE" NUMBER(1, 0), "ZB_HALFCONDI" VARCHAR2(250), "ZB_HALF"
"KIND" NUMBER(10, 0), "PARA_OWNER" VARCHAR2(10), "ZB_ISUNITZB" NUMBER(1, 0),"
" "ZB_QUANTITATIVE" VARCHAR2(20), "ZB_QUCLASS" VARCHAR2(20), "ZB_QUUNIT" VAR"
"CHAR2(20), "ZB_SHORTTITLE" VARCHAR2(150), "ZB_MEMO" VARCHAR2(2000), "ZB_ISC"
"OMMON" NUMBER(*,0), "ZB_REFTASK" VARCHAR2(6), "ZB_REFSCHEME" VARCHAR2(20)) "
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 27262976 FRE"
"ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING "
"NOCOMPRESS"
成功终止导入, 但出现警告。
按照这个方法,有full=y的话就还是报有冲突,但是我导全部表的话加这个没有错误啊?这个full的意思不是全部导出的意思吗?难道导一个表不需要这个了?