Identity Manager provides sample database scripts that you can modify and use to create tables and indexes. You may choose to use an alternate method to create equivalent tables and indexes, but these requirements must be met:
Tables (or views) must exist with the names specified in the sample DDL
Each named table (or view) must be owned by (or aliased to) the proxy user that is represented as “waveset” in the sample DDL
Each named table (or view) must contain all the columns specified for that table in the sample DDL
Each named column must have a data type that is consistent with the data type specified for that column in the sample DDL
You can modify the sample scripts to suit your environment.
Common changes include:
Specifying a different proxy user
Specifying different tablespaces, or separate tablespaces for tables and indexes
Changing a data type. This is acceptable if a view or the JDBC driver makes the change transparent.
Adding columns. This is acceptable if each column is nullable or defaulted.
Removing or renaming columns. This is acceptable if a view makes this transparent.
Renaming indexes
If you make changes to the sample scripts, then you must make equivalent changes to any sample database upgrade scripts that you receive in the future.