Timeline for Whats the term in Oracle, when I'm speaking about SCHEMAS on SQL Server
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 12, 2018 at 14:35 | history | edited | John K. N. | CC BY-SA 4.0 |
added addition of CDB and PDB to the database comparison as suggested by a_horse_with_no_name;
|
| Dec 12, 2018 at 13:44 | comment | added | John K. N. | If I look at Oracle Database Architecture and 13 Oracle Database Instance then pluggable databases aren't mentioned in the general context of the concepts of Oracle databases and instances. Only in the context of multitennant architecture are CDB (container database) are PDB (pluggable databases) mentioned. I will add a reference. I stand corrected again. | |
| Dec 12, 2018 at 13:28 | comment | added | user1822 | "An Oracle Instance will contain one database" is no longer true since Oracle 12. One instance can contain multiple pluggable databases | |
| Dec 12, 2018 at 13:16 | history | edited | John K. N. | CC BY-SA 4.0 |
modified question after being corrected by Dan Guzman;
|
| Dec 12, 2018 at 13:10 | comment | added | John K. N. | I stand corrected. Thanks for pointing that out. It wasn't scripted out when I was previously checking the SQL Server schema. I re-read the documentation and can verify that your statement is absolute correct. I'll amend that to my answer. | |
| Dec 12, 2018 at 13:04 | comment | added | Dan Guzman |
SQL Server schemas are also linked to users. If an AUTHORIZATION clause is omitted, the authorization (owner) defaults to the user creating the schema. SELECT name, USER_NAME(principal_id) AS schema_owner FROM sys.schemas;
|
|
| Dec 12, 2018 at 9:11 | history | answered | John K. N. | CC BY-SA 4.0 |