Search results for query: *

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...

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...

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...

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

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...

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 ...

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...

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...