Oracle Help for the Web

Create/Edit a Schema

| Field Descriptions | Related Help Topics | Additional Information | Locating this Page |

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.

Field Descriptions

Field	Description
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 OracleAS Portal portal users can map for administrative purposes. Every OracleAS 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 OracleAS Portal is installed. If you select the Use this Schema for Portal Users check box, an OracleAS 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.

Related Help Topics

Next Steps:

Edit schema step 2: Grants

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Locating this Page

To locate this page in OracleAS Portal:

On the Portal Builder page, click the Navigator link.
Click the Database Objects tab.
Click Create New...Schema.

Copyright © 2005, Oracle. All rights reserved.