Oracle - Root Fan

April 10, 2021April 4, 2022

How to Enable Archive Log Mode in Oracle 19c

landscape photography of snow pathway between trees during winter

If you want to enable archive log mode in your Oracle database because you want to backup your database while it’s opened, then you should follow these simple steps.

Be aware that you’ll need to restart your database.

So here we go.

January 16, 2021April 4, 2022

How to Delete a Datafile in Oracle

green grass field and green tress during day time

You should use the DROP DATAFILE and DROP TEMPFILE clauses of the ALTER TABLESPACE command to drop a single datafile or tempfile.

Here are some examples.

ALTER TABLESPACE example1 
DROP DATAFILE '+DGROUP1/example1.dbf';

This other example drops a tempfile.

ALTER TABLESPACE temp 
DROP TEMPFILE '/u02/oracle/data/temp03.dbf';

The database must be open and the datafile should be empty.

You cannot drop datafiles in read-only tablespaces and in the SYSTEM tablespace.