fbpx

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.

How to Change Processes Parameter in Oracle 19c RAC

photo of thunderstorm

In this post I’m going to show you how to change the processes parameter in an Oracle RAC database.

You can use this same method for any RAC parameter that requires instances to be rebooted for the change to take effect.

In an ideal situation, you would just alter system the parameters and then you would stop and start each instance.

But this did not work as expected because some services were only available in one node and not in the other, so I had to relocate them and try again.

I will show you all the details in this post.

Continue reading “How to Change Processes Parameter in Oracle 19c RAC”