Hi everyone,
I have an Oracle Autonomous Database (Always Free tier) that I use mainly for Oracle APEX development. Recently, I started worrying about storage usage, so I ran the following query:
SELECT
owner,
segment_name AS table_name,
segment_type,
ROUND(SUM(bytes) / 1024 / 1024, 2) AS size_mb
FROM dba_segments
WHERE segment_type IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION')
GROUP BY owner, segment_name, segment_type
ORDER BY size_mb DESC;
I found a table called SSB.LINEORDER that’s taking up around 165,487.13 MB of space.
I tried to drop it using:
DROP TABLE SSB.LINEORDER CASCADE CONSTRAINTS PURGE;
but I got the error ORA-01031: insufficient privileges.
Does anyone know how I could resolve this?
Also, is there any problem with dropping the SSB tables in an Autonomous Database environment?
Thanks in advance!