Create Schemas

Create/Edit a Schema

Use this page to create a new Oracle database schema (also known as an Oracle database user account). Schemas are used to store applications, components, and database components and applications.

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.

Application Schema

Select this check box to make the schema available for creating a applications. Developers with appropriate application access privileges will be able to create components, which will be stored in the schema.

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. Type an underscore character to add a space in a name. For example, you can name a schema MY_SCHEMA, but not MY SCHEMA.

The application 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.
Application Schema	Select this check box to make the schema available for creating a applications. Developers with appropriate application access privileges will be able to create components, which will be stored in the schema.
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.