expdp Archives - AskDba.org Weblog

12c: Exporting Database Views as Tables

Post author:Amit Bansal
Post published:22 July, 2013
Post category:12c
Post comments:1 Comment

Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with…

Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time

Post author:Saurabh Sood
Post published:23 June, 2009
Post category:10g
Post comments:15 Comments

Few days back I got a request from development team to generate hourly export dumps of few schemas. Following were the requirements: 1. Dumpfile name should contain current date and…