How to Drop a Pluggable Oracle Database in Vagrant Centos 8

 To drop a Pluggable Database (PDB) in an Oracle database running on a CentOS virtual machine managed by Vagrant, you can use SQL*Plus or SQL Developer, which are common tools for managing Oracle databases. Here's a general outline of the steps to drop a PDB:


1. Connect to the Oracle Database:

   - Open a terminal in your CentOS VM.

   - Launch SQL*Plus by running the following command and providing the necessary login information when prompted:


     ```bash

     sqlplus / as sysdba

     ```


   - This command connects you to the Oracle Database as a superuser (SYSDBA).


2. Switch to the Container Database (CDB) Context:

   - Before you can drop a PDB, you need to switch to the CDB context. Use the following SQL*Plus command:


     ```sql

     ALTER SESSION SET CONTAINER = CDB_NAME;

     ```


   - Replace `CDB_NAME` with the actual name of your CDB.


3. Drop the Pluggable Database:

   - To drop the PDB, you can use the following SQL command:


     ```sql

     DROP PLUGGABLE DATABASE PDB_NAME INCLUDING DATAFILES;

     ```


     Replace `PDB_NAME` with the name of the PDB you want to drop.


   - The `INCLUDING DATAFILES` clause ensures that the data files associated with the PDB are also deleted.


4. Confirm and Commit:

   - SQL*Plus will ask you to confirm the drop operation. Type 'yes' or 'y' to confirm and proceed.


5. Exit SQL*Plus:

   - Once the PDB is dropped, you can exit SQL*Plus by typing:


     ```sql

     exit

     ```


That's it! The specified PDB should now be dropped from your Oracle database. Please be extremely cautious when performing such operations in a production environment, as dropping a PDB permanently deletes its data and cannot be undone. Always ensure you have backups and confirm that you are working with the correct PDB before executing the DROP command.

Comments

Post a Comment

Popular posts from this blog

How to Turn on Wifi Hotspot Centos 8

 To turn on a hotspot in CentOS, you can use the `nmcli` command-line tool, which is a part of NetworkManager. Here are the steps to create a hotspot: 1. Open a terminal window. 2. Check if NetworkManager is running by running the following command:        ```    sudo systemctl status NetworkManager    ```    If it's not running, you can start it with:    ```    sudo systemctl start NetworkManager    ``` 3. Create a new hotspot configuration using `nmcli`. Replace "HotspotSSID" with your desired hotspot name and "HotspotPassword" with your preferred password. You can adjust these values to your liking.    ```    sudo nmcli connection add type wifi ifname '*' con-name Hotspot autoconnect yes ssid HotspotSSID    ```    ```    sudo nmcli connection modify Hotspot 802-11-wireless.mode ap 802-11-wireless.band bg ipv4.method shared    ```   ...
Read more

Current Mental Health Situation

Mental Health is a very important aspect of our lives today. A lot of people are suffering mentally and they need to be heard. It is a unique subject of discussion at this hour in the 21st century. According to the WHO statistics about 44% of people today have a mental issue that needs help. In today's fast-paced world, our mental health has never been more crucial. The ongoing global events have added a layer of complexity to our lives, affecting our emotional well-being in various ways. Let's take a moment to delve into the current mental health situation and explore how we can navigate these challenging times. **The Impact of the Pandemic** The COVID-19 pandemic has undoubtedly left an indelible mark on our mental health. Social isolation, fear of illness, and uncertainty about the future have taken a toll on many individuals. The prevalence of anxiety, depression, and stress has surged, leading to a mental health crisis of its own. **Remote Work and Burnout** The shift to r...
Read more