Database Administration (MOSC)

MOSC Banner

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 ...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center