Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mk83
  • Order by date
  1. mk83

    /usr/sap/trans/EPS/in directory

    Hi Jmiturbe, You are correct that those directories are used for patches, so you should be able to delete them, unless you are busy importing any patches, or still wish to import them! It is proberbly wise to first check transaction SPAM and make sure that there are no packages in the queue, or...
  2. mk83

    Oracle Recovery after "Open DB reset logs" !!!!!!

    Hi Alex, The biggest problem is the need we have to roll forward on logs until the point in time that the "Open database resetlogs" command was run, after that point we need to roll forward on the logs created after! They added datafiles after the backup, but we seem to have found...
  3. mk83

    Oracle Recovery after "Open DB reset logs" !!!!!!

    Hi Guys, We have a massive problem, I really would appreciate any help you may be able to offer, Two weeks ago a process was begun on a box to move the oracle database to another box. In order to keep the system up for as long as possible, while the online was being restored to the new box, the...
  4. mk83

    Sort key too long ORA-1467

    Hi sem, How would you provide a structure and execution plan? I have never really done much SQL before? What/How does the exists clause work? Thanks very much for the help, MK83
  5. mk83

    Sort key too long ORA-1467

    Hi Guys, Got it sorted, for some reason, when I drop the primary key index using, alter table CEPRINT drop primary key, then the above statement works! I'm glad to have solved it, but do any of you know why this works? I hate just finding the answer and still haveing no clue about why/how it...
  6. mk83

    Sort key too long ORA-1467

    Hi guys, I have an oracle8i 8.1.7.3.0 database, the one table CEPRINT has a duplicate primary key in it, causing the validate structure cascade cascade command to fall over with a ORA-1499, I need to find and delete the duplicate keys, but when I run the following select statement ...
  7. mk83

    DB-Export Long runtime

    Hi Guys, I hope you will be able to help out, we are trying to test a migration from Oracle to SAPDB, the problem is that the export takes over 30hours to run, our Database has a size of 350+Gb, the tablespace that takes 75% of the time is PSAPBTABD, which uses the sapappl1.str to export, I...
  8. mk83

    Oracle to SAPDB Migration (Long Runtime)

    Hi Guys, I hope you will be able to help out, we are trying to test a migration from Oracle to SAPDB, the problem is that the export takes over 30hours to run, our Database has a size of 350+Gb, the tablespace that takes 75% of the time is PSAPBTABD, which uses the sapappl1.str to export, I...

Part and Inventory Search

Back
Top