I am currently using Oracle Database Express with Primavera P6.
I have filled my Oracle Database Express to about 80% fill and do not wish to exceed the size limit (done that before!)
Consequently I have Exported and the Deleted about 50% of the projects that I have in the database.
I then compacted the database, but there is no change in the size of the database.
I then tried backing it up, and doing a restore on what should be a smaller database, this still returned the same size database.
I have since copied another project and the database size has grown so I believe that even though I have removed projects this has actually not freed up any more space.
I am currently running P6 on a laptop in stanadalone mode.
Primaver P6 Version 7.0.0 (Build #: 00000092)
Database : Oracle Database 10g Express Edition Release 10.2.0.1.0
Windows 7 Service Pack 1 32 bit
Intel Core i5 @ 2.5Ghz
4GB Ram
Would appreciate some suggestions, thanks