You
must have the CREATE ALL SCHEMAS global privilege to create a
schema. By default, members of the DBA group have this privilege.
A schema is a collection of database portlets and database objects under the control of a given database user. Each Oracle Portal provider maps to an Oracle database schema. The schema stores the database portlets owned by the provider. In addition, the schema can store the database objects on which the database portlets are based.
You can map a provider to schemas currently in the Oracle database where Oracle Portal is installed. When you create the schema, you must select the Provider Schema check box to designate that providers can be built in the schema.
When you create a Oracle Portal user, you also map the user to a database schema. By default, this schema is <portal>_public, where portal is the schema where Oracle Portal is installed. However, you can map the user to another schema if you have selected the Use this Schema for Portal Users check box when creating the schema.
Oracle Portal offers two methods for creating schemas. You can use the
Schemas portlet on the Administer Database tab of the Oracle Portal home page
Create New Schema choice on the Database Objects tab of the Navigator.
You can also edit any existing schemas to change the password, edit tablespace options, or designate that the schema is for building providers.
You
must have the CREATE ALL SCHEMAS global privilege to create a
schema. By default, members of the DBA group have this privilege.
To create a new database schema using the Schemas portlet
Click 
in the navigation shortcut bar to navigate to the Oracle Portal home
page. On the Oracle Portal home page, click the
Administer Database tab.
In the Schemas portlet, click Create New Schemas. The Create Schema page displays.
In the Schema field, enter a name for the new schema.
In the Password field, enter a password for logging into the schema.
In the Confirm Password field, enter the password again.
Choose a Default Tablespace. The default tablespace will be used to store any database objects or database portlets created in the schema.
Choose a Temporary Tablespace. The temporary tablespace will be used for creation of temporary storage for operations such as sorting table rows.
Choose an Oracle Profile. A profile limits the amount of system and database resources that are available to the schema.
Select the Use this Schema for Oracle Portal Users check box to add the schema to the list of database schemas that Oracle Portal portal users can map to.
Every 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.
Click Create. If you have the MANAGE ANY SCHEMA global privilege, the Create a New Schema page updates with a link at the top of page that you can click to edit any of the options you selected for the schema.
(optional) To edit the options you selected for the schema, click Edit at the top of the page.
To create a new database schema in the database objects navigator:
Click 
on the navigation shortcut bar.
Click the Database Objects tab in the Portal Navigator.
Click Create new ... Schema.
Follow steps 3-11 above.
Notes
This documentation also refers to schemas as Oracle database user accounts. A schema or database user account is different from a Oracle Portal user. You use Oracle database commands or the Schemas portlet to create and edit these user accounts. You can also assign privileges specific to the Oracle database, such as INSERT, UPDATE and DELETE on tables.
You create Oracle Portal users in the Users portlet and can assign to them Oracle Portal-specific schema-level privileges, such as Modify all objects of a given type.