• Home
  • About
  • Contact

Database In Action

~ Integrated Approach to Data

Database In Action

Category Archives: Datapump

Excluding Table Partitions – expdp EXCLUDE=TABLE_DATA

April 3, 2013

Oracle Datapump – Using expdp utility excluding table & table partitions in a par file can be managed with the …

Continue reading →

Rate this:

Using DBMS_DATAPUMP – Full Export and Filtering DB Tables (Metadata Filtering)

March 27, 2012

SELECT trim(instance_name), trim(host_name) INTO v_db_name, v_hostname FROM v$instance; v_dp_handle := DBMS_DATAPUMP.open( operation => ‘EXPORT’, job_mode => ‘FULL’, remote_link => NULL, …

Continue reading →

Rate this:

Blog Stats

  • 85,299 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Blogroll

  • AIX Blog
  • Alejandro Vargas
  • Gavin Soorma
  • Mark Rittman
  • Richard Foote
  • Tom Kyte

Recent Posts

  • Weblogic ServerRuntime Monitoring with Shell Script March 9, 2017
  • Creating SQL Plan Baseline (SPB) / Migrating Execution Plan February 15, 2017
  • Handling an Assertion Failure Sybase IQ February 1, 2016
  • Generate / Recreate DDL for all public and private database links with passwords July 24, 2014
  • Insert a word file to BLOB Column – BLOB insert PLSQL June 30, 2014
  • Insert a word file to BLOB Column – BLOB insert PLSQL June 3, 2014
  • Optimizer Null-Aware Anti Join – ORA-07445: exception encountered: core dump [rwsstd()+40] May 22, 2014

Category Cloud

Apex ASM Database Mirroring and Log Shipping (SQL Server) vs Oracle Dataguard Database Vault Data Guard Datapump Digital Economy EXP/IMP Fusion Grid Control Hadoop Hardware IBM Tivoli TSM Index Internet Inventory Listener Long Datatype Mirroring Monitoring MSSQLServer Oracle Database Partitioning Performance PLSQL Real Application Testing & SQL Performance Analyzer Software Solaris Sql Storage Switchover || Failover Sybase IQ Unix Upgrade Weblogic

Archives

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy