Hi all,
I have a free tier account with an autonomous database on it
I encountered an ORA-65114 when running a data import.
After this query, I got the result below :
select
fs.tablespace_name "Tablespace",
(df.totalspace - fs.freespace) "Used MB",
fs.freespace "Free MB",
df.totalspace "Total MB",
round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
(select
tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from
dba_data_files
group by
tablespace_name
) df,
(select
tablespace_name,
round(sum(bytes) / 1048576) FreeSpace
from
dba_free_space
group by
tablespace_name
) fs
where
df.tablespace_name = fs.tablespace_name;
Tablespace, Used MB, Free MB, Total MB, PCT Free
SYSTEM 1565 6 1571 0
SYSAUX 3878 922 4800 19
DBFS_DATA 47 53 100 53
UNDO_4AAE2 95 5 100 5
DATA 1539 13921 15460 90
UNDO_9 819 205 1024 20
We can see that the data tablespace has sufficient space (pct free = 90%).
I think that it has something to do with the 20 Gb of an autonomous DB but how can I redistribute disk usage between tablespaces or free some disk space
Thanks a lot for your help.