0 Replies Latest reply: Jul 7, 2011 10:55 AM by 874031 RSS

    Restoring LOBs via SQL

    874031
      All,
      I have a large data set that I extracted from the database with JDeveloper 11 to create a SQL file. I removed the DB user info from the SQL files and need to reload the info to another user/tablespace, but the data contains some big BLOBs/CLOBs that cannot be loaded with SQL Plus. I was able to get my schema to load, but the data is the big issue. SQL Plus chokes on the file.
      Any help/suggestions? I am trying to develop this as a procedure with the smallest amount of DBA/Developer expertise possible. IMPORT/EXPORT are not options as the DBUSER would need to be varied on many loads.

      Thanks.