Learning is not a spectator sport

Datapump TTS quick tip

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”

  1. oracleman consulting Avatar
    oracleman consulting

    brilliant, thx

    Reply
  2. Noons Avatar
    Noons

    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

Leave a reply to oracleman consulting Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trending