Skip to Main Content
  • Questions

  • Plugging non-cdb into a cdb as a pdb

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Sonika.

Asked: November 02, 2017 - 3:37 am UTC

Last updated: January 21, 2019 - 1:03 am UTC

Version: 12.1.0

Viewed 1000+ times

You Asked

Hi,

In test environment, i plugged a non-CDB into an existing multitenant container database
(CDB) as a pluggable database (PDB).
---Non-CDB---
Version: Oracle Database 12c Releases 1 64-bit
Character set: WE8ISO8859P15
National character set: AL16UTF16

---CDB---
Version: Oracle Database 12c Release 1 64-bit
Character set: AL32UTF8

First i did using data pump full export/import and second by using dbms_pdb package.

If i have to do the same trasnport of non-cdb into a cdb as a pdb, but with huge database, which would
be a faster way??
a>using dbms_pdb package or
b>data pump full export/emport


Thank you.

and Connor said...

I dont think 12c Release 1 supports differing charactersets within the one container.

So pretty sure you would *have* to use a data pump in this case.

A better option perhaps would be to move to 12c Release 2, where differing charactersets are allowed *as long as* the container is one of the UTF8 charactersets (eg AL32UTF8).


Rating

  (1 rating)

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

Comments

Better option

Blessing Akiri, January 18, 2019 - 12:37 am UTC

Wouldn't Transportable Tablespace be a better option for a "huge" database? I think TT is better than EXP/IMP to plug in a multi-terabyte db.
Connor McDonald
January 21, 2019 - 1:03 am UTC

Yes in general, but I don't think that applies here. You can't have differing character set pdb's in 12.1
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Multitenant

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