11g手工创建sample schemas(Database Examples 安装)

jiawang

SQL> conn / as sysdba

SQL> @$ORACLE_HOME/demo/schema/mkplug.sql


specify password for SYS as parameter 1:


specify password for HR as parameter 2:


specify password for OE as parameter 3:


specify password for PM as parameter 4:


specify password for IX as parameter 5:


specify password for  SH as parameter 6:


specify password for  BI as parameter 7:


specify INPUT metadata import file as parameter 8:


specify INPUT database backup file for tablespace EXAMPLE as parameter 9:


specify OUTPUT database file for tablespace EXAMPLE as parameter 10:


specify OUTPUT log directory as parameter 11:
Enter value for 11:



specify OUTPUT dump file directory as parameter 12:
Enter value for 12: