1.导入表的DDL数据:
[lubinsu@localhost db_files]$ impdp lubinsu/lubinsu directory=dpump_dir01 dumpfile=lubinsu.dmp sqlfile=dpump_dir02:lubinsu.sql tables=latn_area_info
Import: Release 10.2.0.1.0 - Production on Thursday, 02 May, 2013 22:14:13
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "LUBINSU"."SYS_SQL_FILE_TABLE_01" successfully loaded/unloaded
Starting "LUBINSU"."SYS_SQL_FILE_TABLE_01": lubinsu/******** directory=dpump_dir01 dumpfile=lubinsu.dmp sqlfile=dpump_dir02:lubinsu.sql tables=latn_area_info
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "LUBINSU"."SYS_SQL_FILE_TABLE_01" successfully completed at 22:14:15
2.这样我们将latn_area_info的DDL信息都导入到了lubinsu.sql文件中,该文件放在目录对象dpump_dir02中
3.将表导入到其他用户下:
[lubinsu@localhost db_files]$ impdp scott/lubinsu directory=dpump_dir01 dumpfile=lubinsu.dmp tables=lubinsu.latn_area_info REMAP_SCHEMA=lubinsu:scott
Import: Release 10.2.0.1.0 - Production on Thursday, 02 May, 2013 22:29:00
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SCOTT"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_TABLE_01": scott/******** directory=dpump_dir01 dumpfile=lubinsu.dmp tables=lubinsu.latn_area_info REMAP_SCHEMA=lubinsu:scott
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."LATN_AREA_INFO" 16.11 KB 14 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SCOTT"."SYS_IMPORT_TABLE_01" successfully completed at 22:29:04
4.这里有个参数remap_table在10g中并没有这个参数,11g的数据泵中新增了该功能,但是1106上有bug无法使用
分享到:
相关推荐
Cloning Oracle Service Bus Projects and Folders.......................................................................... 2-2 Creating Oracle Service Bus Configuration Projects...........................
Setting Profile and Spreadsheet Data Options...................................................................52 Setting Calculation Options for Resource and Role Assignments............................
Excel Importing & Exporting Text Data ---Quickly Turn Raw Data Into Excel Tables, By Scott Hartshorn, epub格式版。
CHAPTER 13 Importing, Exporting, Printing, and Reporting CHAPTER 14 Naming Standards CHAPTER 15 Compare/Merge Utility CHAPTER 16 Features for Agile Teams and Continuous Improvement APPENDIX A ...
9.3 Discuss, Ask, and Answer Using the Message Boards . . . . . . . . . . . 221 9.4 Working together with the Wiki . . . . . . . . . . . . . . . . . . . . . . 233 ii 9.5 Find out what others think or ...
2. a web page viewer for doc88 ebt 3. a DDA downloader for doc88.com CONTENTS PART I: Presenting Flex CHAPTER 1: Introducing Flex. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
Introduction to Word's XML Features An End-to-End Scenario: Creating a Schema and Mapping It into a Word Document Exporting the Mapped XML in the Document to an XML Data File ...
Using Point objects. 434 Using Rectangle objects436 Using Matrix objects440 Example: Applying a matrix transformation to a display object.442 8 Chapter 14: Using the drawing API...447 Basics of using ...
Introduction to Word's XML Features An End-to-End Scenario: Creating a Schema and Mapping It into a Word Document Exporting the Mapped XML in the Document to an XML Data File ...
1.1.1 Generations of the SystemVerilog standard.......................................................2 1.1.2 Donations to SystemVerilog ..................................................................
How This Book Is Organized...........................................................................2 Part I: Breezing through Basic Training...............................................2 Part II: ...
Exporting and Importing Blender Models............................36 Summary...............................................37 Chapter 2 Rendering and Animation Techniques for 3D Polygons ......39 ...
NULL 博文链接:https://fengyonghui.iteye.com/blog/643507
Now the BLOB filed data is uploaded using base64 encoding. (For Delphi 2005/CBuilder 2006 versions and older). 4. QExport4XLS. Now the exported data can be splitted into Excel worksheets by the ...
exp system/oracle owner=oracle file='/tmp/oracle-table-20130509.dmp' log='/tmp/oracle-table-20130509.log'; 导入用户oracle下的表: imp system/oracle file='/tmp/oracle-table-20130509.dmp' log='/...
Database Tour and Database Tour Pro are cross-database tools with large set of db tools and utilities like SQL tool, reporting tool, data converting, exporting, importing utilities and much more. ...
Illustrate your data in a more interactive way by implementing data visualization principles and creating visual stories using Tableau About This Book Use data visualization principles to help you to...
highchars图表用到的基础js,还有其他js需要用到的会一同上传
2.5. Importing and mixing configurations 2.5.1. Referencing XML configuration in JavaConfig 2.5.2. Referencing JavaConfig in XML configuration 2.6. Summary Chapter 3. Advanced wiring 3.1. Environments...
The meat of data analysis occurs in the topics involving statistical techniques, parallelism, concurrency, and machine learning algorithms, along with various examples of visualizing and exporting ...