Learning is not a spectator sport

Datapump TTS quick tip

May 25, 2015

1–2 minutes

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:

transport_datafiles=/long/path/file1,/long/path/file2,/long/path/file3,....

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

transport_datafiles=/long/path/file1
transport_datafiles=/long/path/file2
transport_datafiles=/long/path/file3
....

2 responses to “Datapump TTS quick tip”

oracleman consulting

May 26, 2015 at 8:42 pm

brilliant, thx

Reply
Noons

May 28, 2015 at 1:35 pm

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…

Reply