CREATE TABLE t AS SELECT * FROM table1@remote_site;
INSERT INTO t SELECT * FROM table1@remote_site;
UPDATE t SET lobcol = (SELECT lobcol FROM table1@remote_site);
INSERT INTO table1@remote_site ...
UPDATE table1@remote_site ...
DELETE FROM table1@remote_site ...
Wednesday, December 12, 2007
Transfer Oracle BLOB from Database Link
Valid Commands to Move BLOB records from remote db to local
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment