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.