This discussion is archived
0 Replies Latest reply: Jul 7, 2011 8:55 AM by 874031 RSS

Restoring LOBs via SQL

874031 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points