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 <*> 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