Hi guys
I'm useing P6 R8.1 standalone version, and have serveral projects imported in the software. Now I want to import another new project, but one tip showed up some time after the importing process started, stating the request have exceed the maximum capacity of datebase (Code:PRMDB-0398-8).
I checked my datebase, and the 4GB almost used up. I tried to delete some project from P6, while there was no much change to the used percentage of datebase.
Any advise how can this problem be solved?
Thanks.
yes the compression is for an sql database
Hi, Zoltan
Thanks for your reply. Is above said mehod to add SQL datebase applicable if I'm currently using ORACLE DATEBASE?
this is like eating an Elephant you have to delete info in chunks
step #1
you have to delete a few activites first then you can delete a group of activities.
Then you can delete the projects that you no longer need
Step #2
create an additional database
for instructions on how to do this click on this link
http://pmsite.com/forums/viewthread/3329/
Step #3
Log into microsoft sql
Run this script
Highlight pmdb
Then type
update statistics project with fullscan ,all
update statistics task with fullscan, all
Then right click execute
Then type
exec sp_updatestats
Then right click execute
Step #4
compress your existing database and then compress your existiing file
for instructions on how to do this click on this link
http://pmsite.com/forums/viewthread/3330/