How to find out the date when an oracle database is upgraded

10-11  Source: Network gathering  Views:2 

Advertisement
Hi,
I would like to know the date when an oracle database is upgraded (for example 10.2.0.4 to 11.2.0.3).
Can you help me to find out these details.
Thanks,
Sarayu
user13312943 wrote:
Hi Ed and SB,
Thanks for your replies. How about this option?
Let us assume I am interested in checking when my database is upgraded to any 11g version.
Will this query help?
select min(first_usage_date)  from  dba_feature_usage_statistics where  version like '11%';
I understand this may not be a generic solution , but with this idea I may be able to build up a query to get the result.
Thanks,
Sarayu
How is it that you or nobody knows when the DB was upgraded?
I would have expected a formal testing & upgrade plan.
Does the organization practice safe software & utilize any source code repository?
Does everyone suffer from amnesia?
How could a MAJOR database upgrade slip by everyone who should care about such a detail?
Related articles
  • How to find out the date when an oracle database is upgraded 10-11

    Hi, I would like to know the date when an oracle database is upgraded (for example 10.2.0.4 to 11.2.0.3). Can you help me to find out these details. Thanks, Sarayuuser13312943 wrote: Hi Ed and SB, Thanks for your replies. How about this option? Let u

  • How to find out the date of license conversion (from Standard to Datacenter)? 10-11

    I had problems with Microsoft licensing and i need to find out, when my servers was converted from Standard to be Datacenter ? All my servers was standard, now it's Datacenter and i need to know from when it's Datacenter ???What I really mean is that

  • How to find out the primary key of oracle apps tables 10-11

    Hii,, My Question is How to find the primary key in the apps table...Is there any Query or other way to find out??? for eg. I want to find out the primary key of the AP_INVOICES_ALL table...just tell me how can i get the primary key of this table. I

  • How to find out the process count for a database during a particular window 10-11

    Hi Team, I want to find out the maximum process count reached for a database for an interval. Say between 1:00 to 2:00 AM IST. Please help Database version:11.2.0.2 OS:AIX 6.1Check DBA_HIST_RESOURCE_LIMIT. Your information will be there. Simialr info

  • How do I find out the date in which I registered my imac? 10-11

    How do I find out the date in which I registered my imac?It doens't really matter what date you registered it. However if you are looking to see when your expiration on AppleCare is/was it is 3 years from the original date of purchase. You can use th

  • How to find out the Hire date of an employee? 10-11

    Hi All What is effective date, Latest start date and other date fields which are are used when we create a new employee? What is the difference between hire date and joining date? How to find out the Hire date and joining date of an employee? Regards

  • How can I find out the date of a movie I am trying to pre-order if the date is not available/showing in the "manage pre-order" section? 10-11

    How can I find out the date of a movie I am trying to pre-order if the date is not available/showing in the "manage pre-order" section?Thanks so much for your reply King_Penguin. No, sadly there is not indication of the expected release date on

  • How to find out which data control do the page layout components come from? 10-11

    hi, work in Jdev 11.1.2.3 After have drag and drop data control into pages designer, how to find out which data control do the page layout component (such as a field in form layout) come from? --i cannot find data control related information in the p

  • How to find out the "manufacture date"? 10-11

    Hello! Can you tell me how to find out the manufacture date of my Satellite A110-334 with the serial "SY6224123K"? I need this information for my insurance! I found only this link for HDD`s: http://www.storage.toshiba.eu/index_manual.php?pid=220

  • How to find out the last date & time on which a program has been run 10-11

    Hi Experts, Can anybody tell how to find out the last date on which a purticular program has been run. Valuable answers will be rewarded. Thanks & Regards, Satish.Hi! Try STAD transaction. Unfortunately it contains a huge amount of data, so it is ava

  • How to find out the Target Component name and Target view name 10-11

    Hi All Expert,                   I want to know ,how to find out the target component and target view in WEB UI,when i click on a field which shows as a hyper link in WEB UI .At GUI level ,i know the how it will work.Any way to find out the component

  • How to find out the max/min value of one field corresponding to a second field in HANA through graphical way. 10-11

    Hi, I am trying to find out the latest delivery date(EINDT)  for each purchasing document (EBELN) through graphical way. The view contains other fields apart from the above mentioned two fields. When only the two fields (EBELN, EINDT) are there, then

  • How to find out the Correct Controlfile script Trace .trc file in /bdump 10-11

    Hi Guys This is the most childish queries in this forum .. I wanna know how to Find out the correct trace file when we Issue alter database backup controlfile to trace at sqlprompt for Creating controlfile script. As i find it a bit confusing to go t

  • How to find out the selected item in the lsit 10-11

    Hi all, How to find out the selected item in the list,can any please post some examples which easy to understand,because iam not a good programmerThis sample program uses a checkbox as selection,  you could also use a HOTSPOT. report zrich_0002 no st

  • How to find out the user-exits? 10-11

    hi. how to find out the user-exits? regards eswar.Hi, *& Report  ZEXITFINDER *report  zexitfinder. *& Enter the transaction code that you want to search through in order *& to find which Standard SAP User Exits exists. *& Tables tables : t

  • How to find out the Transactions used per month & the USER who used that 10-11

    Hi, 1)How to find out the Transactions used per month & the USER who used that? 2)and can i get the above same for minimum 20 month? System : SAP- Enterprise Core Component.You can use my program... *& Report  Z_ABAP_TCODE_MONITOR *****&  Prog

  • How to find out the tables from extract structures 10-11

    Hi All, As I know my data sources are 2lis_04_p_matnr,2lis_04_p_comp,2lis_04_p_arbpl. How to find out the tables concerned with the fields in the extract structure. ThanksPl check this link: http://help.sap.com/saphelp_nw2004s/helpdata/en/29/79eb3cad

  • How to find out the table name 10-11

    hi, how to find out the table name in which the data from a particular structure in a particular screen is saved, please tell me the procedure to find out the table name for saving the structure data that is inputted at runtime. Thanks, chinnuHi Chin

  • How to find out the file name 10-11

    Hi, In selection screen (parameter) user will give input TXT file from presentation server to upload to SAP. I need to capture the file name only but not the path and need to concatenate with date stamp and need to download error log in XLS file to p

  • How to find out the changes made to a photo in numbers rather than in graphs.. 10-11

    How to find out the changes made to a photo in numbers rather than in graphs..We need to know a lot more to help you. Please provide answers to the questions listed here: "FAQ: What information should I provide when asking a question on this forum?&q