otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


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

Tags: , , , ,

Closed Thread
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old February 28th, 2007, 20:12
Junior Member
 
Join Date: Dec 2006
Location: Orlando, Florida, US
Posts: 29
Thanks: 0
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 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
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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 08:13
[SOLVED] Opatch fails after uncompleted or interrupted patch chrisplough Installation and Upgrades 0 September 26th, 2007 14:56
[SOLVED] Fixing OTM Oracle Reports after Patch Installation - Fixing File Permissions chrisplough Patches 0 June 13th, 2007 13:14
[SOLVED] Sources for older update/patch doc CDrozdowski Patches 4 June 6th, 2007 20:28
[SOLVED] Oracle's 2007 Timezone Patch Impact to OTM mldeuel Patches 1 February 23rd, 2007 01:55



All times are GMT. The time now is 20:35.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


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