Boa tarde a todos! Estou eu aqui novamente. Bom , se for possível, preciso e uma orientação de como faço para converter o dump 9i para 10g ou se tem outra forma de converter meus para 10g. Se alguém tiver um passo a passo. Me descupem, mas sou principiante e estou precisando dessa mão.
Obrigado.
Conversão de dump 9i para 10g...
-
- Rank: Analista Júnior
- Mensagens: 73
- Registrado em: Qui, 21 Set 2006 10:13 am
- Localização: sp
-
- Rank: Analista Júnior
- Mensagens: 73
- Registrado em: Qui, 21 Set 2006 10:13 am
- Localização: sp
Me desculpem , estou na sala errada.
-
- Moderador
- Mensagens: 2016
- Registrado em: Qua, 12 Jan 2005 3:25 pm
- Localização: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Boa noite,
Tópico movido para o grupo de DBA's.
Tópico movido para o grupo de DBA's.
-
- Rank: Analista Júnior
- Mensagens: 73
- Registrado em: Qui, 21 Set 2006 10:13 am
- Localização: sp
Tenho feito o import. Parece que vai tudo bem.
Quando olho o log do import, em determinada parte, ele apresenta o seguinte erro:
Obrigado pela ajuda.
Quando olho o log do import, em determinada parte, ele apresenta o seguinte erro:
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPOPARCELA" ON "XTIPOPARCELA" ("COD_TIPO_PARC" ) "
"PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELI"
"ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPOPARCELA"',NULL,NULL,NULL,24"
",1,24,1,1,1,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPOPARCELA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPOPARCELA" ADD CONSTRAINT "PKXTIPOPARCELA" PRIMARY KEY ("C"
"OD_TIPO_PARC") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITI"
"AL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_"
"INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XTIPOPARCELARECEITA" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPOPARCELARECEITA" ON "XTIPOPARCELARECEITA" ("COD_"
"TIP_PARC" , "COD_TIP_RECEITA" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE"
"(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPAC"
"E "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPOPARCELARECEITA"',NULL,NULL,"
"NULL,0,0,0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPOPARCELARECEITA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPOPARCELARECEITA" ADD CONSTRAINT "PKXTIPOPARCELARECEITA" P"
"RIMARY KEY ("COD_TIP_PARC", "COD_TIP_RECEITA") USING INDEX PCTFREE 10 INITR"
"ANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFF"
"ER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XTIPOPERIODO" 3 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPOPERIODO" ON "XTIPOPERIODO" ("COD_TIPO_PER" ) P"
"CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIS"
"T GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPOPERIODO"',NULL,NULL,NULL,3,"
"1,3,1,1,1,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPOPERIODO" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPOPERIODO" ADD CONSTRAINT "PKXTIPOPERIODO" PRIMARY KEY ("C"
"OD_TIPO_PER") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIA"
"L 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_I"
"NDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XTIPOPESSOA" 5 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPOPESSOA" ON "XTIPOPESSOA" ("CODTIPOPESSOA" ) PC"
"TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPOPESSOA"',NULL,NULL,NULL,5,1"
",5,1,1,1,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPOPESSOA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPOPESSOA" ADD CONSTRAINT "PKXTIPOPESSOA" PRIMARY KEY ("COD"
"TIPOPESSOA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_IN"
"DICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XTIPORECEITA" 11 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPORECEITA" ON "XTIPORECEITA" ("COD_TIP_RECEITA" )"
" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREE"
"LIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPORECEITA"',NULL,NULL,NULL,11"
",1,11,1,1,1,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPORECEITA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPORECEITA" ADD CONSTRAINT "PKXTIPORECEITA" PRIMARY KEY ("C"
"OD_TIP_RECEITA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INI"
"TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "R"
"M_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XTIPORECEITATABELAOPCIONAL" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPORECEITATABELAOPCIONAL" ON "XTIPORECEITATABELAOP"
"CIONAL" ("CODCOLIGADA" , "CODTIPORECEITA" ) PCTFREE 10 INITRANS 2 MAXTRANS"
" 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAUL"
"T) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPORECEITATABELAOPCIONAL"',NUL"
"L,NULL,NULL,0,0,0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPORECEITATABELAOPCIONAL" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPORECEITATABELAOPCIONAL" ADD CONSTRAINT "PKXTIPORECEITATAB"
"ELAOPCIONAL" PRIMARY KEY ("CODCOLIGADA", "CODTIPORECEITA") USING INDEX PCTF"
"REE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST G"
"ROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XTIPOVENDEDOR" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXTIPOVENDEDOR" ON "XTIPOVENDEDOR" ("COD_TIPO_VEND" )"
" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREE"
"LIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXTIPOVENDEDOR"',NULL,NULL,NULL,0"
",0,0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXTIPOVENDEDOR" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XTIPOVENDEDOR" ADD CONSTRAINT "PKXTIPOVENDEDOR" PRIMARY KEY ("
""COD_TIPO_VEND") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INI"
"TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "R"
"M_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XUNIDADE" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXUNIDADE" ON "XUNIDADE" ("COD_PESS_EMPR" , "NUM_UNID"
"" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXUNIDADE"',NULL,NULL,NULL,0,0,0,"
"0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXUNIDADE" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XUNIDADE" ADD CONSTRAINT "PKXUNIDADE" PRIMARY KEY ("COD_PESS_"
"EMPR", "NUM_UNID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(I"
"NITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "
""RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XUNIDADECOMPL" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXUNIDADECOMPL" ON "XUNIDADECOMPL" ("COD_PESS_EMPR" ,"
" "NUM_UNID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FRE"
"ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOG"
"GING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXUNIDADECOMPL"',NULL,NULL,NULL,0"
",0,0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXUNIDADECOMPL" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XUNIDADECOMPL" ADD CONSTRAINT "PKXUNIDADECOMPL" PRIMARY KEY ("
""COD_PESS_EMPR", "NUM_UNID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255"
" STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) T"
"ABLESPACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XUSUARIO" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXUSUARIO" ON "XUSUARIO" ("COD_USU" ) PCTFREE 10 INI"
"TRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BU"
"FFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXUSUARIO"',NULL,NULL,NULL,0,0,0,"
"0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXUSUARIO" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XUSUARIO" ADD CONSTRAINT "PKXUSUARIO" PRIMARY KEY ("COD_USU")"
" USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL"
"ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGI"
"NG ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XVAGA" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXVAGA" ON "XVAGA" ("COD_PESS_EMPR" , "NUM_UNID" , "N"
"UM_SUB_UNID" , "COD_VAGA" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INI"
"TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "R"
"M_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXVAGA"',NULL,NULL,NULL,0,0,0,0,0"
",0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXVAGA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XVAGA" ADD CONSTRAINT "PKXVAGA" PRIMARY KEY ("COD_PESS_EMPR","
" "NUM_UNID", "NUM_SUB_UNID", "COD_VAGA") USING INDEX PCTFREE 10 INITRANS 2 "
"MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
"L DEFAULT) TABLESPACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XVENDA" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXVENDA" ON "XVENDA" ("NUM_VENDA" ) PCTFREE 10 INITR"
"ANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFF"
"ER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXVENDA"',NULL,NULL,NULL,0,0,0,0,"
"0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXVENDA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XVENDA" ADD CONSTRAINT "PKXVENDA" PRIMARY KEY ("NUM_VENDA") U"
"SING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
" ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XVENDACOMPL" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXVENDACOMPL" ON "XVENDACOMPL" ("CODCOLIGADA" , "NUMV"
"ENDA" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS"
" 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXVENDACOMPL"',NULL,NULL,NULL,0,0"
",0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXVENDACOMPL" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XVENDACOMPL" ADD CONSTRAINT "PKXVENDACOMPL" PRIMARY KEY ("COD"
"COLIGADA", "NUMVENDA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORA"
"GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESP"
"ACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XVENDACONT" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXVENDACONT" ON "XVENDACONT" ("NUM_VENDA" , "TIPO_CON"
"T" , "mês_ANO" , "NUM_SEQ" , "CODCOLIGADA" ) PCTFREE 10 INITRANS 2 MAXTRAN"
"S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXVENDACONT"',NULL,NULL,NULL,0,0,"
"0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXVENDACONT" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XVENDACONT" ADD CONSTRAINT "PKXVENDACONT" PRIMARY KEY ("NUM_V"
"ENDA", "TIPO_CONT", "mês_ANO", "NUM_SEQ", "CODCOLIGADA") USING INDEX PCTFRE"
"E 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GRO"
"UPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XVENDACONTA" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXVENDACONTA" ON "XVENDACONTA" ("IDVENDACONTA" , "COD"
"COLIGADA" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL"
"ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGI"
"NG"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXVENDACONTA"',NULL,NULL,NULL,0,0"
",0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXVENDACONTA" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XVENDACONTA" ADD CONSTRAINT "PKXVENDACONTA" PRIMARY KEY ("IDV"
"ENDACONTA", "CODCOLIGADA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 S"
"TORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TAB"
"LESPACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "XVENDAFIADOR" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PKXVENDAFIADOR" ON "XVENDAFIADOR" ("NUMVENDA" , "CODFI"
"ADOR" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS"
" 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PKXVENDAFIADOR"',NULL,NULL,NULL,0,"
"0,0,0,0,0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PKXVENDAFIADOR" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "XVENDAFIADOR" ADD CONSTRAINT "PKXVENDAFIADOR" PRIMARY KEY ("N"
"UMVENDA", "CODFIADOR") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORA"
"GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESP"
"ACE "RM_INDICES" LOGGING ENABLE "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "ZCCDEPARAFLAN" 1 rows imported
. . importing table "ZCCDEPARAORCA" 1 rows imported
. . importing table "ZCCDEPARATMOV" 1 rows imported
. . importing table "ZLOG" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PK_ZLOG" ON "ZLOG" ("IDLOG" ) PCTFREE 10 INITRANS 2 M"
"AXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL"
" DEFAULT) TABLESPACE "RM_INDICES" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_ZLOG"',NULL,NULL,NULL,0,0,0,0,0"
",0,0,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "RM"."PK_ZLOG" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "ZLOG" ADD CONSTRAINT "PK_ZLOG" PRIMARY KEY ("IDLOG") USING IN"
"DEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FR"
"EELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING ENABLE"
" "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace RM_INDICES
. . importing table "ZLOGCAMPOS" 0 rows imported
. . importing table "ZLOGPARAMS" 1 rows imported
. . importing table "ZLOGPROCESSOS" 65 rows imported
. . importing table "ZRMCFILIAL" 13 rows imported
. . importing table "ZRMCPARAM" 1 rows imported
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "RM"."TFGRPPONTOVENDA" ("COD"
"COLIGADA","GRUPO","DESCRICAO","DIRETORIOENTRADA","DIRETORIOSAIDA","URLRETOR"
"NO","CODFILIAL","CODLOC","DTHRATUALIZACAO") AS "
"SELECT CODCOLIGADA,GRUPO,DESCRICAO,DIRETORIOENTRADA,DIRETORIOSAIDA,URLRETO"
"RNO,CODFILIAL,CODLOC, SYSDATE AS DTHRATUALIZACAO"
"FROM TGRPPONTOVENDA"
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "RM"."VWPPPLOTACAO" ("CODCOL"
"IGADA","CHAPA","DATAINICIAL","DATAFINAL","CNPJCEI","SETOR","CARGO","FUNCAO""
","CBO","GFIP") AS "
"(SELECT DATAS.CODCOLIGADA, DATAS.CHAPA, DATAS.DTINICIO DATAINICIAL,DATAS.DT"
"FIM DATAFINAL ,"
" DECODE (DATAS.TOMADOR ,NULL, NVL(PSECAO.CEI, PSECAO.CGC), NVL(FCFO"
".CEI, FCFO.CGCCFO)) CNPJCEI,"
" PSECAO.DESCRICAO SETOR, PFUNCAO.NOME CARGO,"
" CHEFIA(DATAS.CODCOLIGADA, DATAS.CHAPA,DATAS.DTINICIO) FUNCAO,"
" VIEWPFUNCAO.CBO,GFIP(DATAS.CODCOLIGADA, DATAS.CHAPA,DATAS.DTINICIO,DATAS"
".TOMADOR) GFIP"
"FROM (SELECT X.CODCOLIGADA, X.CHAPA, TO_DATE(X.DTINICIO , 'MM/DD/YYYY') "
"DTINICIO, TO_DATE(Y.DTFINAL, 'MM/DD/YYYY') DTFIM,X.TOMADOR"
" FROM VWPPPDATASINICIAIS X , VWPPPDATASFINAIS Y"
" WHERE X.CODCOLIGADA = Y.CODCOLIGADA (+) AND"
" X.CHAPA = Y.CHAPA (+) AND"
" (X.TOMADOR = Y.TOMADOR OR (X.TOMADOR IS NULL AND Y.TOMADOR IS NULL)"
") AND"
" TO_DATE (Y.DTFINAL , 'MM/DD/YYYY')= (SELECT MIN(Z.DTFINAL) FROM V"
"WPPPDATASFINAIS Z"
" "
" WHERE Z.CODCOLIGADA = X.CODCOLIGADA AND"
" "
" Z.CHAPA = X.CHAPA AND"
" "
" (X.TOMADOR = Z.TOMADOR OR (X.TOMADOR IS NULL AND Z.TOMADOR IS NULL)) AND"
" "
" Z.DTFINAL >= X.DTINICIO)"
" UNION"
" SELECT X.CODCOLIGADA, X.CHAPA, TO_DATE(MAX(DTINICIO),'MM/DD/YYYY'), TO"
"_DATE(NULL, 'MM/DD/YYYY') DTFIM, TOMADOR"
" FROM VWPPPDATASINICIAIS X, PFUNC"
" WHERE PFUNC.CODCOLIGADA = X.CODCOLIGADA AND"
" PFUNC.CHAPA = X.CHAPA AND"
" (PFUNC.DATADEMISSAO IS NULL) AND X.TOMADOR IS NULL AND"
" NOT EXISTS (SELECT 1 FROM VWPPPDATASFINAIS Y"
" WHERE X.CODCOLIGADA = Y.CODCOLIGADA AND"
" X.CHAPA = Y.CHAPA AND"
" Y.DTFINAL > X.DTINICIO) AND X.DTINICIO IS NOT "
"NULL"
" GROUP BY X.CODCOLIGADA, X.CHAPA, X.TOMADOR"
" UNION"
" SELECT X.CODCOLIGADA, X.CHAPA, TO_DATE(MAX(DTINICIO),'MM/DD/YYYY'), TO"
"_DATE(NULL, 'MM/DD/YYYY') DTFIM, TOMADOR"
" FROM VWPPPDATASINICIAIS X , VTOMADORSERVICOVINC"
" WHERE X.CODCOLIGADA = VTOMADORSERVICOVINC.CODCOLIGADA AND"
" X.CHAPA= VTOMADORSERVICOVINC.CHAPA AND"
" X.TOMADOR= VTOMADORSERVICOVINC.CODCFO AND"
" VTOMADORSERVICOVINC.DATAFINAL IS NULL"
" GROUP BY X.CODCOLIGADA, X.CHAPA, X.TOMADOR) DATAS,FCFO ,"
" PFHSTSEC, PFHSTFCO, PSECAO, PFUNCAO,"
" (SELECT CODCOLIGADA, CODIGO CODFUNCAO, TO_DATE('01/01/1900','MM/DD/YYY"
"Y') DTINICIO, '0'||CBO CBO FROM PFUNCAO"
" UNION"
" SELECT CODCOLIGADA, CODIGO CODFUNCAO, TO_DATE('01/01/2002','MM/DD/YYY"
"Y') DTINICIO, CBO2002 CBO FROM PFUNCAO) VIEWPFUNCAO"
"WHERE DATAS.CODCOLIGADA = PFHSTSEC.CODCOLIGADA AND"
" DATAS.CHAPA = PFHSTSEC.CHAPA AND"
" PFHSTSEC.DTMUDANCA = (SELECT MAX (DTMUDANCA)"
" FROM PFHSTSEC"
" WHERE PFHSTSEC.CODCOLIGADA = DATAS.CODCOLIGADA "
"AND"
" PFHSTSEC.CHAPA = DATAS.CHAPA AND DTMUDANC"
"A <= DATAS.DTINICIO) AND"
" PSECAO.CODCOLIGADA = PFHSTSEC.CODCOLIGADA AND PSECAO.CODIGO = PFHSTSE"
"C.CODSECAO AND"
" DATAS.CODCOLIGADA = PFHSTFCO.CODCOLIGADA AND"
" DATAS.CHAPA = PFHSTFCO.CHAPA AND"
" PFHSTFCO.DTMUDANCA = (SELECT MAX (DTMUDANCA)"
" FROM PFHSTFCO"
" WHERE PFHSTFCO.CODCOLIGADA = DATAS.CODCOLIGADA "
"AND"
" PFHSTFCO.CHAPA = DATAS.CHAPA AND PFHSTFCO"
".DTMUDANCA <= DATAS.DTINICIO) AND"
" PFUNCAO.CODCOLIGADA = PFHSTFCO.CODCOLIGADA AND PFUNCAO.CODIGO = PFHST"
"FCO.CODFUNCAO AND"
" VIEWPFUNCAO.CODCOLIGADA = DATAS.CODCOLIGADA AND VIEWPFUNCAO.CODFUNCAO"
" = PFHSTFCO.CODFUNCAO AND"
" VIEWPFUNCAO.DTINICIO = (SELECT MAX (DTINICIO)"
" FROM (SELECT CODCOLIGADA, CODIGO CODFUNCAO, T"
"O_DATE('01/01/1900','MM/DD/YYYY') DTINICIO, CBO FROM PFUNCAO"
" UNION"
" SELECT CODCOLIGADA, CODIGO CODFUNCAO, T"
"O_DATE('01/01/2002','MM/DD/YYYY') DTINICIO, CBO2002 FROM PFUNCAO) VIEWPFUN"
"CAO"
" WHERE VIEWPFUNCAO.CODCOLIGADA = DATAS.CODCOLI"
"GADA AND"
" VIEWPFUNCAO.CODFUNCAO = PFHSTFCO.CODFUN"
"CAO AND VIEWPFUNCAO.DTINICIO <= DATAS.DTINICIO) AND"
" (FCFO.CODCOLIGADA (+) = DATAS.CODCOLIGADA AND"
" FCFO.CODCFO (+) = DATAS.TOMADOR) )"
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XVENDACONT" ADD CONSTRAINT "FKXVENDACONT_XVENDA" FOREIGN KEY ("
""NUM_VENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XREGRACOMPONENTEVENDA" ADD CONSTRAINT "FKXREGRACOMPVENDA_XTIPO"
"PERIODO" FOREIGN KEY ("COD_TIPO_PER") REFERENCES "XTIPOPERIODO" ("COD_TIPO_"
"PER") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XREGRAVENDATIPOPARCELA" ADD CONSTRAINT "FKXREGRAVENDATIPOPARCE"
"LA_XVEND" FOREIGN KEY ("NUMVENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE"
" NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XREGRAVENDATIPOPARCELA" ADD CONSTRAINT "FKXREGRAVENDATPPARC_XT"
"PPAR" FOREIGN KEY ("CODTIPOPARCELA") REFERENCES "XTIPOPARCELA" ("COD_TIPO_P"
"ARC") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XITEMTABELAPRECOUNIDADE" ADD CONSTRAINT "FKXITEMTABPRECOUNID_X"
"UNIDADE" FOREIGN KEY ("COD_PESS_EMPR", "NUM_UNID") REFERENCES "XUNIDADE" (""
"COD_PESS_EMPR", "NUM_UNID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XRESUMOREFINANCIAMENTO" ADD CONSTRAINT "FKXRESUMOREFINANCIAMEN"
"T_XVENDA" FOREIGN KEY ("NUMVENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE"
" NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XRESUMOREFINANCIAMENTO" ADD CONSTRAINT "FKXRESUMOREFINAN_XTIPO"
"PARCELA" FOREIGN KEY ("CODTIPOPARCELA") REFERENCES "XTIPOPARCELA" ("COD_TIP"
"O_PARC") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XPARAMETROSTIPOPARCELA" ADD CONSTRAINT "FKXPARAMTIPOPARC_XTIPO"
"PARCELA" FOREIGN KEY ("COD_TIPO_PARC") REFERENCES "XTIPOPARCELA" ("COD_TIPO"
"_PARC") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XRAZAO" ADD CONSTRAINT "FKXRAZAO_XUNIDADE" FOREIGN KEY ("COD_P"
"ESS_EMPR", "NUM_UNID") REFERENCES "XUNIDADE" ("COD_PESS_EMPR", "NUM_UNID") "
"ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XUNIDADECOMPL" ADD CONSTRAINT "FKXUNIDADECOMPL_XUNIDADE" FOREI"
"GN KEY ("COD_PESS_EMPR", "NUM_UNID") REFERENCES "XUNIDADE" ("COD_PESS_EMPR""
", "NUM_UNID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XPARCELAPAGAMENTO" ADD CONSTRAINT "FKXPARCELAPAGTO_XTIPOPARCEL"
"A" FOREIGN KEY ("COD_TIPO_PARC") REFERENCES "XTIPOPARCELA" ("COD_TIPO_PARC""
") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XPARCELAPAGAMENTO" ADD CONSTRAINT "FKXPARCELAPAGTO_XVENDA" FOR"
"EIGN KEY ("NUM_VENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XITEMVENDA" ADD CONSTRAINT "FKXITEMVENDA_XVENDA" FOREIGN KEY ("
""NUM_VENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XCOMISSAOPARCELAPGTO" ADD CONSTRAINT "FKXCOMISSAOPARCELAPGTO_X"
"VENDA" FOREIGN KEY ("NUM_VENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE N"
"OVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XVENDA" ADD CONSTRAINT "FKXVENDA_XVENDA" FOREIGN KEY ("NUMVEND"
"AORIGINALEXTRACONTR") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XVENDACONTA" ADD CONSTRAINT "FKXVENDACONTA_XVENDA" FOREIGN KEY"
" ("NUMVENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XHISTORICOVENDA" ADD CONSTRAINT "FKXHISTORICOVENDA_XVENDA" FOR"
"EIGN KEY ("NUM_VENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XSUBUNIDADE" ADD CONSTRAINT "FKXSUBUNIDADE_XUNIDADE" FOREIGN K"
"EY ("COD_PESS_EMPR", "NUM_UNID") REFERENCES "XUNIDADE" ("COD_PESS_EMPR", "N"
"UM_UNID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XVENDAFIADOR" ADD CONSTRAINT "FKXVENDA_XVENDAFIADOR" FOREIGN K"
"EY ("NUMVENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XVENDACOMPL" ADD CONSTRAINT "FKXVENDACOMPL_XVENDA" FOREIGN KEY"
" ("NUMVENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XPARCELAPROPOSTA" ADD CONSTRAINT "FKXPARCELAPROPOSTA_XTIPOPARC"
"EL" FOREIGN KEY ("COD_TIPO_PARC") REFERENCES "XTIPOPARCELA" ("COD_TIPO_PARC"
"") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XTIPORECEITATABELAOPCIONAL" ADD CONSTRAINT "FKXTPRECTABOPCIONA"
"L_XTPRECEITA" FOREIGN KEY ("CODTIPORECEITA") REFERENCES "XTIPORECEITA" ("CO"
"D_TIP_RECEITA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XRESUMODISTRATOS" ADD CONSTRAINT "FKXRESUMODISTRATOS_XVENDA" F"
"OREIGN KEY ("NUMVENDA") REFERENCES "XVENDA" ("NUM_VENDA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XPESSOA" ADD CONSTRAINT "FKPESSOA_XTIPOPESSOA" FOREIGN KEY ("C"
"ODTIPOPESSOA") REFERENCES "XTIPOPESSOA" ("CODTIPOPESSOA") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XPESSOAVENDEDOR" ADD CONSTRAINT "FKXPESSOAVENDEDO_XTIPOVENDEDO"
"R" FOREIGN KEY ("COD_TIPO_VEND") REFERENCES "XTIPOVENDEDOR" ("COD_TIPO_VEND"
"") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XMODALIDADETIPOPARCELA" ADD CONSTRAINT "FKXMODTIPOPARC_TIPOPAR"
"C" FOREIGN KEY ("CODTIPOPARCELA") REFERENCES "XTIPOPARCELA" ("COD_TIPO_PARC"
"") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XBEN" ADD CONSTRAINT "FKXBEN_XUNIDADE" FOREIGN KEY ("COD_PESS_"
"EMPR", "NUM_UNID") REFERENCES "XUNIDADE" ("COD_PESS_EMPR", "NUM_UNID") ENAB"
"LE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "XITEMPROPOSTA" ADD CONSTRAINT "FKXITEMPROPOSTA_XUNIDADE" FOREI"
"GN KEY ("COD_PESS_EMPR", "NUM_UNID") REFERENCES "XUNIDADE" ("COD_PESS_EMPR""
", "NUM_UNID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00041: Warning: object created with compilation warnings
"CRE
-
- Rank: Analista Júnior
- Mensagens: 73
- Registrado em: Qui, 21 Set 2006 10:13 am
- Localização: sp
Valeu Andeson.... o problema era isso mesmo. Obrigado.
-
- Informação
-
Quem está online
Usuários navegando neste fórum: Nenhum usuário registrado e 13 visitantes