You need to select SQL Commands > Enter Command: Hopefully you wrote it down because recovering it is not fun.Īfter logging in you will be presented with a screen similar to the one below.
#Backup primavera p6 oracle database password#
Your password is the same password you used when setting up the database. Elsewhere you may have read that SYS is the username, but this username does not give you permission to execute commands. Once the Database Home Page loads you will be presented with the following login screen: Note that all of the Oracle/Primavera apps are grouped together. Ugh! But here is what you are looking for in Windows 8: Starting with Windows 8, all programs are treated like apps so I have to look in my apps group. Unless you are using Windows 8 or later, simply click on Start > All Programs. So today I am going to describe each step in detail: Step One – Locate the Oracle XE Database Home Page
#Backup primavera p6 oracle database how to#
However, I realize that some users need more specific instructions regarding how to delete POBS data from an Oracle XE database. That is ridiculous! It should never take more than a few minutes to import one schedule. We have heard from users saying it takes hours to import larger schedules. Also, it significantly reduces the amount of time required to import XER files.
Otherwise, your database becomes bloated. For example, if someone sends you a bloated XER file you want to delete the worthless POBS data before you import it into your database. I also explained – briefly – how to delete POBS data in an Oracle database so that it is not exported in the first place. Mostly I focused on how to shrink the size on an XER file after it has been exported from a database, Microsoft (SQL) or Oracle (XE).
Several people responded kindly to my post regarding how to Put Your Primavera XER File on a Diet.
0 kommentar(er)
