Creating the Portal Schema for Oracle on Windows
This section describes how to create the portal schema.
- Create the ALI tables, indexes, and stored procedures.
Create the ALI tables, indexes, and stored procedures by running
the init_ali_db_oracle.sql script. This script
must be run as the portal database user you created.
Output from the script is saved in the following files
in the scripts directory:
- create_tables_oracle.lst
- stored_procs_oracle.lst
- load_seed_info.lst
- postinst.lst
- (Optional) Create an Oracle SPFILE.
For the benefits of using an SPFILE, refer to Oracle documentation.
To create the SPFILE, run the create_spfile_oracle_nt.sql script.
- Create the Directory tables.
Run the following scripts in order:
- create_tables.sql
- create_functions.sql
- map_alidb_65.sql