Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

I need my quotas altered on apex.oracle.com for a workspace. I was granted more space but not quotas

User_U21TGSep 4 2022

I am trying to install configure demo Flows for Apex to my senior mgmt team and
without this request, the project will not be implemented in Oracle.
SR 3-30545883931 : on apex.oracle.com I was granted more space but my quotas did not get updated, please help me asap.
Oracle support has become such an incredible impediment to anything great the apex community and Apex/ Ords Teams have build. Can somehome offer some help please.
Workspace Name: AP_TRIANZ
Workspace ID: 44326766832439574385
Report Generated: 09/02/2022 06:38:33 PM
Reporting Period: Last Day
Provisioned : 09/01/2022 04:54:08 AM - 38 hours ago
Resource Manager Consumer Group:
Administrators:
RMANDER.CA@GMAIL.COM - rmander.ca@gmail.com
Developers: 1
All Users: 1 Users, Most recent user created 38 hours ago
Allow application building: Yes
Allow SQL Workshop Use: Yes
Allow Use of Team Development: Yes
Allow Use of RESTful Services: Yes
Workspace Message:
Source Identifier: AP_TRIANZ
Allow workspace to be purged: Yes
Last login: 09/02/2022 05:00:39 PM - 98 minutes ago
Files: 265 Files, consuming 48,204K
Pending Requests:
Change Request: "Change Database Size" workspace: "AP_TRIANZ" Size="100MB" - 103 seconds ago
================ actual problem , now space on apex site.=============
Problem Description
---------------------------------------------------
insert into flow_messages( fmsg_message_key, fmsg_lang, fmsg_message_content )
values (
'ITE-unsupported-type',
'en',
'Currently unsupported type of Intermediate Throw Event encountered at %0 .'
)

ORA-01536: space quota exceeded for tablespace 'APEX_BIGFILE_INSTANCE_TBS'
ORA-06512: at "SYS.DBMS_SQL", line 1721

CREATE OR REPLACE FORCE VIEW "V_USER_FREE_SPACE_NOW" ("TABLESPACE_NAME", "MB_FREE", "TOTALUSEDSPACE") AS
with abc as
(SELECT
ts.tablespace_name,
TO_CHAR(SUM(NVL(fs.bytes,0))/1024/1024, '99,999,990.99') AS MB_FREE,
'free' labelof
FROM
user_free_space fs,
user_tablespaces ts,
user_users us
WHERE
fs.tablespace_name(+) = ts.tablespace_name
AND ts.tablespace_name(+) = us.default_tablespace
GROUP BY
ts.tablespace_name ),
cursize as
( select tablespace_name
, to_char(round(sum(bytes)/(1024*1024)) ,'99,999,990.99' ) as totalusedspace,
'totusedsofar' labelof
from user_segments
group by tablespace_name )
select abc.tablespace_name, abc.mb_free, cursize.totalusedspace
from abc , cursize
where cursize.tablespace_name = abc.tablespace_name
/

TABLESPACE_NAME MB_FREE TOTALUSEDSPACE
APEX_BIGFILE_INSTANCE_TBS 5,578.81 50.00

Please alter my user quotas = free space granted.
SELECT tablespace_name, sum(max_bytes)/1024000 max_space_allowed FROM user_TS_QUOTAS group by tablespace_name;
TABLESPACE_NAME MAX_SPACE_ALLOWED
=============== ===================
APEX_BIGFILE_INSTANCE_TBS 51.264

This post has been answered by User_U21TG on Sep 6 2022
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2024
Added on Sep 4 2022
5 comments
561 views