on 11-22-2013 9:05 PM
Just did a system import, doing my post steps, ran stats/optimizer on my db, but my SGEN continues to fill my table space and fail, keep giving it tablespace and it continues to run out. What am i missing?
Check whether there is sufficient free space in the PSAPSR7NN tablespace.
If not extend it and repeat SGEN.
This is normal. Also watch out for the archived logs as well (assuming you have an Oracle database).
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Joshua,
SGEN will require DB Space depending on your system. Running/Updating Optimizer stats will not have any effect on DB Size increasing due to SGEN.
I suggest you to extend ample space in your DB for SGEN & other activities.
Regards,
Mudasir.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which tablespace you are getting error for? Did you tried extending that tablespace?
Thanks,
Manish Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.