Vais ter problema agora na hora de rodar o spdrop proque os objetos estão no sys e não no perfstat. Terás que mudar o schema de todos os objetos do script spdtab para sys e não perfstat antes de rodar o spdrop... Aí sim se não tiver mais problemas rodar o spcreate novamente.
Jonathan ----- Original Message ----- From: "Jonathan Barbosa" <[EMAIL PROTECTED]> To: <oracle_br@yahoogrupos.com.br> Sent: Wednesday, August 17, 2005 6:17 PM Subject: Re: [oracle_br] Procedure problema.... > Não deve ser estouro de buffer não. Rode o spdrop e depois rode o > spcreate, > isto aí como sys/ as sysdba. Se o Oracle te disconetar do sqlplus > verifique os 3 logs que irão nos dizer o porque desta desconexão. Se > quiseres me manda os logs em PVT para eu dar uma olhada. > Eu ja sei o que vc deve ter feito então para criar os objectos no sys. > Rodassee o spctab e o spcpkg como sys e não como perfstat. O certo mesmo é > rodar somente o spcreate como sys que os outros scripts são criados com o > usuário certo. > > > > Jonathan > > > ----- Original Message ----- > From: "Bruno" <[EMAIL PROTECTED]> > To: <oracle_br@yahoogrupos.com.br> > Sent: Wednesday, August 17, 2005 6:09 PM > Subject: Re: [oracle_br] Procedure problema.... > > >> Sim, >> Na verdade eu rodo eles separados >> 1ºspcusr.sql >> 2ºspctab.sql >> 3ºspcpkg.sql >> >> tipo não rodo o spcreate só pq estoura o buffer do sqlplus na hora de >> roda >> os scripts e ele acaba me desconectando na hora de roda o spcpkg , e eu >> não >> sei qual é o parametro do sqlplus que eu tenho que muda.... >> >> >> >> ----- Original Message ----- >> From: "Jonathan Barbosa" <[EMAIL PROTECTED]> >> To: <oracle_br@yahoogrupos.com.br> >> Sent: Wednesday, August 17, 2005 6:04 PM >> Subject: Re: [oracle_br] Procedure problema.... >> >> >>> O perfstat é que cria os sinônimos públicos. >>> >>> Rodasse o spdrop como sys e depois o spcreate novamente? >>> >>> Jonathan >>> >>> ----- Original Message ----- >>> From: "Bruno" <[EMAIL PROTECTED]> >>> To: <oracle_br@yahoogrupos.com.br> >>> Sent: Wednesday, August 17, 2005 5:59 PM >>> Subject: Re: [oracle_br] Procedure problema.... >>> >>> >>> > Sim pediu Jonathan... >>> > Tipo ele cria os sinonimos depois para o perfstat.... >>> > >>> > >>> > ----- Original Message ----- >>> > From: "Jonathan Barbosa" <[EMAIL PROTECTED]> >>> > To: <oracle_br@yahoogrupos.com.br> >>> > Sent: Wednesday, August 17, 2005 5:53 PM >>> > Subject: Re: [oracle_br] Procedure problema.... >>> > >>> > >>> >> Estes objetos devem pertencer ao perfstat e não ao sys. >>> >> >>> >> Quando rodasse o spcreate o Oracle não te pediu senha para o >>> >> perfstat, >>> >> tablespace onde serão criados os objetos e tablespace temporário? >>> >> >>> >> Jonathan >>> >> >>> >> ----- Original Message ----- >>> >> From: "Bruno" <[EMAIL PROTECTED]> >>> >> To: <oracle_br@yahoogrupos.com.br> >>> >> Sent: Wednesday, August 17, 2005 5:47 PM >>> >> Subject: Re: [oracle_br] Procedure problema.... >>> >> >>> >> >>> >> > Tipo me esqueci de comenta não me retorna nada com o user PERFSTAT >> mas >>> > com >>> >> > o >>> >> > SYS retorna né ( lógico) >>> >> > >>> >> > BJECT_NAME >>> >> > OBJECT_TYPE >>> >> >>> >>>> ------------------------------------------------------------------------- >> - >>> > -- >>> >> >>> ---------------------------------------------------- ------------------ >>> >> > STATSPACK >>> >> > PACKAGE >>> >> > STATSPACK >>> >> > PACKAGE BODY >>> >> > >>> >> > 2 linhas selecionadas. >>> >> > >>> >> > >>> >> > >>> >> > ----- Original Message ----- >>> >> > From: "Bruno" <[EMAIL PROTECTED]> >>> >> > To: <oracle_br@yahoogrupos.com.br> >>> >> > Sent: Wednesday, August 17, 2005 5:45 PM >>> >> > Subject: Re: [oracle_br] Procedure problema.... >>> >> > >>> >> > >>> >> >> Todos foram rodados com o sys >>> >> >> O unico erro foi esse >>> >> >> >>> >> >> ... Creating STATS$SNAPSHOT_ID Sequence >>> >> >> create sequence STATS$SNAPSHOT_ID >>> >> >> * >>> >> >> ERRO na linha 1: >>> >> >> ORA-00955: nome já está sendo usado por um objeto existente >>> >> >> é que eu ja tinha criado antes de roda o script. >>> >> >> >>> >> >> Não entendo isso... >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> ----- Original Message ----- >>> >> >> From: "Jonathan Barbosa" <[EMAIL PROTECTED]> >>> >> >> To: <oracle_br@yahoogrupos.com.br> >>> >> >> Sent: Wednesday, August 17, 2005 5:33 PM >>> >> >> Subject: Re: [oracle_br] Procedure problema.... >>> >> >> >>> >> >> >>> >> >> > Checasse os 3 logs gerados spcusr, spctab, spcpkg ? >>> >> >> > O scpcreate foi rodado como sysdba? >>> >> >> > >>> >> >> > >>> >> >> > Jonathan >>> >> >> > >>> >> >> > >>> >> >> > ----- Original Message ----- >>> >> >> > From: "Bruno" <[EMAIL PROTECTED]> >>> >> >> > To: <oracle_br@yahoogrupos.com.br> >>> >> >> > Sent: Wednesday, August 17, 2005 5:26 PM >>> >> >> > Subject: Re: [oracle_br] Procedure problema.... >>> >> >> > >>> >> >> > >>> >> >> > > Ai que eu me refino Jonathan , >>> >> >> > > não me retorna nada , o que deveria retornar algum objeto... >>> >> >> > > Não teve nada nos log >>> >> >> > > ----- Original Message ----- >>> >> >> > > From: "Jonathan Barbosa" <[EMAIL PROTECTED]> >>> >> >> > > To: <oracle_br@yahoogrupos.com.br> >>> >> >> > > Sent: Wednesday, August 17, 2005 5:22 PM >>> >> >> > > Subject: Re: [oracle_br] Procedure problema.... >>> >> >> > > >>> >> >> > > >>> >> >> > >> O seu scrpt spcreate foi rodado sem nehum problema? Faz assim >>> >> >> > >> execute >>> >> >> > >> este >>> >> >> > >> query como perfstat >>> >> >> > >> >>> >> >> > >> select object_name,object_type from user_objects >>> >> >> > >> where object_name='STATSPACK'; >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> O que retorna? >>> >> >> > >> >>> >> >> > >> Jonathan >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> ----- Original Message ----- >>> >> >> > >> From: "Bruno" <[EMAIL PROTECTED]> >>> >> >> > >> To: <oracle_br@yahoogrupos.com.br> >>> >> >> > >> Sent: Wednesday, August 17, 2005 5:14 PM >>> >> >> > >> Subject: Re: [oracle_br] Procedure problema.... >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> > Sim Jonathan... >>> >> >> > >> > ----- Original Message ----- >>> >> >> > >> > From: "Jonathan Barbosa" <[EMAIL PROTECTED]> >>> >> >> > >> > To: <oracle_br@yahoogrupos.com.br> >>> >> >> > >> > Sent: Wednesday, August 17, 2005 5:12 PM >>> >> >> > >> > Subject: Re: [oracle_br] Procedure problema.... >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> >> Vc está rodando a procedure como usuário perfstat? >>> >> >> > >> >> >>> >> >> > >> >> Jonathan >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> ----- Original Message ----- >>> >> >> > >> >> From: "Bruno" <[EMAIL PROTECTED]> >>> >> >> > >> >> To: <oracle_br@yahoogrupos.com.br> >>> >> >> > >> >> Sent: Wednesday, August 17, 2005 5:08 PM >>> >> >> > >> >> Subject: [oracle_br] Procedure problema.... >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> > Olá, >>> >> >> > >> >> > Quando rodo a procedure STATSPACK.SNAP do STATSPACK >>> >> >> > >> >> > tenho >> o >>> >> >> > >> >> > seguinte >>> >> >> > >> >> > erro. >>> >> >> > >> >> > >>> >> >> > >> >> > BEGIN STATSPACK.SNAP; END; >>> >> >> > >> >> > >>> >> >> > >> >> > * >>> >> >> > >> >> > ERRO na linha 1: >>> >> >> > >> >> > ORA-06550: linha 1, coluna 7: >>> >> >> > >> >> > PLS-00201: o identificador 'STATSPACK' deve ser >>> >> >> > >> >> > declarado >>> >> >> > >> >> > ORA-06550: linha 1, coluna 7: >>> >> >> > >> >> > PL/SQL: Statement ignored >>> >> >> > >> >> > >>> >> >> > >> >> > Alguem poderia dar uma luz sobre o problema??? >>> >> >> > >> >> > Obrigado >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > > >>> > ______________________________________________________________________ >>> >> >> > >> >> > >>> >> >> > >> >> > Histórico: >>> >> >> http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> > >> >> > Falar com os >>> >> >> > >> >> > Moderadores:([EMAIL PROTECTED]) >>> >> >> > >> >> > Dorian Anderson Soutto - Fernanda Damous - Alisson >>> >> >> > >> >> > Aguiar >>> >> >> > >> >> > >>> >> >> > > >>> > ______________________________________________________________________ >>> >> >> > >> >> > Links do Yahoo! Grupos >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> > >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> >> ______________________________________________________________________ >>> >> >> > >> >> >>> >> >> > >> >> Histórico: >>> >> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> > >> >> Falar com os >> Moderadores:([EMAIL PROTECTED]) >>> >> >> > >> >> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> >> > >> >> >>> >> >> >> ______________________________________________________________________ >>> >> >> > >> >> Links do Yahoo! Grupos >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> >> >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> >> ______________________________________________________________________ >>> >> >> > >> > >>> >> >> > >> > Histórico: >>> >> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> > >> > Falar com os >>> >> >> > >> > Moderadores:([EMAIL PROTECTED]) >>> >> >> > >> > Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> >> > >> > >>> >> >> >> ______________________________________________________________________ >>> >> >> > >> > Links do Yahoo! Grupos >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> > >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> > >> ______________________________________________________________________ >>> >> >> > >> >>> >> >> > >> Histórico: >>> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> > >> Falar com os Moderadores:([EMAIL PROTECTED]) >>> >> >> > >> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> >> > >> >>> >> > >> ______________________________________________________________________ >>> >> >> > >> Links do Yahoo! Grupos >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> > ______________________________________________________________________ >>> >> >> > > >>> >> >> > > Histórico: >>> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> > > Falar com os Moderadores:([EMAIL PROTECTED]) >>> >> >> > > Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> >> > > >>> > ______________________________________________________________________ >>> >> >> > > Links do Yahoo! Grupos >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> > ______________________________________________________________________ >>> >> >> > >>> >> >> > Histórico: >> http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> > Falar com os Moderadores:([EMAIL PROTECTED]) >>> >> >> > Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> >> > >>> > ______________________________________________________________________ >>> >> >> > Links do Yahoo! Grupos >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> >>> >> >> >>> >> >> >>> >> >> >> ______________________________________________________________________ >>> >> >> >>> >> >> Histórico: >>> >> >> http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> >> Falar com os Moderadores:([EMAIL PROTECTED]) >>> >> >> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> >> >> ______________________________________________________________________ >>> >> >> Links do Yahoo! Grupos >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> > >>> >> > >>> >> > >>> >> > >> ______________________________________________________________________ >>> >> > >>> >> > Histórico: >>> >> > http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> > Falar com os Moderadores:([EMAIL PROTECTED]) >>> >> > Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> > >> ______________________________________________________________________ >>> >> > Links do Yahoo! Grupos >>> >> > >>> >> > >>> >> > >>> >> > >>> >> > >>> >> > >>> >> > >>> >> > >>> >> >>> >> >>> >> >>> >> >>> >> ______________________________________________________________________ >>> >> >>> >> Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> >> Falar com os Moderadores:([EMAIL PROTECTED]) >>> >> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> >> ______________________________________________________________________ >>> >> Links do Yahoo! Grupos >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> > >>> > >>> > >>> > ______________________________________________________________________ >>> > >>> > Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> > Falar com os Moderadores:([EMAIL PROTECTED]) >>> > Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> > ______________________________________________________________________ >>> > Links do Yahoo! Grupos >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> >>> >>> >>> >>> ______________________________________________________________________ >>> >>> Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >>> Falar com os Moderadores:([EMAIL PROTECTED]) >>> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >>> ______________________________________________________________________ >>> Links do Yahoo! Grupos >>> >>> >>> >>> >>> >>> >>> >>> >> >> >> >> ______________________________________________________________________ >> >> Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> Falar com os Moderadores:([EMAIL PROTECTED]) >> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar >> ______________________________________________________________________ >> Links do Yahoo! Grupos >> >> >> >> >> >> >> >> > > > > > ______________________________________________________________________ > > Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ > Falar com os Moderadores:([EMAIL PROTECTED]) > Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar > ______________________________________________________________________ > Links do Yahoo! Grupos > > > > > > > > ______________________________________________________________________ Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ Falar com os Moderadores:([EMAIL PROTECTED]) Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar ______________________________________________________________________ Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: [EMAIL PROTECTED] <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html