We use cookies to optimize our website and our service.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Mike
Very interesting paper and very well written. I do have a question on something that wasnt very clear. There are hints with common users but it is still now very clear. Question is about "ORACLE" add on schema’s. Not sure what is a good example in 12c – but I am referring to items like say a spatial or xdb. Are these common users. Are these installed in sysaux. are there PDB specific sysaux’s. Can theer be multiple spatial versions in a CDB. How does this reconcile with the libraies that are outside the database (at the OS level)
regards
Thanks
Raj Pande
Raj,
thanks for your questions.
First of all, all Oracle supplied users (CTXSYS, SYS, OLAPSYS, MDSYS) are common users. To my knowledge only APEX can solely exist in different incarnations within a PDB and the CDB. A PDB can have less options than the CDB but the CDB has to have all options.
Regarding the options depending on libs … well, that’s a very good question I can’t answer at the moment.
The CDB requires all-in – but if I unlink let’s say partitioning or Data Vault this will hit all PDBs as well. Actually this is still under discussion internally.
I will update the blog as soon as I have a clear view on this.
Thanks and kind regards
Mike