众所周知Oracle 10g里面有一套用于演示的schema,如何来安装这些schema呢?
- 使用DBCA建库的时候勾选"Example Schema"的复选框
- 使用companion CD来安装
- 手工创建(其实是rman恢复出来的)
- sqlplus /nolog
- @?/demo/schema/mkplug.sql oracle oracle oracle oracle oracle oracle oracle ?/assistants/dbca/templates/example.dmp ?/assistants/dbca/templates/example01.dfb /u01/app/oracle/oradata/prod/example01.dbf /u01/app/oracle/admin/prod/scripts/ "\'SYS/oracle as SYSDBA\'";
官方说明: http://docs.oracle.com/cd/B19306_01/server.102/b14198/installation.htm#sthref26
