11g里创建手工sample schemas
如果建数据库时没有选择建sample schemas，可以用以下步骤手工创建:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> @$ORACLE_HOME/demo/schema/@mkplug.sql
执行这个脚本前面需要输入的7个参数都是密码,从第八个参数开始输入以下值(注意路径)
Enter value for 8: example.dmp
Enter value for 9: example01.dfb
Enter value for 10: /opt/app/oracle/oradata/example01.dbf
Enter value for 11: /opt/app/oracle/product/11.2.0/dbhome_1/demo/schema/
Enter value for 12: /opt/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/
mkplug.sql里不包含scott, 要安装scott需要执行$ORACLE_HOME/rdbms/admin/utlsampl.sql
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> @$ORACLE_HOME/demo/schema/@mkplug.sql
执行这个脚本前面需要输入的7个参数都是密码,从第八个参数开始输入以下值(注意路径)
Enter value for 8: example.dmp
Enter value for 9: example01.dfb
Enter value for 10: /opt/app/oracle/oradata/example01.dbf
Enter value for 11: /opt/app/oracle/product/11.2.0/dbhome_1/demo/schema/
Enter value for 12: /opt/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/
mkplug.sql里不包含scott, 要安装scott需要执行$ORACLE_HOME/rdbms/admin/utlsampl.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/37279/viewspace-1848065/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
