&password_sys &password_oe &password_sh &logfile_dir &vrsÄEFINE veri_spool = &password_system &veri_spool SET SHOWMODE &password_bi &default_ts &temp_ts &password_sys %s_shPath% &logfile_dir &vrs SET SHOWMODE &password_sh &default_ts &temp_ts SET SHOWMODE &password_ix &default_ts &temp_ts &password_oe &password_sys %s_pmPath% &logfile_dir %s_pmPath% SET SHOWMODE &password_pm &default_ts &temp_ts &password_hr &password_sys %s_oePath% &logfile_dir &vrs SET SHOWMODE &password_oe &default_ts &temp_ts SET SHOWMODE &password_hr &default_ts &temp_ts PROMPT specify log file directory (including trailing delimiter) as parameter PROMPT specify temporary tablespace as parameter 10: PROMPT specify default tablespace as parameter 9: PROMPT specify password for BI as parameter 8: PROMPT specify password for SH as parameter 7: PROMPT specify password for IX as parameter 6: PROMPT specify password for PM as parameter 5: PROMPT specify password for OE as parameter 4: PROMPT specify password for HR as parameter 3: PROMPT specify password for SYS as parameter 2: PROMPT specify password for SYSTEM as parameter 1: Rem (please choose your own passwords for security purposes) Rem for SYS, SYSTEM and the schemas as parameters. Rem state, you can call this script and pass the passwords Rem - USAGE: To return the Sample Schemas to their initial Rem anything other than demos and examples Rem - CAUTION: Never use the above mentioned Sample Schemas for Rem - CAUTION: This script will erase the following schemas: Rem the directory structure on your system Rem - OUI instantiates this script during install and saves it Rem please use the Database Configuration Assistant DBCA to Rem If you are unsure about the prerequisites for the Sample Schemas, Rem to the Oracle Database 10g Sample Schemas. Rem This script rees and creates all Schemas belonging Rem mksample.sql - creates all 5 Sample Schemas Rem Copyright (c) 2001, 2003, Oracle Corporation. The text of the mksample.sql script follows: Rem
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |