A developer has brought this problem to me and I need some possible
solutions to the below described problem. Thanks in advance for any
assistance.

Two of our remote sites (site a and siteb) have identical database
structures but different data. They store word documents in a table with
a blob datatype column. Sitea (east Coast) has a need to retrieve word
documents periodically from siteb's (West Coast) table and insert it
into their table with the same name and structure. Using a VB6 program
and ODBC Sitea fires up the program and tries to insert into sitea table
selecting data from siteb 's table. An abbreviated statement may look
like:
Insert into sitea.table (select * from siteb.[Email Address Removed] The actual
sql string is much more detailed with column names, schema owmer (same
at both sites) and a where clause. The database link is in place and
active.

Any possible solutions, using Oracle architecture.

This is a conversion effort from SYBASE 12.5 to Oracle 10.2.0.2 soon to
be 10.2.0.3. Previously the word documents were housed on the UNIX
platform and shared. When the documents were updated and the remote site
wanted a copy of the document, SYBASE has a stored Procedure called
XP_CMDSHELL which allows remote ftp of the desired word document(s). We
have developed something similar to this, but the idea is to keep
everything, or as much as possible, in the database.

Our Oracle RDBMS is Version 10.2.0.2 running AIX64 Version 5.3.3.

Any help or suggestions would be appreciated

Thanks,
Gil Bruce
Oracle Systems DBA
Naval Supply Information Systems Activity
Mechanicsburg, PA


Oracle LazyDBA home page