Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Full tablespace SYSTEM

JJ_13Mar 21 2022 — edited Mar 21 2022

Hi guys, I am concerned about my full system tablespace. Can you advice me which solution would be better one?
I will start from some information:
System tablespace contains only the required system objects. There is no other user's objects than OUTLN or DR. It has 1,6 GB total space and only 3 MB free. Autoextend is on with next 10M setting. But still I think it is reasonable to avoid keeping such a full system tablespace.
I wonder if it is better to just resize it's datafile (for example to 2 GB) with ALTER tablespace datafile ... RESIZE 2G option, or maybe if it is autoextended than changing 'NEXT' value from 10M (let's say to 300M) would be better?

Also, could you confirm if altering anything on tablespace system will not affect working of database? Is it possible to have some breaks on connecting while resizing it?

I would really appreciate some helpful advices, thanks a lot!
This post has been answered by EdStevens on Mar 21 2022
Jump to Answer

Comments

Michael Ferrante-Oracle

Don't use the executable directly.  Instead use the provided shell script found in the instance home/bin.

$DOMAIN_HOME/config/fmwconfig/components/FORMS/instances/forms1/bin/frmbld.sh userid=ACCOUNT/ACCOUNT@cmt batch=no module=$i module_type=form compile_all=yes

vansul

If error is form not created then.

It might be due to create file permission in the output directory.

Or it might be issue with the libraries attached with any form.

Actually show the screenshot of actual wording of the output of the script which says form not created.

Gary_A

Michael, I think he is using the frmcmp.sh shell script, but just being lazy and not showing the actual command run.

However Mr. Random Number, FORM NOT CREATED can come from a whole slew of reasons. You need to show the entire output of what was shown when you ran the command. Why not compile it withing Forms so that it will show you ALL the code that it could not compile in context.

My guess is that you are missing a library that you had in 10g, but did not copy/compile to 12c.

1 - 3

Post Details

Added on Mar 21 2022
#database, #general-database-discussions
6 comments
91 views