ORA-01110: data file ...
Oracle 19.16
After the following steps:
- alter tablespace <Tablespaces> add datafile '<datafile>' SIZE xxG;
- ALTER DATABASE DATAFILE '<datafile>' OFFLINE DROP;
The datafile contains no data: i have checked with
select count(*) from dba_extents where file_id = ...;
How/Is it possible to get rid of this 2 datafiles?
Alert-Log contains these messages:
ORA-01110: data file ...