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