Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, dody.

Asked: February 18, 2019 - 6:41 pm UTC

Last updated: February 20, 2019 - 4:06 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hello..

I'm asking if there is anyway to create an Oracle PDB database dynamically, I mean after the completion of some web registration, for example if I want to provide a complete private oracle database for my customer after he/she register to my website.

Thanx in advance.

and Connor said...

Well, you can create a pluggable database with a single statement, eg

create pluggable database NEW_PDB admin user ADMIN identified by MY_PASSWORD create_file_dest='/u01/oradata';


or if you had a pre-configured pdb that you would like to use as a base, you can clone it:

create pluggable database NEW_PDB from BASELINE_PDB file_name_convert=('...','...');


So it shouldn't be too difficult to have a program launched from your website to connect to the database and run those commands.



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Multitenant

All of the benefits of the multi-tenant architecture are covered in this guide