Datapump TTS quick tip

I was trying to transport a large number of tablespace datafiles from one database to another, and impdp kept crashing with “PL/SQL: numeric or value error: character string buffer too small.”

It turns out there is a limit on what you can put on a single line in a parameter file.  Hence if you have something like:


then you might run into trouble. It’s easily fixed however – just put the entries one per line



2 thoughts on “Datapump TTS quick tip

  1. You know what scares me?
    In this day and age of “big data”, PCs with multi-GB memory, multiTB main memory servers, we are still seeing overflow errors in Oracle input character fields.
    Someone needs to bring the entire Oracle development group into this millennium…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s