ozkary (9/25/2008)

---

we restored the database from backups. the concern here is the fact that the files were deleted. there is no concrete evidence on what could of happen, but it...

Sakthivel Chidambaram (9/26/2008)

---

Try running the same query in SQL Plus directly connecting to Oracle Database and see whether you are getting same error. If the same error is coming then...

I would not use MSDAORA as my OLE DB provider when talking to Oracle, I would use Oracle OLE DB provider instead.

I would start by checking the status of transaction log for NIManagementDB database.

Is it set for autogrowth?... in the affirmative case, in the growth % or size something reasonable or...

Assuming this was a question... Yes, I do.

A 500 Meg TempDB for an instance where the largest database is 630 Meg in size appears to be an overkill.

Set your TempDB to autoextend as needed with a limit...

Michael Meierruth (9/22/2008)

---

mark lake (3/19/2008)

---

I've recently (about 5 minutes ago) accepted a job as an Oracle DBA, Don't suppose anyone knows of any Oracley type websites that are as...

I would even go back to Adabas and even Total if the money is good enough 😀

Let me quote Mr. Ron White when he says "you can't fix stupid"; I would add you can't prevent stupidity because there is not such a thing as a vaccine...

"accidentaly overwritten the database"... I love the way you phrased it. 😀

Well... that's why I keep in my desk a bottle of brandy and my old-n-good original point-and-click interfase(1); you...

There is a two bullets check list for you to decide wether to partition or not a table. You have to ask yourself the next two questions:

1- Does partitioning strategy...

Oh boy, that phrase scares the s*%$#W out of me :w00t:

set your environment to single user mode and try again.

what you are seeing exposed as "drives" are not actually different "drives" on the SAN; you may want to talk to your storage guy.

:w00t: you shouldn't be using developer edition on a production server, that's illegal!... look at the door, police is coming 😀