Assunto: [oracle_br] Migrar BD 9i HPUX para Linux
Ednilson, Bom dia!O Oracle 9i, já se encontra instalado no RedHat?, pois caso
já esteja instalado com a mesma versão e bibliotecas compatíveis de ambos os
SO's o imp da base irá funcionar sem problemas;Você deve verificar os recursos
disponíveis em hardware, para que a importação funcione sem problemasEnviado do
Yahoo Mail no Android
Em qua, 7 7e mar 7e 2018 às 10:39, 'Ednilson Silva' ednilson.si...@jbs.com.br
[oracle_br]oracle_br@yahoogrupos.com.br> escreveu:
Pessoal,
Preciso migrar um banco (600G) Oracle Enterprise 9i (release 9.2.0.8) que está
em HP-UX para Red Hat Linux.
É um banco de legado e não posso alterar a versão do Oracle.
Então pensei em fazer um EXP / IMP, existe alguma outra alternativa para essa
migração?
Grato
Ednilson
#yiv1793700749 #yiv1793700749 -- #yiv1793700749ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1793700749
#yiv1793700749ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1793700749
#yiv1793700749ygrp-mkp #yiv1793700749hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1793700749 #yiv1793700749ygrp-mkp #yiv1793700749ads
{margin-bottom:10px;}#yiv1793700749 #yiv1793700749ygrp-mkp .yiv1793700749ad
{padding:0 0;}#yiv1793700749 #yiv1793700749ygrp-mkp .yiv1793700749ad p
{margin:0;}#yiv1793700749 #yiv1793700749ygrp-mkp .yiv1793700749ad a
{color:#ff;text-decoration:none;}#yiv1793700749 #yiv1793700749ygrp-sponsor
#yiv1793700749ygrp-lc {font-family:Arial;}#yiv1793700749
#yiv1793700749ygrp-sponsor #yiv1793700749ygrp-lc #yiv1793700749hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1793700749
#yiv1793700749ygrp-sponsor #yiv1793700749ygrp-lc .yiv1793700749ad
{margin-bottom:10px;padding:0 0;}#yiv1793700749 #yiv1793700749actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1793700749
#yiv1793700749activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1793700749
#yiv1793700749activity span {font-weight:700;}#yiv1793700749
#yiv1793700749activity span:first-child
{text-transform:uppercase;}#yiv1793700749 #yiv1793700749activity span a
{color:#5085b6;text-decoration:none;}#yiv1793700749 #yiv1793700749activity span
span {color:#ff7900;}#yiv1793700749 #yiv1793700749activity span
.yiv1793700749underline {text-decoration:underline;}#yiv1793700749
.yiv1793700749attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1793700749 .yiv1793700749attach div a
{text-decoration:none;}#yiv1793700749 .yiv1793700749attach img
{border:none;padding-right:5px;}#yiv1793700749 .yiv1793700749attach label
{display:block;margin-bottom:5px;}#yiv1793700749 .yiv1793700749attach label a
{text-decoration:none;}#yiv1793700749 blockquote {margin:0 0 0
4px;}#yiv1793700749 .yiv1793700749bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1793700749
.yiv1793700749bold a {text-decoration:none;}#yiv1793700749 dd.yiv1793700749last
p a {font-family:Verdana;font-weight:700;}#yiv1793700749 dd.yiv1793700749last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1793700749
dd.yiv1793700749last p span.yiv1793700749yshortcuts
{margin-right:0;}#yiv1793700749 div.yiv1793700749attach-table div div a
{text-decoration:none;}#yiv1793700749 div.yiv1793700749attach-table
{width:400px;}#yiv1793700749 div.yiv1793700749file-title a, #yiv1793700749
div.yiv1793700749file-title a:active, #yiv1793700749
div.yiv1793700749file-title a:hover, #yiv1793700749 div.yiv1793700749file-title
a:visited {text-decoration:none;}#yiv1793700749 div.yiv1793700749photo-title a,
#yiv1793700749 div.yiv1793700749photo-title a:active, #yiv1793700749
div.yiv1793700749photo-title a:hover, #yiv1793700749
div.yiv1793700749photo-title a:visited {text-decoration:none;}#yiv1793700749
div#yiv1793700749ygrp-mlmsg #yiv1793700749ygrp-msg p a
span.yiv1793700749yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1793700749
.yiv1793700749green {color:#628c2a;}#yiv1793700749 .yiv1793700749MsoNormal
{margin:0 0 0 0;}#yiv1793700749 o {font-size:0;}#yiv1793700749
#yiv1793700749photos div {float:left;width:72px;}#yiv1793700749
#yiv1793700749photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1793700749
#yiv1793700749photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1793700749
#yiv1793700749reco-category {font-size:77%;}#yiv1793700749
#yiv1793700749reco-desc {font-size:77%;}#yiv1793700749 .yiv1793700749replbq
{margin:4px;}#yiv1793700749 #yiv1793700749ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1793700749 #yiv1793700749ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1793700749
#yiv1793700749ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1793700749
#yiv1793700749ygrp-mlmsg select, #yiv1793700749
Assunto: [oracle_br] Consulta muito lenta!!
Não dá pra fazer uma mview atualizável?
Enviado do Yahoo Mail no Android
Em sex, 15 15e dez 15e 2017 às 10:57, Rafael Mendonca raffaell.t...@yahoo.com
[oracle_br]oracle_br@yahoogrupos.com.br> escreveu:
Senhores, bom dia.
Preciso de uma grande ajuda dos especialistas.
Ambiente single instance, file system, EE 11.2.0.3Options: diagnostic and
tuning pack, in memory, advanced compression, partitioning
Possuo uma query do sistema SAP (standard SAP), ou seja, nao existe alternativa
para mudança estrutural da consulta, nem por hint na consulta, nem nada, por
ser standard. O que é possível fazer é tudo a nível de banco de dados, como
criação de sql patch, rewrite etc...
Pois bem, vamos aos detalhes:
A consulta envolve 2 tabelas e 2 índices, cada um com seus respectivos tamanhos
abaixo:
tabela x1: 400GBtabela x2:160GBIndice tab x1: 140GBIndice tab x2: 2GB
Duracao da consulta: 16 minutos
OBS: Os segmentos envoldios nao possuem PARTICIONAMENTO ou COMPRESSAO.
COnsulta abaixo:
http://textuploader.com/dcreu
Plano de execucao abaixo (SELECT * FROM table(dbms_xplan.display_cursor)):
http://textuploader.com/dcre7
Alternativas 1:
A criacao de uma Mview para a consulta em questao, porem o SAP nao pode
direcionar o relatorio para a MVIew, entao pensei na rewrite para forcar ao ler
o sqlid utilizar Mview, porem se as mview nao estiver totalmente atualizada com
as tabelas envolvidas a Mview nao sera lida, ou seja, a tabela em questao
possui 2 bilhoes de registros, eh alterada o tempo inteiro, ou seja, sem chance.
Alternativa 2: realizar um compression OLTP nas tabelas envolvidas, o que
acham? Problema sera a carga de DML nessas tabelas, me preocupo com a lentidao
dos inserts, updates e deletes.
Alternativa 3: Particionamento. Porem precisamos de uma solucao rapida, ira
entrar um processo de auditoria e nao temos tempo para essa implementacao.
Alguem pode ajudar nessa dificil missao?
#yiv6344813816 #yiv6344813816 -- #yiv6344813816ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6344813816
#yiv6344813816ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6344813816
#yiv6344813816ygrp-mkp #yiv6344813816hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6344813816 #yiv6344813816ygrp-mkp #yiv6344813816ads
{margin-bottom:10px;}#yiv6344813816 #yiv6344813816ygrp-mkp .yiv6344813816ad
{padding:0 0;}#yiv6344813816 #yiv6344813816ygrp-mkp .yiv6344813816ad p
{margin:0;}#yiv6344813816 #yiv6344813816ygrp-mkp .yiv6344813816ad a
{color:#ff;text-decoration:none;}#yiv6344813816 #yiv6344813816ygrp-sponsor
#yiv6344813816ygrp-lc {font-family:Arial;}#yiv6344813816
#yiv6344813816ygrp-sponsor #yiv6344813816ygrp-lc #yiv6344813816hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6344813816
#yiv6344813816ygrp-sponsor #yiv6344813816ygrp-lc .yiv6344813816ad
{margin-bottom:10px;padding:0 0;}#yiv6344813816 #yiv6344813816actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6344813816
#yiv6344813816activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6344813816
#yiv6344813816activity span {font-weight:700;}#yiv6344813816
#yiv6344813816activity span:first-child
{text-transform:uppercase;}#yiv6344813816 #yiv6344813816activity span a
{color:#5085b6;text-decoration:none;}#yiv6344813816 #yiv6344813816activity span
span {color:#ff7900;}#yiv6344813816 #yiv6344813816activity span
.yiv6344813816underline {text-decoration:underline;}#yiv6344813816
.yiv6344813816attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6344813816 .yiv6344813816attach div a
{text-decoration:none;}#yiv6344813816 .yiv6344813816attach img
{border:none;padding-right:5px;}#yiv6344813816 .yiv6344813816attach label
{display:block;margin-bottom:5px;}#yiv6344813816 .yiv6344813816attach label a
{text-decoration:none;}#yiv6344813816 blockquote {margin:0 0 0
4px;}#yiv6344813816 .yiv6344813816bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6344813816
.yiv6344813816bold a {text-decoration:none;}#yiv6344813816 dd.yiv6344813816last
p a {font-family:Verdana;font-weight:700;}#yiv6344813816 dd.yiv6344813816last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6344813816
dd.yiv6344813816last p span.yiv6344813816yshortcuts
{margin-right:0;}#yiv6344813816 div.yiv6344813816attach-table div div a
{text-decoration:none;}#yiv6344813816 div.yiv6344813816attach-table
{width:400px;}#yiv6344813816 div.yiv6344813816file-title a, #yiv6344813816
div.yiv6344813816file-title a:active, #yiv6344813816
div.yiv6344813816file-title a:hover, #yiv6344813816 div.yiv6344813816file-title
a:visited {text-decoration:none;}#yiv6344813816 div.yiv6344813816photo-title a,
#yiv6344813816 div.yiv6344813816photo-title a:active, #yiv6344813816
div.yiv6344813816photo-title a:hover, #yiv6344813816
div.yiv6344813816photo-title a:visited
Re: [oracle_br] Re: Erro no IMPDP
Obrigado, Alessandro irei olhar.
Att,
Emerson M. Rocha
Mobile:(11) 5054-8368E-Mail: tkz...@yahoo.com.br
Em Terça-feira, 13 de Janeiro de 2015 16:20, alexssandro0...@yahoo.com.br
[oracle_br] oracle_br@yahoogrupos.com.br escreveu:
Olá, Emerson
Nunca passei por este problema, mas dando uma procurada no metalink, encontrei
a seguinte nota 1628926.1, que fala sobre o erro que você recebeu ai.Também
pode dar uma olhada na nota 1628079.1.
Att: Alexssandro RochaDBA Oracle
#yiv9378730758 #yiv9378730758 -- #yiv9378730758ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9378730758
#yiv9378730758ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9378730758
#yiv9378730758ygrp-mkp #yiv9378730758hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9378730758 #yiv9378730758ygrp-mkp #yiv9378730758ads
{margin-bottom:10px;}#yiv9378730758 #yiv9378730758ygrp-mkp .yiv9378730758ad
{padding:0 0;}#yiv9378730758 #yiv9378730758ygrp-mkp .yiv9378730758ad p
{margin:0;}#yiv9378730758 #yiv9378730758ygrp-mkp .yiv9378730758ad a
{color:#ff;text-decoration:none;}#yiv9378730758 #yiv9378730758ygrp-sponsor
#yiv9378730758ygrp-lc {font-family:Arial;}#yiv9378730758
#yiv9378730758ygrp-sponsor #yiv9378730758ygrp-lc #yiv9378730758hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9378730758
#yiv9378730758ygrp-sponsor #yiv9378730758ygrp-lc .yiv9378730758ad
{margin-bottom:10px;padding:0 0;}#yiv9378730758 #yiv9378730758actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9378730758
#yiv9378730758activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9378730758
#yiv9378730758activity span {font-weight:700;}#yiv9378730758
#yiv9378730758activity span:first-child
{text-transform:uppercase;}#yiv9378730758 #yiv9378730758activity span a
{color:#5085b6;text-decoration:none;}#yiv9378730758 #yiv9378730758activity span
span {color:#ff7900;}#yiv9378730758 #yiv9378730758activity span
.yiv9378730758underline {text-decoration:underline;}#yiv9378730758
.yiv9378730758attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9378730758 .yiv9378730758attach div a
{text-decoration:none;}#yiv9378730758 .yiv9378730758attach img
{border:none;padding-right:5px;}#yiv9378730758 .yiv9378730758attach label
{display:block;margin-bottom:5px;}#yiv9378730758 .yiv9378730758attach label a
{text-decoration:none;}#yiv9378730758 blockquote {margin:0 0 0
4px;}#yiv9378730758 .yiv9378730758bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9378730758
.yiv9378730758bold a {text-decoration:none;}#yiv9378730758 dd.yiv9378730758last
p a {font-family:Verdana;font-weight:700;}#yiv9378730758 dd.yiv9378730758last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9378730758
dd.yiv9378730758last p span.yiv9378730758yshortcuts
{margin-right:0;}#yiv9378730758 div.yiv9378730758attach-table div div a
{text-decoration:none;}#yiv9378730758 div.yiv9378730758attach-table
{width:400px;}#yiv9378730758 div.yiv9378730758file-title a, #yiv9378730758
div.yiv9378730758file-title a:active, #yiv9378730758
div.yiv9378730758file-title a:hover, #yiv9378730758 div.yiv9378730758file-title
a:visited {text-decoration:none;}#yiv9378730758 div.yiv9378730758photo-title a,
#yiv9378730758 div.yiv9378730758photo-title a:active, #yiv9378730758
div.yiv9378730758photo-title a:hover, #yiv9378730758
div.yiv9378730758photo-title a:visited {text-decoration:none;}#yiv9378730758
div#yiv9378730758ygrp-mlmsg #yiv9378730758ygrp-msg p a
span.yiv9378730758yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9378730758
.yiv9378730758green {color:#628c2a;}#yiv9378730758 .yiv9378730758MsoNormal
{margin:0 0 0 0;}#yiv9378730758 o {font-size:0;}#yiv9378730758
#yiv9378730758photos div {float:left;width:72px;}#yiv9378730758
#yiv9378730758photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv9378730758
#yiv9378730758photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9378730758
#yiv9378730758reco-category {font-size:77%;}#yiv9378730758
#yiv9378730758reco-desc {font-size:77%;}#yiv9378730758 .yiv9378730758replbq
{margin:4px;}#yiv9378730758 #yiv9378730758ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9378730758 #yiv9378730758ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9378730758
#yiv9378730758ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9378730758
#yiv9378730758ygrp-mlmsg select, #yiv9378730758 input, #yiv9378730758 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9378730758
#yiv9378730758ygrp-mlmsg pre, #yiv9378730758 code {font:115%
monospace;}#yiv9378730758 #yiv9378730758ygrp-mlmsg *
{line-height:1.22em;}#yiv9378730758 #yiv9378730758ygrp-mlmsg #yiv9378730758logo
Re: [oracle_br] Re: Erro no IMPDP
Emerson,
Boa tarde.
Tente verificar a versao do Oracle, pois provavelmente seja isso.
Att,
Emerson M. Rocha
Mobile:(11) 5054-8368E-Mail: tkz...@yahoo.com.br
Em Terça-feira, 30 de Dezembro de 2014 16:25, jlchia...@yahoo.com.br
[oracle_br] oracle_br@yahoogrupos.com.br escreveu:
Bem, dando de barato que ** REALMENTE *** não deu nem erro nem warning
NENHUM no log do export, imho a msg é clara :
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS
[VIEW:MGTRF.TRF_VW_MOVFISSERVECFOP]
ORA-06502: PL/SQL: numeric or value error
LPX-00216: invalid character 0 (0x0)
ORA-06512: at SYS.DBMS_SYS_ERROR, line 95
ORA-06512: at SYS.KUPW$WORKER, line 9715
== OU SEJA, o import estava extraiu e estava tentando processar o DDL da view
MGTRF.TRF_VW_MOVFISSERVECFOP e encontrou um caracter inválido... As
possibilidades para isso são poucas :
a. corrupção no dumpfile : entre outras possibilidades para isso , uma comum
*** EM ESPECIAL *** ocorre se na hora de transferir o dumpfile do Windows para
o Linux vc Esqueceu de especificar que a transmissão TEM que ser em modo
BINÁRIO : se foi isso, refaça a tranfer~encia, desta vez Demandando binary
mode...
OU
b. vc tem os bancos origem e destino usando charactersets ** diferentes ** e
Incompatíveis entre si, aí algum caracter high-ASCII não está sendo transferido
corretamente : para checar isso, CONFIRA bem no início do log do export E do
log do import se os caharectersets citados batem com os do database
OU
c. de maneira *** totalmente inapropriada ***, vc tem código (PL/SQL ou
diretamente em SQL mesmo) manipulando CHR(0) : as notas metalink 'LPX-00216:
invalid character 0 (0x0) When Importing Triggers With Data Pump' (Doc ID
1628079.1) e 'ORA-39126, ORA-06502, LPX-00216 invalid character 0 (0x0) From
impdp Of a Pre 11.2 DB into 11.2' (Doc ID 1633746.1) mostram algumas queries
que podem ser usadas para confirmar se é esse o caso , se for o melhor seria
Remover do teu código essa referência ao CHR(0), e o work-around seria extrair
o DDL com DBMS_METADATA ou similar , editar e criar na mão o obj em questão...
[]s
Chiappa
#yiv6893225575 #yiv6893225575 -- #yiv6893225575ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6893225575
#yiv6893225575ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6893225575
#yiv6893225575ygrp-mkp #yiv6893225575hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6893225575 #yiv6893225575ygrp-mkp #yiv6893225575ads
{margin-bottom:10px;}#yiv6893225575 #yiv6893225575ygrp-mkp .yiv6893225575ad
{padding:0 0;}#yiv6893225575 #yiv6893225575ygrp-mkp .yiv6893225575ad p
{margin:0;}#yiv6893225575 #yiv6893225575ygrp-mkp .yiv6893225575ad a
{color:#ff;text-decoration:none;}#yiv6893225575 #yiv6893225575ygrp-sponsor
#yiv6893225575ygrp-lc {font-family:Arial;}#yiv6893225575
#yiv6893225575ygrp-sponsor #yiv6893225575ygrp-lc #yiv6893225575hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6893225575
#yiv6893225575ygrp-sponsor #yiv6893225575ygrp-lc .yiv6893225575ad
{margin-bottom:10px;padding:0 0;}#yiv6893225575 #yiv6893225575actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6893225575
#yiv6893225575activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6893225575
#yiv6893225575activity span {font-weight:700;}#yiv6893225575
#yiv6893225575activity span:first-child
{text-transform:uppercase;}#yiv6893225575 #yiv6893225575activity span a
{color:#5085b6;text-decoration:none;}#yiv6893225575 #yiv6893225575activity span
span {color:#ff7900;}#yiv6893225575 #yiv6893225575activity span
.yiv6893225575underline {text-decoration:underline;}#yiv6893225575
.yiv6893225575attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6893225575 .yiv6893225575attach div a
{text-decoration:none;}#yiv6893225575 .yiv6893225575attach img
{border:none;padding-right:5px;}#yiv6893225575 .yiv6893225575attach label
{display:block;margin-bottom:5px;}#yiv6893225575 .yiv6893225575attach label a
{text-decoration:none;}#yiv6893225575 blockquote {margin:0 0 0
4px;}#yiv6893225575 .yiv6893225575bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6893225575
.yiv6893225575bold a {text-decoration:none;}#yiv6893225575 dd.yiv6893225575last
p a {font-family:Verdana;font-weight:700;}#yiv6893225575 dd.yiv6893225575last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6893225575
dd.yiv6893225575last p span.yiv6893225575yshortcuts
{margin-right:0;}#yiv6893225575 div.yiv6893225575attach-table div div a
{text-decoration:none;}#yiv6893225575 div.yiv6893225575attach-table
{width:400px;}#yiv6893225575 div.yiv6893225575file-title a, #yiv6893225575
div.yiv6893225575file-title a:active, #yiv6893225575
div.yiv6893225575file-title a:hover, #yiv6893225575 div.yiv6893225575file-title
a:visited
Re: [oracle_br] Tablespace
Debora,
Verifique o tablespace de indice do tablespace system que esta precisando
aumentar. Att,
Emerson M. Rocha
Mobile:(11) 5054-8368E-Mail: tkz...@yahoo.com.br
Em Terça-feira, 21 de Outubro de 2014 18:13, Débora Acácio
debby_ora...@yahoo.com.br [oracle_br] oracle_br@yahoogrupos.com.br escreveu:
Boa tarde gente
Me tirem uma dúvida estou tentando criar uma procedure e deu a seguinte
mensagem
ORA-00604: error occurred at recursive SQL level 1ORA-01654: unable to extend
index SYS.I_IDL_UB21 by 8 in tablespace SYSTEM
Como faço para consertar isso ??
Grata
Debby :) #yiv0084546727 #yiv0084546727 -- #yiv0084546727ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0084546727
#yiv0084546727ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0084546727
#yiv0084546727ygrp-mkp #yiv0084546727hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0084546727 #yiv0084546727ygrp-mkp #yiv0084546727ads
{margin-bottom:10px;}#yiv0084546727 #yiv0084546727ygrp-mkp .yiv0084546727ad
{padding:0 0;}#yiv0084546727 #yiv0084546727ygrp-mkp .yiv0084546727ad p
{margin:0;}#yiv0084546727 #yiv0084546727ygrp-mkp .yiv0084546727ad a
{color:#ff;text-decoration:none;}#yiv0084546727 #yiv0084546727ygrp-sponsor
#yiv0084546727ygrp-lc {font-family:Arial;}#yiv0084546727
#yiv0084546727ygrp-sponsor #yiv0084546727ygrp-lc #yiv0084546727hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0084546727
#yiv0084546727ygrp-sponsor #yiv0084546727ygrp-lc .yiv0084546727ad
{margin-bottom:10px;padding:0 0;}#yiv0084546727 #yiv0084546727actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0084546727
#yiv0084546727activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0084546727
#yiv0084546727activity span {font-weight:700;}#yiv0084546727
#yiv0084546727activity span:first-child
{text-transform:uppercase;}#yiv0084546727 #yiv0084546727activity span a
{color:#5085b6;text-decoration:none;}#yiv0084546727 #yiv0084546727activity span
span {color:#ff7900;}#yiv0084546727 #yiv0084546727activity span
.yiv0084546727underline {text-decoration:underline;}#yiv0084546727
.yiv0084546727attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0084546727 .yiv0084546727attach div a
{text-decoration:none;}#yiv0084546727 .yiv0084546727attach img
{border:none;padding-right:5px;}#yiv0084546727 .yiv0084546727attach label
{display:block;margin-bottom:5px;}#yiv0084546727 .yiv0084546727attach label a
{text-decoration:none;}#yiv0084546727 blockquote {margin:0 0 0
4px;}#yiv0084546727 .yiv0084546727bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0084546727
.yiv0084546727bold a {text-decoration:none;}#yiv0084546727 dd.yiv0084546727last
p a {font-family:Verdana;font-weight:700;}#yiv0084546727 dd.yiv0084546727last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0084546727
dd.yiv0084546727last p span.yiv0084546727yshortcuts
{margin-right:0;}#yiv0084546727 div.yiv0084546727attach-table div div a
{text-decoration:none;}#yiv0084546727 div.yiv0084546727attach-table
{width:400px;}#yiv0084546727 div.yiv0084546727file-title a, #yiv0084546727
div.yiv0084546727file-title a:active, #yiv0084546727
div.yiv0084546727file-title a:hover, #yiv0084546727 div.yiv0084546727file-title
a:visited {text-decoration:none;}#yiv0084546727 div.yiv0084546727photo-title a,
#yiv0084546727 div.yiv0084546727photo-title a:active, #yiv0084546727
div.yiv0084546727photo-title a:hover, #yiv0084546727
div.yiv0084546727photo-title a:visited {text-decoration:none;}#yiv0084546727
div#yiv0084546727ygrp-mlmsg #yiv0084546727ygrp-msg p a
span.yiv0084546727yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0084546727
.yiv0084546727green {color:#628c2a;}#yiv0084546727 .yiv0084546727MsoNormal
{margin:0 0 0 0;}#yiv0084546727 o {font-size:0;}#yiv0084546727
#yiv0084546727photos div {float:left;width:72px;}#yiv0084546727
#yiv0084546727photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv0084546727
#yiv0084546727photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0084546727
#yiv0084546727reco-category {font-size:77%;}#yiv0084546727
#yiv0084546727reco-desc {font-size:77%;}#yiv0084546727 .yiv0084546727replbq
{margin:4px;}#yiv0084546727 #yiv0084546727ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0084546727 #yiv0084546727ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0084546727
#yiv0084546727ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0084546727
#yiv0084546727ygrp-mlmsg select, #yiv0084546727 input, #yiv0084546727 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0084546727
#yiv0084546727ygrp-mlmsg pre, #yiv0084546727 code {font:115%
monospace;}#yiv0084546727
