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