Thread: Archiving Of Data Other Than Shipment / Order Release / Order Base / Items
View Single Post
  #3 (permalink)  
Old May 22nd, 2008, 13:49
ianlo ianlo is offline
Senior Member and Blogger
  
Join Date: Dec 2006
Location: Singapore
Posts: 141
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Re: Archiving Of Data Other Than Shipment / Order Release / Order Base / Items
Hi Chris,

Thanks for the reply. I think I will have to ask my DBA to design some scripts that will archive these business objects to another tableowner like SCH_ARCHIVE and only provide the necessary grants from GLOGOWNER to execute.

Hopefully this will help buffer the impact of any changes to the OTM schema during patches / migration.

Ian
Reply With Quote