SnowConvert AI - Schemas¶

备注

本文档的此页内容仅适用于 Oracle。

Oracle 评估报告的“架构”部分。

包含对象的架构的数量¶

Represents the number of schemas that contain identified top-level objects. Each different schema name will only count as one single schema. In case an object does not have an explicit schema in its name, SnowConvert AI will count all of those names as one single schema because it is assumed that those objects are defined in the default schema of Oracle.

必须注意的是，这个数字只会随着用于创建顶级对象的名称而增加，对对象名称的引用不会计入该评估值。

警告

在 Oracle 中，数据库链接这一顶级对象未在任何架构中定义，因此该顶级对象不计入此评估值。

示例¶

CREATE TABLE schema1.table1 (col1 VARCHAR(255));
CREATE TABLE SCHEMA1.table2 (col1 VARCHAR(255));

CREATE TABLE schema2.table3 (col1 VARCHAR(255));

CREATE TABLE "SCHEMA3"."table4" (col1 VARCHAR(255));
CREATE TABLE "schema3"."table5" (col1 VARCHAR(255));

CREATE TABLE table6 (col1 VARCHAR(255));
CREATE TABLE table7 (col1 VARCHAR(255));

Copy

包含对象的预期架构数： 5

Explanation: Since table1 and table2 come from the same schema only one schema will be counted for those two objects. With the schema name of table3 that will count as another different schema and finally. table4 and table5 have the schema names with double quotes and with uppercase and lowercase, this will make these two schemas count as different ones. table6 and table7 do not have an explicit schema name so SnowConvert AI will assume that both objects come from the same default schema.