When you issue this statement, oracle database drops the database and deletes all control files and data files listed in the control file If the database used a server parameter file (spfile), then the spfile is also deleted. To specify keep datafiles (the default), the pdb you want to drop must be unplugged To specify including datafiles, the pdb you want to drop must be in mounted mode or it must be unplugged. Sometimes we need to drop/delete the database, especially for the test and development databases Usually, we drop test or development database once the application team’s testing completed and this database seems not to be in use.
Dropping an oracle database erases all data and files Read on to learn how to protect your data before deletion. In this article, we are going to learn how to relocate datafiles in oracle from one mount point to another mount point or disk In other words, you can say that due to insufficient disk space we need to move data files to a different location. In oracle database 10gr1 oracle introduced the rman command drop databse This one simple statement has the ability to completely remove a database including all rman backups with the optional including backups clause
Sometimes you may need to drop oracle database especially in test or development databases Mostly test or development databases are expired when testing or development is done. Dropping an oracle database involves deleting the database and all its associated data files, control files, and redo logs It’s a significant action that can’t be undone, so always ensure you have backups and a solid reason for dropping the database. Mount the database in exclusive restrict mode
OPEN
