Home » RDBMS Server » Server Administration » change inittrans value for a table
change inittrans value for a table [message #51895] Thu, 20 June 2002 07:46 Go to next message
Nagesh
Messages: 18
Registered: April 2002
Junior Member
Hi,
I have a database with morethan 50 tables. I have created one huge table with inittrans 1 option. Now 13 lakhs of rows in that table and that table references to another 5 more tables. How should i change the inittrans value to other. Immediate help would be appreciable.

Thanks in advance.

Nagesh.

Report message to a moderator

Re: change inittrans value for a table [message #52028 is a reply to message #51895] Thu, 27 June 2002 00:40 Go to previous message
SureshB
Messages: 7
Registered: June 2002
Junior Member
Alter table table_name initrans ;

Report message to a moderator

Previous Topic: control file shrink?
Next Topic: Increase size of DB_Block_Buffers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:31:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.