1 / 4

Data Pump Mode

Data Pump Mode

AtulWadhai
Download Presentation

Data Pump Mode

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Pump Mode Oracle DBA professionalis there for you to make your career in Oracle. During the previous year we have seen 3 new editions of Oracle: 9i, 10g and 11g.There is an often requested and I do ask well which is the best or which are the best popular functions of Oracle. 1. Real Program Groups and Information Secure in 9i 2. Grid Management and Information Push in 10g 3. Automatic SQL Adjusting and Edition-Based Redefinition in 11g There have been so many new, excellent and essential functions but let us say that they all are in the improvement of humanity and the latest growth of IT. Perhaps? In 11gR2, Oracle chooses introducing Information Push Heritage Method to be able to offer in reverse interface for programs and parameter data files used for exclusive export/import programs. The certification temporarily says: “This function allows customers to proceed using exclusive Trade and Transfer programs with Information Push Trade and Transfer. Growth time is decreased as new programs do not have to be designed.” If you examine AristaDBA’s Oracle Weblog and browse the first three sections you will probably see what it is about. I completely believe the fact with all published there. And I don’t really get it, why do we have Information Push Heritage Mode? Oracle customers poorly need it? Exp/imp was so, so great that we must have it back? How about RAC Heritage Method if I want to use gc_files_to_lock or freeze_db_for_fast_instance_recovery parameters? There really was a parameter known as freeze_db_for_fast_instance_recovery, I am not creating this up. Run this one: SELECT kspponm, DECODE(ksppoflg, 1,'Obsolete', 2, 'Underscored') as "Status"

  2. FROM x$ksppo WHERE kspponm like '%freeze%' ORDER BY kspponm; However, the Information Push Heritage Method function prevails and once you use any traditional export/import parameter you allow data pump in legacy mode. Just one parameter is enough. In Oracle language, Information Push goes into legacy mode once it chooses a parameter exclusive to exclusive Trade or Transfer is existing. Of course some factors like shield, make, pack, object_consistent, recordlength, resumable, research, gather, filesize, tts_owners, streams_configuration and streams_instantiation are merely ignored. Now, here is a paradox or simple certification error: deferred_segment_creation is set to TRUE automatically in 11gR2. Have a look at the documentation: SQL> create table TEST (c1 number, c2 varchar2(10), c3 date) storage (initial 5M); Table created. SQL> select bytes, blocks, segment_type, segment_name from dba_segments where segment_name='TEST'; no rows selected C:\>expdp julian/password dumpfile=data_pump_dir:abc_%U.dat schemas=julian include=TABLE:in('TEST') logfile=abc.log buffer=1024 Export: Release 11.2.0.2.0 - Production on Wed May 11 07:53:45 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Legacy Mode Active due to the following parameters: Legacy Mode Parameter: "buffer=1024" Location: Command Line, ignored.

  3. Legacy Mode has set reuse_dumpfiles=true parameter. Starting "JULIAN"."SYS_EXPORT_SCHEMA_01": julian/******** dumpfile=data_pump_dir:abc_%U.dat schemas=julian include=TABLE:in('TEST') logfile=abc.log reuse_dumpfiles=true Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 0 KB Processing object type SCHEMA_EXPORT/TABLE/TABLE . . exported "JULIAN"."TEST" 0 KB 0 rows Master table "JULIAN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded **************************************************************************** ** Dump file set for JULIAN.SYS_EXPORT_SCHEMA_01 is: C:\ORACLE\ADMIN\JMD\DPDUMP\ABC_01.DAT Job "JULIAN"."SYS_EXPORT_SCHEMA_01" successfully completed at 07:54:07 But it is not true that you cannot export tables with no segments. Here is the proof: C:\>exp userid=julian/abc file=C:\Oracle\admin\JMD\dpdump\a.dmp tables=julian.test Export: Release 11.2.0.2.0 - Production on Wed May 11 08:31:08 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

  4. Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ... . . exporting table TEST 0 rows exported Export terminated successfully without warnings. But ignore about this Heritage Method. Do not use. Imagine it does not quit Let us look now at some new popular functions of Information Push. Remember that in 11gR2 several of limitations have been already removed: – The limitation that in TABLES mode all tables had to live in the same schema. – The limitation that only one item (table or partition) could be specified if wildcards were used as aspect of the item name. For RAC users: Information Push employee procedures can now be allocated across RAC circumstances, a aspect of Oracle RAC circumstances, or limited to the example where the Information Push job begins. It is also now possible to begin Information Push tasks and run them on different Oracle RAC circumstances at the same time. For XMLType line users: there is a new DISABLE_APPEND_HINT value on the DATA_OPTIONS parameter which hinders the APPEND sign while running the information item. For EBR users: particular versions can be released and brought in. Using the SOURCE_EDITION parameter upon trade and the transfer TARGET_EDITION parameter you can trade a certain version of the data source and transfer into a particular version of the data source. Information Push is among the Oracle resources with least bugs! Although it challenging to say these days what is a bug, what is an element, what is a copy enhancement. There are about 100 kinds of insects. Thus our Oracle training courseis always there for you to be DBA professional.

More Related