Yes. Try dynamic sql.

codebyo (3/26/2012)

---

PaulB-TheOneAndOnly (3/26/2012)

---

Probably you are not looking at the right places, there is a vibrant community indeed - one entry point would be http://www.oracle.com/technetwork/index.html - the famous Oracle Technology Network....

capn.hector (3/29/2012)

---

PaulB-TheOneAndOnly (3/29/2012)

---

amita.gham (3/29/2012)

---

I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the...

Praying hard poster does not says "I have a head ache" 😀

it looks to me like the Change Control processes of your organization are not really well designed.

In regards to existing database servers - you as a DBA should have control...

amita.gham (3/29/2012)

---

I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table with...

Adding to Sean's comments - post don't even describes an Oracle hot backup as teh title of the thread suggests; most likely the process to test a restore/recover database.

Is this...

_nzrdb6 (3/27/2012)

---

This is whre i'm a little confused tbh. Is it better to switch the browser off or hide the instance? do they do the same thing? is one solution...

SqlNewJack (3/26/2012)

---

Which is the dominant modeling language/notation? Is one more effective than the other and which are most often used in a real world setting? I ask because I have...

_nzrdb6 (3/27/2012)

---

Hi guys, I manage 50 instances and my standard is to switch the Browser of on all servers. My boss wants to switch it on for a particular server...

Sergei Zarembo (3/26/2012)I understand this part [running Update against 1 partition]. I'm not sure how would you run a few partitions in parallel. Was it what you referrred to earlier....

Sergei Zarembo (3/26/2012)

---

Is TRANSACTIONDATA the table expected to get the updates?

SQL Server 2008 has the ability to escalate locks to "partition" level before locking the whole table -...

Sergei Zarembo (3/26/2012)

---

PaulB-TheOneAndOnly (3/26/2012)

---

Shame these are not partitioned tables 🙂

Probably the easiest way run this process in batches and even do it in parallel would be to use the content...

Shame these are not partitioned tables 🙂

Probably the easiest way run this process in batches and even do it in parallel would be to use the content of NBSEQUENCE, like...

As far as I understand the major development is in the locking escalation process which has now added the "partition" level; this...