René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Structural changes that require a backup

How the backup must be taken depends on the archive log mode that the database is running in.

Archive log mode

The controlfiles must be backed up:
alter database backup controlfile ...

Noarchive log mode

A consistent backup must be made after the modification.