Home » Server Options » Multitenant » Best Multitenant Databaes (12.1.0.2, Windows 2016)
Best Multitenant Databaes [message #676857] Wed, 24 July 2019 00:02 Go to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

is it a bad practice to install a application schema in root container?

to me if I install the application schema in root container, it looks like we are going back to non-multitenant database architecture.

many thanks in advance

any official document that explicitly said that we should not create any application schema in root?

https://www.red-gate.com/simple-talk/sql/oracle/getting-started-with-oracle-database-12c-multitenant-architecture/

Quote:

And just like there is no restriction on creating an EMP table-alike table in the System or Sysaux tablespaces, just because it's possible to do, you should never, ever, actually do it!
https://emilianofusaglia.net/2016/09/27/new-to-oracle-multitenant/

Quote:

remember that application data should be stored on Application PDB only!

https://www.oracle.com/technetwork/database/availability/multitenant-maa-2030158.pdf

did not mentioned about explicitly stating that it is bad practice to create schema in root container.


many thanks in advance!

[Updated on: Wed, 24 July 2019 00:14]

Report message to a moderator

Re: Best Multitenant Databaes [message #676859 is a reply to message #676857] Wed, 24 July 2019 01:32 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
is it a bad practice to install a application schema in root container?
If the references you have already found are not enough, I do not think I will be able to convince you.

Quote:
any official document that explicitly said that we should not create any application schema in root?
The Application Container functionality is the closest you can get to this.
Previous Topic: Share data between PDB's in the same CDB
Next Topic: Which Database, CDB or PDB, Should I Use for my Tables, and How Do I Connect Forms12 to CDB?
Goto Forum:
  


Current Time: Thu Mar 28 15:53:33 CDT 2024