otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire


Database Administration Database installation, creation, administration and related topics.

Closed Thread
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old February 28th, 2007, 19:12
Junior Member
 
Join Date: Dec 2006
Location: Orlando, Florida, US
Posts: 29
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 0
Thanked 2 Times in 2 Posts
Rep Power: 0
runinord is on a distinguished road
Send a message via MSN to runinord Send a message via Skype™ to runinord
[SOLVED] DB Patch 9.2.0.8 for DST for OTM V5.0

I upgraded our database from 9.2.0.7.10 to 9.2.0.8 last night and the only negative consequense of doing so was that it corupted 2 custom functional indexes on the order_release table that made it imposible to update order release dates and times.
As soon as the corruption was identified to be these two functional indexes, I droped them both and re-created them again and after that every thing is running smooth.

Just wanted to let you know if you are doing the database upgrade and if you use any custom function based indexes it would be good to check these for coruption right after.

We are on OTM v 5.0 November 2006 service release and this database patch solved our DST issue immediatly.

Cheers,
Runi
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Finding the CU Patch Version of OTM gokul Patches 2 October 25th, 2007 07:13
[SOLVED] Opatch fails after uncompleted or interrupted patch chrisplough Installation and Upgrades 0 September 26th, 2007 13:56
[SOLVED] Fixing OTM Oracle Reports after Patch Installation - Fixing File Permissions chrisplough Patches 0 June 13th, 2007 12:14
[SOLVED] Sources for older update/patch doc CDrozdowski Patches 4 June 6th, 2007 19:28
[SOLVED] Oracle's 2007 Timezone Patch Impact to OTM mldeuel Patches 1 February 23rd, 2007 00:55



All times are GMT. The time now is 19:08.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40