Examples of using Pluggable database in English and their translations into German
{-}
-
Colloquial
-
Official
-
Ecclesiastic
-
Medicine
-
Financial
-
Ecclesiastic
-
Political
-
Computer
-
Programming
-
Official/political
-
Political
But what about a pluggable database?
Pluggable Databases are supported in Toad and you can list the sessions for your CDB and PDBs in one view.
Because thats the requirement for Flashback Pluggable Database.
Regardless if they are Pluggable databases or single databases, on one or several servers.
What if you try to create an additional pluggable database?
If you want to plug in the Pluggable database into another CDB that one has to be migrated as well.
In this example a container database named"CDBACFS" with a pluggable database"PLUGACFS1" is created.
There have been many Blogs around Pluggable Databases and very often the bloggers(and DBAs of course) are complaining that….
The problem: I am not able to prevent my keen DBAcolleagues from creating an additional PDB with CREATE PLUGGABLE DATABASE.
At first you should revoke CREATE PLUGGABLE DATABASE from all Users and Roles.
If you create a Pluggable Database from the seed(PDB$SEEE) Data Guard is able to handle this so there is no outage or failure for the configuration.
In the following example I will describe how to clone a pluggable database and synchronize Data Guard.
This might not be a bad idea for the naming convention inStandard Edition as you have no chance to create more pluggable databases.
You will learn how to create,copy and move the new Pluggable Databases(PDBs) and familiarize you with the changes in daily operations.
For the following example we work with a simple 12c Multitenant Database with CDB(the ROOT Container) and an attached Pluggable Database PDB.
As a last step the Data Dictionary of the pluggable database must be cleaned, as many elements are not needed in the PDB anymore.
Another new feature in 12.1.0.2 is theability to specify an individual path(CREATE_FILE_DEST) for the pluggable database while using Oracle Managed Files OMF.
But if you create a Pluggable Database from an existing one(Clone) the datafiles will not be transfered or created but Data Guard will fail.
With these few steps the"old" database WOLFGANG is now availableas a beautiful, new pluggable database WOLFGANG and can finally be opened.
There have been many Blogs around Pluggable Databases and very often the bloggers(and DBAs of course) are complaining that the individual pluggable databases are competing for resources since there is only one SGA, one set of Redo logs and one Undo-Tablespace.
With a multitenant database datapatch is run for all pluggable databases automatically, which are opened for writing, and for the PDB$SEED as well.
In a multitenant environment you can connect directly toyour Pluggable Database, but also jump between Pluggable Databases and the Root Container back and forth.