Welcome 微信登录

首页 / 数据库 / MySQL / Oracle 10g stored outline迁移到11g

测试环境是:DB: 11.2.0.3 ,10.2.0.4 OS：RHEL 4.8把Oracle 10G中的stored outline数据迁移到11G中1，导出测试表中的数据
  1. [oracle10g@rhel4 sql]$ expdpscott/oracle tables=test1directory=testdumpfile=test1.dmp;
  3. Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 06 April, 2013 21:14:00
  5. Copyright （c） 2003, 2007, Oracle.All rights reserved.
  7. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  9. Starting "SCOTT"."SYS_EXPORT_TABLE_01":scott/******** tables=test1directory=testdumpfile=test1.dmp
  10. Estimate in progress using BLOCKS method...
  11. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  12. Total estimation using BLOCKS method: 2.875 GB
  13. Processing object type TABLE_EXPORT/TABLE/TABLE
  14. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
  15. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  16. Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  17. . . exported "SCOTT"."TEST1" 4.636 MB 50091 rows
  18. Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
  19. ******************************************************************************
  20. Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  21. /tmp/test1.dmp
  22. 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.dmpparfile=query.par
  3. Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 06 April, 2013 21:46:18
  5. Copyright （c） 2003, 2007, Oracle.All rights reserved.
  7. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  9. Starting "OUTLN"."SYS_EXPORT_TABLE_02":outln/******** directory=testTABLES=（OL$,OL$HINTS,OL$NODES） dumpfile=outln.dmp parfile=query.par
  10. Estimate in progress using BLOCKS method...
  11. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  12. Total estimation using BLOCKS method: 640 KB
  13. Processing object type TABLE_EXPORT/TABLE/TABLE
  14. Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  15. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
  16. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  17. Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  18. Processing object type TABLE_EXPORT/TABLE/POST_TABLE_ACTION
  19. . . exported "OUTLN"."OL$HINTS"11.59 KB 5 rows
  20. . . exported "OUTLN"."OL$" 9.070 KB 1 rows
  21. . . exported "OUTLN"."OL$NODES"7.078 KB 1 rows
  22. Master table "OUTLN"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
  23. ******************************************************************************
  24. Dump file set for OUTLN.SYS_EXPORT_TABLE_02 is:
  25. /tmp/outln.dmp
  26. Job "OUTLN"."SYS_EXPORT_TABLE_02" successfully completed at 21:46:23
  28. [oracle10g@rhel4 tmp]$ cat query.par
  29. 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"）"
  30. [oracle10g@rhel4 tmp]$
  • 1
  • 2
  • 3
  • 下一页
MySQL中排序在SQL优化中的部分解析InnoDB 中foreign key使用注意事项相关资讯      ORACLE 10G  Oracle 11g 
  • Oracle 10g（10.2.0.4）升级到10.2.0  （04月10日）
  • Oracle 11gClone安装方法  （08/24/2015 20:25:41）
  • Oracle 11g中和SQL TUNING相关的新  （08/12/2015 11:22:52）
  • Oracle 11g导入到10g引起的错误  （11/16/2015 10:55:27）
  • Oracle 11g 导库导不出空表问题  （08/19/2015 19:55:58）
  • Oracle 10g实现只读表的N种方法  （08/05/2015 10:54:35）
本文评论 查看全部评论 （0）
表情： 姓名： 字数