12 Things about Oracle 12c -- Part 3

DataPump: Export Views as Tables

Switching from RMAN, DataPump provides a new set of features that allow for increased abilities to export, transform and import data. To that end, Oracle Data Pump allows users to export a view as a table. 

This feature can be utilized whether data pump is accessed via command line, parameter file, or using the DBMS_DATAPUMP package. 

Command-line and parameter file options are the same (obviously). 

In the screenshot above, we are exporting two tables from a PeopleSoft database using the TABLES parameter. We are also exporting a view using the VIEWS_AS_TABLES parameter. 

When executed with these parameters, we see the following output in the log file and standard output: 
and

Along with the data, exported views also include constraints and grants. 

Invoking this feature using the DBMS_DATAPUMP package is done like so: 

DBMS_DATAPUMP.METADATA_FILTER(h1,'VIEWS_AS_TABLES','in (''PSOPRDEFN_VW'')');

Use Cases

Using Oracle Data Pump to transform data from source to target. Using this technique can improve performance of exporting data over database link as well.

Source

http://www.oracle.com/technetwork/database/enterprise-edition/oow2013-data-pump-2044029.pdf


NOTE: There is some foreshadowing in the screenshots above. Regular data pump users may know what it is already. 

Comments

Post a Comment

Popular posts from this blog

Tariffs are bad for you.

Headlines from today state that the new Trump administration will put a 25% tariff on imports from Mexico, and Canada. Additionally, a 10% tariff on goods imported from China.  A tariff is a fee charged by the Federal government on goods coming into the country. That fee is paid by the importer, not the exporter.  For example, Target wants to sell PlayStation in their stores, so they purchase them from Sony, who builds these in China. Target receives the shipment of PlayStations, where they will be charged the tariff. Target pays the tariff to the Government to receive these goods.  Target then must decide how to recoup the additional fees. They can either choose to eat the cost and reduce their revenue, or they can increase the selling cost. The outcome is a combination of the two.  As a result, consumer prices, specifically for food and cars are going to go up. And businesses lose money by having to pay tariffs and selling few items.   For th...
Read more

AWS Re:Invent 2024

 I have the privilege of attending AWS Re:Invent conference from 02-Dec to 06-Dec. Here's my planned schedule for the week.  Sunday, 01-Dec Depart MSP @ 6:45pm CST Arrive LAS @ 8:12pm PST Monday, 02-Dec Design Secure and resilient relational database architectures on AWS Observability-driven development AWS Fundamentals for the accidental SQL Server database administrator Unleashing AWS Agility with Terraform How to navigate your SQL Server Migration journey with AWS Deep Dive into Amazon DynamoDB using Design Puzzles Visionaries in the Stadium w/ Angela Duckworth and some AI folks Tuesday, 03-Dec Identify and manage Amazon Aurora & RDS Snapshots Scalable database solutions with Aurora PostgreSQL Limitless Database Data models for Amazon Neptune using GenAI and diagram-as-code tools Deep Dive into Amazon Aurora query plan management Bingo Night Hashicorp Customer Reception @ Chica Wednesday, 04-Dec AWS Re:Invent 5k Race Essentials for migrating from Oracle to Amazon Aurora...
Read more