• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: datapump

August 30, 2021 Uncategorized

21c … a more secure DataPump

With the new release of every product from every software vendor, there are always the big banner headline features that

Continue reading

June 14, 2021 Uncategorized

Get complete DDL for a schema

There are plenty of tools out there that you can use to get DDL scripts for various objects in the

Continue reading

June 24, 2020 Uncategorized

How to migrate to SECUREFILE with DataPump

These tweets somewhat befuddle me. Because to be honest, if I no matter if I say “Yes” or “No” ,

Continue reading

November 6, 2019 Uncategorized

Cloning a schema with a one line command

In the world of DevOps, continuous integration and repeatable test cases, the demand for being able to quickly build a

Continue reading

January 12, 2018 Uncategorized

Clone a table

Sometimes doing a CREATE TABLE AS SELECT is all we need to copy the data from an existing table.  But

Continue reading

April 18, 2017 Uncategorized

Transportable Tablespace–part 2

I did a little demo of sharing a tablespace between two databases a few days back – you can see

Continue reading

November 3, 2015 Uncategorized

Datapump cleanup

Sometimes if you’ve been building data pump jobs via PL/SQL, you might get some part of it incorrect, and thus

Continue reading

May 25, 2015 Uncategorized

Datapump TTS quick tip

I was trying to transport a large number of tablespace datafiles from one database to another, and impdp kept crashing

Continue reading

January 13, 2015 Uncategorized

Data Pump import makes me crabby

I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Tweets by connor_mc_d

    Top Posts & Pages

    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to TREAT data in a CLOB as JSON
    • Extended VARCHAR2 and the hidden LOB
    • How to generate random unique values
    • Modifying tables without losing materialized views
    • No more stale statistics in 19c
    • Generating INSERT scripts that run fast!
    • 19c Express Edition #JoelKallmanDay
    • Free In-memory in Oracle Database 19c
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 other followers
      • Already have a WordPress.com account? Log in now.
      • Learning is not a spectator sport
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar