Hi all, I have a number of rarely accessed tables which can contain a large amount of data. These tables reside in a central repository which is size constrained. I would like to be able to export and purge the data from these tables and repopulate them when they need to be accessed. We have a different facility for storing large amounts of data. This facility has Java APIs to accept an input stream and store its contents. I would like to use this facility to store the exported data from my tables.
The question is how? So far the data pump methods I have seen in Oracle work with file system. Is there a way to return a java stream via JDBC (much like you can with a BLOB) that contains the contents of a table? This needs to work both ways. So, from the stream, I need to be able to repopulate the tables. I guess what I am asking is if there is a way to internally convert a query like (select * from table1) into a BLOB and back. Any help is appreciated. Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
