手机版
你好,游客 登录 注册
背景:
阅读新闻

Oracle 10g stored outline迁移到11g

[日期:2013-04-08] 来源:Linux社区  作者:luoping [字体: ]

测试环境是:DB: 11.2.0.3 ,10.2.0.4 OS:RHEL 4.8

Oracle 10G中的stored outline数据迁移到11G中

1,导出测试表中的数据

  1. [oracle10g@rhel4 sql]$ expdp scott/oracle tables=test1directory=testdumpfile=test1.dmp;
  2. Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 06 April, 2013 21:14:00
  3. Copyright (c) 2003, 2007, Oracle. All rights reserved.
  4. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  5. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  6. Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=test1directory=testdumpfile=test1.dmp
  7. Estimate in progress using BLOCKS method...
  8. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  9. Total estimation using BLOCKS method: 2.875 GB
  10. Processing object type TABLE_EXPORT/TABLE/TABLE
  11. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
  12. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  13. Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  14. . . exported "SCOTT"."TEST1" 4.636 MB 50091 rows
  15. Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
  16. ******************************************************************************
  17. Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  18. /tmp/test1.dmp
  19. Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 21:14:18

2,导出stored outline,name为new_outline_1

  1. [oracle10g@rhel4 tmp]$ expdp outln/oracle directory=testTABLES=(OL\$,OL\$HINTS,OL\$NODES) dumpfile=outln.dmp parfile=query.par
  2. Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 06 April, 2013 21:46:18
  3. Copyright (c) 2003, 2007, Oracle. All rights reserved.
  4. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  5. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  6. Starting "OUTLN"."SYS_EXPORT_TABLE_02": outln/******** directory=testTABLES=(OL$,OL$HINTS,OL$NODES) dumpfile=outln.dmp parfile=query.par
  7. Estimate in progress using BLOCKS method...
  8. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  9. Total estimation using BLOCKS method: 640 KB
  10. Processing object type TABLE_EXPORT/TABLE/TABLE
  11. Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  12. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
  13. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  14. Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  15. Processing object type TABLE_EXPORT/TABLE/POST_TABLE_ACTION
  16. . . exported "OUTLN"."OL$HINTS" 11.59 KB 5 rows
  17. . . exported "OUTLN"."OL$" 9.070 KB 1 rows
  18. . . exported "OUTLN"."OL$NODES" 7.078 KB 1 rows
  19. Master table "OUTLN"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
  20. ******************************************************************************
  21. Dump file set for OUTLN.SYS_EXPORT_TABLE_02 is:
  22. /tmp/outln.dmp
  23. Job "OUTLN"."SYS_EXPORT_TABLE_02" successfully completed at 21:46:23
  24. [oracle10g@rhel4 tmp]$ cat query.par
  25. query=ol$:"where ol_name=upper('new_outline_1')",OL$HINTS:"where ol_name=upper('new_outline_1')",OL$NODES:"where ol_name=upper('new_outline_1')"
  26. [oracle10g@rhel4 tmp]$
linux
相关资讯       ORACLE 10G  Oracle 11g 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有��法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款