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: 8944
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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 07 12:20:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.