Re: Versioning the Database !

2002-12-27 Thread ora ak
I generally follow as a practice to keep a variable v_version at package level  or any script level . ( i have only packages ) and this v_version is nothing but $header$ in mks . This way I can always run a query to find out object versions in db . This is REALLY helpful specially when code is wrap

RE: oracle apps documentation

2002-10-25 Thread ora ak
cs (left menu) -> E-business Suite ERP -> -> Documentation (there are also other paths to follow to get to the same place). You'll find user guides and most TRMs   Also check out AppsNet: http://www.oracle.com/appsnet/content.html  -----Original Message-From: ora ak [mailto:[EMAIL

oracle apps documentation

2002-10-25 Thread ora ak
can some one point me in right direction to look for oracle applications documentations.  I am specially interested in manufacturing and financials . thanks , oramagic  Do you Yahoo!? Y! Web Hosting - Let the expert host your web site

Re: SID and DB_NAME

2002-10-25 Thread ora ak
database, which would be the DB_NAME. The SIDand DB_NAME need not be the same. They have to be different in an OracleParallel Server environment, where you can have two SID's say ORA1 and ORA2associated with the same database, say ORA.Rajora ak hoo.com> cc: Sent by: Subject: SID and DB_N

SID and DB_NAME

2002-10-24 Thread ora ak
I know this novice question for dba's but just wanted to refresh this , what is difference between SID and DATABASE_NAME , why init.ora file shouldhave database name same as SID  and in what circumstances SID and DB_NAME can be different . TIA oramagic Do you Yahoo!? Y! Web Hosting - Let the expert

Re: How to configure MD5 data encription in Oracle 8i

2002-10-16 Thread ora ak
why not use encryption outside the database and store encrypted string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string . Just an idea . I dont the answer of your original question :) Oramagic  Suman S K <[EMAIL PROTE

RE: Any way to see the currently running SQL in one session.

2002-10-16 Thread ora ak
there is a x$ table which can give u this info I am not able to recall that at the moment . oramagic  Paulo Gomes <[EMAIL PROTECTED]> wrote: u could use top sessions-Original Message-Sent: quarta-feira, 16 de Outubro de 2002 2:28To: Multiple recipients of list ORACLE-LDear ALL,Is there any

Re: Difference - Rebuild and Analyze index

2002-10-16 Thread ora ak
Yes Marul , I think there is a big differenece in them . When you are rebulding the index means you are re-organzing the entries in the index , may be removing the entries for the rows deleted in past and so forth so on. But this doesn't generate any statistics about index. When you analyze index,

Re: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris

2002-10-16 Thread ora ak
I though WL manages connection pool. Better look into WL configurations for connection pooling .  Joshua Becker <[EMAIL PROTECTED]> wrote: Hi all,we are facing strange problems with our environment.we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connectio

<    1   2   3