+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Blog

    • Home
    • Blog
    • 19c Standard Edition permits 3 PDBs per CDB

    19c Standard Edition permits 3 PDBs per CDB

    • Posted by John Watson
    • Categories Blog, RDBMS Server
    • Date November 4, 2019

    A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database. Apart from the obvious advantage of being able to do some database consolidation, it gives SE2 users the ability to do those wonderful PDB clone operations. Just one example: if my test database is currently a single tenant CDB I can make a clone of it before some test runs. Like this:

    Before cloning, I do like to create an after clone trigger in the source PDB (in this example named atest) to do any changes that might be necessary in the clone, such as disabling the job system:

    conn / as sysdba
    alter session set container=atest;
    create trigger stopjobs after clone on pluggable database
    begin
    execute immediate 'alter system set job_queue_processes=0';
    end;
    /

    Then do the clone:

    conn / as sysdba
    create pluggable database atestcopy from atest;
    alter pluggable database atestcopy open;

    It is that simple because I always use Oracle Managed FIles. The new clone will be registered with the listener as service name atestcopy, the trigger will have stopped jobs and then dropped itself. At any stage I can then, for example, use the clone to revert to the version of atest as it was at clone creation time simply by dropping atest and renaming atestcopy:

    conn / as sysdba
    drop pluggable database atest including datafiles;
    alter session set container=atestcopy;
    alter system set job_queue_processes=100;
    alter database rename global name to atest;

    That is as good as a Database Flashback – which of course you don’t have have in SE.
    —
    John Watson
    Oracle Certified Master DBA
    https://skillbuilders.com

    • Share:
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Previous post

    Webinar - Universal Theme - Basic Principles to Modern Applications 10/29
    November 4, 2019

    Next post

    How to move a table from one schema to another
    24 December, 2019

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.