RE: Follow-up :Long running SQL Problem?

Hi, Thanks to those who take the trouble to reply. It's indeed enlightening. I've learnt a lot from you guys. Regds, New Bee -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 3:54 AM

RE: Slightly OT: Perl Q.

Are you exporting said variables? If not that is most likely your problem (of course I am talking ksh, sh here). -Original Message- Sent: Wednesday, April 03, 2002 7:54 AM To: Multiple recipients of list ORACLE-L Lets see the script. Are you sure you are setting the environment

RE: sysdba

Hi, You have password file, and you are not register in it. either you register yourself in this password file (orapwd) or don't use that password file RE..PAS.. = none. Sinardy -Original Message- Sent: 03 April 2002 13:18 To: Multiple recipients of list ORACLE-L i cant connect as

RE: RMAN

Lisa, What version of Oracle are you using? We are toying with using RMAN to backup our 9i databases. We are using Legato so I am figuring the integration will be pretty good. I never really felt the need to give up my scripts before but then again, I was always able to back up to disk or shut

Re: SQL Server vs. Oracle 9i

Just think of what the savings would be over a 50 year period! WOW! Ken - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 3:03 PM Subject: Re: SQL Server vs. Oracle 9i It's fascinating when

RE: Literal SQL and sys.dual

This code looks the same as what you submitted earlier. The package body does not compile either. I am not sure what you are trying to do with the RTRIM function. I see that you will get for the first example 1 + 1 + 1 +1; end; but then what? I have tried to compile the package body on

RE: Oracle Step-by-Step Guide feedback

To quote Alan Paller in his email which included the document : Thanks for your note. The attached file has the problem set from the first draft of SANS new publication, Securing Oracle: Step by Step. If you have expertise in Oracle security and apply it to provide substantive feedback on the

How to use Email server in 9iAS.

Hi I wish to install Email server in 9iAS. but i don't know how to do that. i try to download the same from OTN but unable to get it. so let me know how to do and configure the same Rgds Ayyappan.S This communication

Planning/Arranging tables common to multiple applications on one

Hi, Currently we have one Oracle Database Server, we might have one more in future, running one application. For a couple of new applications we have created users/schema by the name of applications and have created the tables there for grouping them on the basis of application. There are

RE: another listener.ora

You can start several listeners from the same listener.ora file. I am not aware that you can use 2 files to start 2 listeners. I give an example below John ### # Listener service name LISTENER_LIVE # Listens on service

find nologging

Hi all, If there are process of insert /*+append */ still running. how can I know if this insert is logging or nologging ? Thanks Sinardy Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To

RE: Planning/Arranging tables common to multiple applications on one

Aleem, I think that your current arrangement is fine. Why don't you consider all the common information as an application in its own right, say 'REFERENCE'? And let application specific information into their own schema, it doesn't need to be a all-or-nothing affair. You can even create

<    1   2