Sunday, February 7, 2016

How to create a portal public schema


How to create a portal public schema:

Create the PORTAL_PUBLIC schema.
Change to the PRODUCTION_MIDTIER_HOME/portal/admin/plsql/wws directory and run the following script from SQL*Plus as the SYS user:
SQL> CONNECT SYS/password AS SYSDBA@tnservice_name
@cruser.sql PORTAL PORTAL portal_default_tablespace portal_temporary_tablespace

The response looks similar to the following output:
SQL> @cruser.sql PORTAL PORTAL PORTAL PORTAL_TMP
old   1: select ('&&1'||'_public') t1 from dual
new   1: select ('PORTAL'||'_public') t1 from dual
...
User altered.

No comments:

Post a Comment