MindMajix is creating and shaping brilliant minds that are efficient and versatile to scale greater heights in the present technological world. We also offer placements based solely on merit and guarantee a wide span of hands-on training projects with our ongoing developmental processes.
The data entrusted to Oracle is stored in a series of data files on disk drives of the computer that is running the Oracle RDBMS. It would be nice if the simple categorization structure described previously covered all possible DBA job descriptions. However, there are many nuances in the roles and responsibilities that should be considered in light of your talents and the “culture” found in your organization. If nothing else, studying other people’s work environments is an interesting pastime. When you are a consultant, you need something to get you through certain routine assignments.
An in-depth knowledge of an Oracle DBA 12c / 11g project ensures all the critical components are well-covered. With this knowledge, you can increase your visibility and enhance your efficiency in drawing real connections among different components of DBA.
Oracle DBA 12c (Oracle Database Administration) is responsible for the design, implementation, support and maintenance of databases in everyday enterprises. Oracle DBA role ensures security, performance and efficient availability of data to users and customers.
Dropping Tablespaces in Oracle DBA:
You can drop a tablespace and its contents (the segments contained in the tablespace) from the database, if the tablespace and its contents are no longer required. You must have the drop tablespace system privilege to drop a tablespace.
Once a tablespace has been dropped, the data in the tablespace is not recoverable. Therefore, make sure that all data contained in a tablespace to be dropped will not be required in the future. Also, immediately before and after dropping a tablespace from a database, back up the database completely. This is strongly recommended so that you can recover the database if you mistakenly drop a tablespace, or if the database experiences a problem in the future after the tablespace has been dropped.
When you drop a tablespace, the file pointers in the control file of the associated database are removed. You can optionally direct oracle database to delete the operating system files (datafiles) that constituted the dropped tablespace. If you do not direct the database to delete the datafiles at the same time that it deletes the tablespace, you must later use the appropriate commands of your operating system to delete them.
Learn more about this kind of interesting topics visit: Oracle DBA