0 Replies Latest reply on Jul 7, 2011 3:55 PM by 874031

    Restoring LOBs via SQL

      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.