Skip to content

Commit 2cbc0c0

Browse files
ShannonLeavittShannonLeavitt
authored
Merge pull request #18955 from aciortea/patch-2
Update mapping-oracle-schemas-to-sql-server-schemas-oracletosql.md
2 parents 0bc7b95 + 79d2ac7 commit 2cbc0c0

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

‎docs/ssma/oracle/mapping-oracle-schemas-to-sql-server-schemas-oracletosql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -18,7 +18,7 @@ In Oracle, each database has one or more schemas. By default, SSMA migrates all
1818
## Oracle and SQL Server Schemas
1919
An Oracle database contains schemas. An instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] contains multiple databases, each of which can have multiple schemas.
2020

21-
The Oracle concept of a schema maps to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] concept of a database and one of its schemas. For example, Oracle might have a schema named **HR**. An instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] might have a database named **HR**, and within that database are schemas. One schema is the **dbo** (or database owner) schema. By default, the Oracle schema **HR** will be mapped to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database and schema **HR.dbo**. SSMA refers to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] combination of database and schema as a schema.
21+
The Oracle concept of a schema maps to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] concept of a database and one of its schemas. For example, Oracle might have a schema named **HR**. An instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] might have a database named **SampleDatabase**, and within that database are multiple schemas. By default, the Oracle schema **HR** will be mapped to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database and schema **SampleDatabase.HR**. SSMA refers to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] combination of database and schema as a schema.
2222

2323
You can modify the mapping between Oracle and [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] schemas.
2424

0 commit comments

Comments
 (0)