RE: auto start instance

2003-10-12 Thread Zabach, Elke
Nick Chan wrote: > My Database instance doesn't start automatically anymore, > even though it is set at AUTO > I suspect its something to do with my Win2K Server settings? > Please enlighten. Thank you > As written on October, 7th 2003: As discussed earlier: To start and stop the database instan

RE: sql help

2003-10-12 Thread Zabach, Elke
Nick Chan wrotw: > > why this doesn't work > > SELECT * FROM (SELECT * FROM PROJECT_ WHERE ROWNO<=20 ORDER > BY NAME_) WHERE NAME_ NOT IN (SELECT NAME_ FROM PROJECT_ > WHERE ROWNO<=10 ORDER BY NAME_) As written in the reference manual: the select in the from clause is a query expression not in

Log backup failed with SQL-Code -3999

2003-10-12 Thread Nguyen, Bao L
Hello. I configured my livecache 7.4.2.20 data and log backup jobs using Veritas Netbackup tool (bacint for oracle method). Today my log backup failed with the SQL code -3999. I checked the knldiag file and found the error "FreeLog aborted because last lave into pipe not acknowledged by FreeLog

sql help

2003-10-12 Thread Nick Chan
why this doesn't work SELECT * FROM (SELECT * FROM PROJECT_ WHERE ROWNO<=20 ORDER BY NAME_) WHERE NAME_ NOT IN (SELECT NAME_ FROM PROJECT_ WHERE ROWNO<=10 ORDER BY NAME_) Error --- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed General erro

SapDB Crash

2003-10-12 Thread rusanov
Hello, I'm use sapdb Version: 'Kernel 7.4.3 Build 027-123-048-452' I have problem, my database crash I sent you the source DB procedure LAB.add_usergroup, executing which the crash is happeneing. Having tested the procedure, I've found the reason of crash. If I delete call LAB.add_event, the cra