I’ve been working on a few scripts that will be used to build new CDB/PDB environments. At the last minute, the client requested that the PDB names be specific and enumerated. So this got me thinking, is there a way to rename a Pluggable Database (PDB) after it has been built? The answer is yes!
Former co-worker at Oracle, Mike Detrick documents the process over on his blog as well (here). This brief write up will serve as a reminder to the topic as well.
To rename an Oracle Pluggable Database, the following has to be done:
1. Take the Oracle Pluggable Database offline
$ sqlplus / as sysdba
SQL > alter pluggable database <NAME> close;
SQL> alter pluggable database <NAME> open restricted;
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 OGGTST READ WRITE YES
2. Connect to the PDB and rename the PDB
SQL> alter session set container=OGGTST;
SQL> alter pluggable database rename global_name to TESTPDB;
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 TSTPDB READ WRITE YES
3. Bring the renamed PDB back online
SQL> alter session set container=CDB$ROOT;
SQL> alter pluggable database TSTPDB close;
SQL> alter pluggable database TSTPDB open read write;
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TSTPDB READ WRITE NO
Please note that when you change the PDB name, its underlying directory structure will not change.
Enjoy!!!
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Alexandre, L clomid uk buy online However, while PAX6 has been shown to play a critical role in lens development and cataractogenesis 24, 25, the functional role of PAX2 in the lens remains largely unknown
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
The IQPF establishes the rules relating to basic training to gain access to the title of Financial Planner.
Com tanto conteúdo e artigos, alguma vez se deparou com problemas de plágio ou violação de direitos de autor? O meu site tem muito conteúdo exclusivo que eu próprio criei ou
Your style is unique compared to other people I have read stuff from.Thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this site.
Appreciating the time and energy you put into your site and in depth information you present. It’s nice to come across a blog every once in a while that isn’t the same out of date rehashed material. Great read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.
Mitolyn is a cutting-edge natural dietary supplement designed to support effective weight loss and improve overall wellness.
Hi there, just became alert to your blog through Google, and found that it is really informative. I am gonna watch out for brussels. I’ll appreciate if you continue this in future. Lots of people will be benefited from your writing. Cheers!
grupo do facebook? Há muitas pessoas que eu acho que iriam realmente
I’m typically to running a blog and i really recognize your content. The article has really peaks my interest. I am going to bookmark your website and maintain checking for new information.
Businessiraq.com is more than just a directory; it’s a platform that connects talent with opportunity through its robust Job and Tender Directory. Businesses can efficiently advertise job openings while job seekers can easily find positions suited to their skills and career aspirations in Iraq. By incorporating localized SEO strategies that highlight employment opportunities in Iraq and tender submissions, the site maximizes its reach among both employers and potential employees. This not only benefits individual careers but also contributes to the overall growth of the Iraqi economy by filling essential roles across various sectors.
Introducing to you the most prestigious online entertainment address today. Visit now to experience now!
Hey! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!
Have you ever considered writing an ebook or guest authoring on other blogs? I have a blog centered on the same ideas you discuss and would really like to have you share some stories/information. I know my audience would value your work. If you are even remotely interested, feel free to send me an email.
Have funds disappeared on your QIWI wallet?We understand how stressful that can be.Stay calm—our company specializes in recovering missing money from QIWI wallets.With expert knowledge, we’re sure we can assist you.Drop us a message and let’s start the process of getting your money back.