CreateSchema
Creates a schema definition for a table in Oracle Fusion Cloud SCM, ensuring alignment with system requirements.
CreateSchema
Creates a local schema file (.rsd) from an existing table or view in the data model.
The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.
The provider checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the provider.
Input
Name | Type | Accepts Output Streams | Description |
TableName | String | False | The name of the table for which the schema is being generated. This table name ensures that the correct table structure, including its columns, data types, and constraints, is extracted for documentation or migration purposes. |
SchemaName | String | False | The name of the schema that defines the database structure. This schema specifies the collection of tables, views, indexes, and other database objects within the database instance. |
FileName | String | False | The full file path and name where the generated schema should be saved (for example, 'C:\\scripts\\Accounts.rsd'). If this path is provided, the schema definition is written directly to the specified file. |
SimplifyNames | String | False | Indicates whether column names in the output should be simplified for readability. When this field is enabled, complex or system-generated column names can be adjusted to more user-friendly versions. |
FileStream | String | True | The output stream where the generated schema is written if 'FileName' is not set. This field allows for in-memory schema creation and retrieval without writing to a physical file. |
Result Set Columns
Name | Type | Description |
Result | String | Indicates whether the schema was successfully generated and downloaded. This field returns a status such as 'Success' (if the schema is generated without issues) or 'Error' (if the process fails), along with relevant details. |
FileData | String | The generated schema encoded in Base64 format. This output is returned only if neither 'FileName' nor 'FileStream' is set, allowing for retrieval of the schema as an encoded data string for secure transmission or processing. |