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