Conversão de dump 9i para 10g...

Backup, Recover, Import, Export, Datapump, etc
Responder
fbarros300472
Rank: Analista Júnior
Rank: Analista Júnior
Mensagens: 73
Registrado em: Qui, 21 Set 2006 10:13 am
Localização: sp

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.
fbarros300472
Rank: Analista Júnior
Rank: Analista Júnior
Mensagens: 73
Registrado em: Qui, 21 Set 2006 10:13 am
Localização: sp

Me desculpem , estou na sala errada.
Trevisolli
Moderador
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

Boa noite,

Tópico movido para o grupo de DBA's.
ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Mensagens: 324
Registrado em: Sex, 02 Jun 2006 1:48 pm
Localização: sp
Contato:

Amigo,
importa direto, não precisa converter dump, se der alguma mensagem de erro manda pra gente.
fbarros300472
Rank: Analista Júnior
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:

Selecionar tudo

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
Obrigado pela ajuda.
ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Mensagens: 324
Registrado em: Sex, 02 Jun 2006 1:48 pm
Localização: sp
Contato:

Amigo, parece que está estorando o espaço da sua tablespace, aumenta ela....
fbarros300472
Rank: Analista Júnior
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.
Responder
  • Informação
  • Quem está online

    Usuários navegando neste fórum: Nenhum usuário registrado e 5 visitantes