Subscriber Count

    466

Subscribe to Posts by Email

Pages

12c Database : Datapump Enhancements : IMPORT (IMPDP)

Here are the some of enhancements for Import (IMPDP) Disabling Logging for Oracle Data Pump Import

You can now use the DISABLE_ARCHIVE_LOGGING Paramaeter to disable logging for table, index or both during import.

Logging is not completely disable but only a small amount is generated. Also don`t forget that there is a database parameter FORCE LOGGING which overwrites this feature.

	Example:
	For schema
	impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=scott1.dmp  schemas=scott TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
	For Index no logging
	impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=scott1.dmp  schemas=scott TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX
	For Table no logging but for other objects logging=Y
	impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=scott1.dmp  schemas=scott 
	TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=DISABLE_ARCHIVE_LOGGING:N:TABLE

 

Creating SecureFile LOBs During Import You can now specify the LOB Storage during import

	example:
	impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=export.dmp LOB_STORAGE:SECUREFILE

 

Compressing Tables During Import You can now specify a Compression method during import

	example:
	impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=export.dmp TRANSFORM=TABLE_COMPRESSION_CLAUSE:"COMPRESS FOR OLTP"

 

Can have timestamp printed for every object that is imported (ofcourse export as well)

		impdp logtime=all test/test DIRECTORY=dpump1 DUMPFILE=export.dmp schemas=test

		Import: Release 12.1.0.1.0 - Production on Tue Sep 15 13:33:16 2013
		Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
		Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
		With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

		15-Sep-13 13:33:19.192: Starting "TEST"."SYS_IMPORT_SCHEMA_01":  test/******** logtime=all directory=test  
		15-Sep-13 13:33:19.347: Estimate in progress using BLOCKS method...
		...		
		15-Sep-13 13:33:46.884: . . imported "TEST"."A"  0 KB       0 rows		
...		...

 

You can now audit all impdp/expd operations with unified auditing

		Example:-
		CREATE AUDIT POLICY policy_name ACTIONS COMPONENT=DATAPUMP { EXPORT | IMPORT | ALL };
		
		Keep policy
		AUDIT POLICY audit_dp_all_pol BY SYSTEM;
		
		Verify the audit reports
		
		SELECT DP_TEXT_PARAMETERS1, DP_BOOLEAN_PARAMETERS1 FROM UNIFIED_AUDIT_TRAIL
		WHERE AUDIT_TYPE = 'DATAPUMP';
		
		DP_TEXT_PARAMETERS1                            DP_BOOLEAN_PARAMETERS1
		---------------------------------------------- ----------------------------------
		
		MASTER TABLE:  "SCOTT"."SYS_EXPORT_TABLE_01",  MASTER_ONLY: FALSE,
		JOB_TYPE: EXPORT,                              DATA_ONLY: FALSE,
		METADATA_JOB_MODE: TABLE_EXPORT,               METADATA_ONLY: FALSE,
		JOB VERSION: 12.1.0.0,                         DUMPFILE_PRESENT: TRUE, 
		ACCESS METHOD: DIRECT_PATH,                    JOB_RESTARTED: FALSE 
		DATA OPTIONS: 0, 
		DUMPER DIRECTORY: NULL  
		REMOTE LINK: NULL, 
		TABLE EXISTS: NULL, 
		PARTITION OPTIONS: NONE 
-Thanks
Geek DBA

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>