Parallel DML for UPDATE

Printable View

11-08-2005, 03:40 PM
bang_dba

Parallel DML for UPDATE

Hi,

Is it possible to enable parallel DML to a non-partitioned table for an UPDATE statement ?
11-08-2005, 03:47 PM
dbasan

Quote:

Originally Posted by bang_dba

Hi,

Is it possible to enable parallel DML to a non-partitioned table for an UPDATE statement ?

Not possible!
11-08-2005, 03:52 PM
tamilselvan

Quote:

Originally Posted by dbasan

Not possible!

Yes, Possible if your DB is >= 8i.
Tamil
11-08-2005, 04:04 PM
bang_dba

Quote:

Originally Posted by tamilselvan

Yes, Possible if your DB is >= 8i.
Tamil

Thx Tamil. Just alter session with Hint will do OR is there any other setting to be done ?
11-08-2005, 04:12 PM
dbasan

Quote:

Originally Posted by tamilselvan

Yes, Possible if your DB is >= 8i.
Tamil

you are right Tamil, but don't talk abt expired versions!
11-08-2005, 04:41 PM
tamilselvan

Quote:

Originally Posted by dbasan

you are right Tamil, but don't talk abt expired versions!

Expired versions ??? What are they?

Tamil

All times are GMT -4. The time now is 12:55 PM.