View Single Post
  #3 (permalink)  
Old June 7th, 2007, 20:33
chrisplough's Avatar
chrisplough chrisplough is offline
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 847
Blog Entries: 7
Thanks: 53
Thanked 205 Times in 124 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: V4.5 Update and Migration Question Part 1

I'm sure you know this, but I just tracked down the ALTER_TABLE package to the following script:

<otm_install_dir>/glog/oracle/script8/create_alter_table_package.sql

Which in turn calls:

<otm_install_dir>/glog/oracle/script8/pkg/alter_table.pks
<otm_install_dir>/glog/oracle/script8/pkg/alter_table.pkb

So by editing the alter_table.pkb file and re-running the create_alter_table_package.sql script, you should be able to define a different default commit rate.

--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Reply With Quote