Home » RDBMS Server » Server Administration » maxtrans has no effect
maxtrans has no effect [message #54948] Wed, 18 December 2002 07:54 Go to next message
vicky_100100@yahoo.co.in
Messages: 2
Registered: December 2002
Junior Member
hi ..
i set maxtrans 1 for a table ..
and two concurrent transactions updating the same
table ... mean maxtrans has no effect ..

pls explain ...

Report message to a moderator

Re: maxtrans has no effect [message #54954 is a reply to message #54948] Wed, 18 December 2002 15:53 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
When did you setup this value? At table creation time or after? How did you set it up - by ALTER TABLE table_name MAXTRANS 1;? If so, I have to disappoint you - it doesn't work this way!!

You will need to recreate the table(s) (exp/imp or move it with this parameter changed) to change the PCTFREE, PPCTUSED, INITRANS and MAXTRANS values.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re Question maxtrans has no effect [message #54981 is a reply to message #54954] Sun, 22 December 2002 02:39 Go to previous message
vicky_100100@yahoo.co.in
Messages: 2
Registered: December 2002
Junior Member
no sir i create this table with maxtrans 1

Report message to a moderator

Previous Topic: getting problem in starting oracle
Next Topic: Help!I can't start oemapp in AIX 4.3.3,why?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 28 04:40:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.