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