(实践应用)Oracle 11g R2 测试schema生成
Oracle测试schema包含HR、SH等用户,在Oracle 11g R2下可以按照如下方式生成
--检查字符集
SQL>select userenv('language') from dual;
若不是US7ASCII则修改字符集2 SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE US7ASCII;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP
2.运行mkplug.sql脚本,前7个参数是password,后4-5个参数(参数数量应该和具体版本有关),设置如下3 cd /u01/app/oracle/product/11.2.0/db_1/demo/schema
SQL>@?/demo/schema/mkplug.sql
·····
specify INPUT metadata import file as parameter 8:
Enter value for 8: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example.dmp
specify INPUT database backup file for tablespace EXAMPLE as parameter 9:
Enter value for 9: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb
specify OUTPUT database file for tablespace EXAMPLE as parameter 10:
Enter value for 10: /u01/app/oracle/oradata/skyHost/example01.dbf
specify OUTPUT log directory as parameter 11:
Enter value for 11: /u01/app/oracle/product/11.2.0/db_1/demo/schema/log/
specify OUTPUT dump file directory as parameter 12:
Enter value for 12: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/
······
mkplug.sql DONE
TO_CHAR(SYSTIMEST
-----------------
20171127 03:45:07
参考资料
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |