HomeЛюди и блогиRelated VideosMore From: Mohammad Taseen

Dropping Tablesapce in oracle 12c (DIFFERENT METHODS)

0 ratings | 125 views
The Oracle DROP TABLESPACE command is used to remove a tablespace from the database. In the following example, we will drop the USELESS tablespace from our database using the Oracle DROP TABLESPACE command: Drop tablespace useless; The Oracle DROP TABLESPACE command Oracle will generate an error if objects reside in the tablespace. Do the following to remove all objects in the tablespace prior to using Oracle DROP TABLESPACE command: Drop tablespace useless including contents; Oracle does not clean up after itself wile using the Oracle DROP TABLESPACE command by default. An option exists to force Oracle to clean up after itself using the Oracle DROP TABLESPACE command. The following example illustrates the Oracle DROP TABLESPACE command used with the including contents and datafiles keywords: Drop tablespace useless including contents and datafiles;
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.