Database Administration (MOSC)

MOSC Banner

What is the difference between a single db with lots of schemas -different apps and PDB in 12c

edited Aug 25, 2014 9:49AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi experts.

What is the difference between a single db with lots of schemas -different apps and PDB in 12c?

For me Pdb in 12c is complicating things because it needs a system sysaux tablespaces for each Pdb and it acts as a separate db.

From:  Oracle 12c New Features - Oracle Solutions - Enterprise Solutions - Dell Community

The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).

Container Database (CDB): Every CDB has one root container (CDB$ROOT), one seed PDB (PDB$SEED) and zero or more user created PDB’s.

CDB$ROOT: it is exactly one root for each CDB which stores oracle supplied metadata (data dictionary) and common users.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center