kiran.hegde (8/23/2010)

---

I would like to modify the contents of sqlnet.ora file using a command line interface. Does Oracle ship with any such tool?

I could also write a small program which...

GilaMonster (8/22/2010)

---

I'll say. That 1TB mission-critical DB with 0 downtime allowances in business hours could be...

456789psw (8/22/2010)

---

I am sure there is "it all depends" We have about 20 instance DEV,QA,Prod

and only 2 database half way big the other are very small. one is...

I do not like history tables either - talking here about a data...

da-zero (8/20/2010)

---

Actually, to be precise, a dimension is not of SCD type 1,2,3 or hybrid, it's attributes are. A dimension can have a combination of different types of SCD. For...

S Hodkinson (8/20/2010)

---

I do not have access currently to the Oracle database but I am trying to contact the people who have. Is there any way to check from...

brucla (8/20/2010)

---

I have a friend (a programmer) who's boss wants to build a non-relational database to handle PayPal type of financial transactions, and he asked for my 2 cents...

I don't...

Are you positive this is...

ricardo_chicas (8/19/2010)

---

For several reports we need to extract about 5 millions records from a table of 124 million ( 173 gb)

I am able to use the clustered index ( with...

gregory.perry2 (8/18/2010)

---

Once I restructure the Hierarchy table and take all of the redundant Crap out I think it will be a lot less than 60k records. Because not all...

:blink: Could you please elaborate? This is really confusing.

sql_freak (8/19/2010)

---

I am new to SSIS systems. Can any one please give me step by step how to deploy a newly created package in to a project existing in the...

Ray Cacciatore (8/19/2010)

---

I just inherited a new SQL Server project. I noticed that the previous developer did not refer to tables in his stored procedures. All references are made to...

tomiboy59 (8/19/2010)

---

PaulB-TheOneAndOnly (8/18/2010)

---

tomiboy59 (8/18/2010)

---

Ok. The query hanging hasn't happened for a while, but now I got the error in the picture attached. This gets fixed if I restart the server....

Title line reads: "Database Disaster Recovery"

I'm kind of confused, are you looking for advice in regards to a Disaster Recovery plan...