Create/Edit a Schema

Use this page to create a new Oracle database schema (also known as an Oracle database user account). Schemas can be used to store database portlets and data in the database.

This page contains:

Schema

If you are creating a new schema, enter a name to identify it. If you are editing an existing schema, this field displays the schema's name.

Password

Enter the password you want to assign to the schema. Users will enter this password when logging into the Oracle database as this schema.

Asterisks (*) appear for each character you type.

Confirm Password

Enter the same password you entered in the Password field to confirm you want to use it.

Default Tablespace

Choose a default tablespace that will be used to store any database objects created by the schema.

Temporary Tablespace

Choose a tablespace that will be used by the schema for creation of temporary storage for operations such as sorting table rows.

ORACLE Profile

Choose an Oracle resource profile for the new schema.

Note You must use Oracle SQL commands to create new profiles. Refer to the Oracle documentation for more information.

Use this Schema for Portal Users

Select this check box to add the schema to the list of database schemas to which Oracle Portal portal users can map for administrative purposes.

Every Oracle Portal user must be associated with a database schema. By default, the name of this schema is <portal>_public, where portal is the name or the schema in which Oracle Portal is installed. If you select the Use this Schema for Portal Users check box, a Portal user can be mapped instead to the schema you are currently creating.

Notes

Blank characters are not allowed in the name. Type an underscore character to add a space in a name. For example, you can name a schema MY_SCHEMA, but not MY SCHEMA.
Special characters (other than the underscore character) are not allowed in the name. For example, these names would NOT be allowed: bad%schema, not*allowed*schema.
The name must be unique within the schema that owns it.

Schema	If you are creating a new schema, enter a name to identify it. If you are editing an existing schema, this field displays the schema's name.
Password	Enter the password you want to assign to the schema. Users will enter this password when logging into the Oracle database as this schema. Asterisks (*) appear for each character you type.
Confirm Password	Enter the same password you entered in the Password field to confirm you want to use it.
Default Tablespace	Choose a default tablespace that will be used to store any database objects created by the schema.
Temporary Tablespace	Choose a tablespace that will be used by the schema for creation of temporary storage for operations such as sorting table rows.
ORACLE Profile	Choose an Oracle resource profile for the new schema. Note You must use Oracle SQL commands to create new profiles. Refer to the Oracle documentation for more information.
Use this Schema for Portal Users	Select this check box to add the schema to the list of database schemas to which Oracle Portal portal users can map for administrative purposes. Every Oracle Portal user must be associated with a database schema. By default, the name of this schema is <portal>_public, where portal is the name or the schema in which Oracle Portal is installed. If you select the Use this Schema for Portal Users check box, a Portal user can be mapped instead to the schema you are currently creating.