Question : I need to bring some data (blobs) from another database. I created global links to enable bidirectional communication. […]
Tag: blob
FREETEMPORARY on blob with no reference
Question : In Oracle 11g, we are using XMLELEMENT to get records from tables. The problem seems to be, however, […]
Are LOBs also backed up if I take dump of all partitions of table individually?
Question : I am taking export of a large table in oracle through datapump. I am taking export of all […]
Do large longtext necessarily slow down a database
Question : I have a MySQL database that is over a million rows, and has a longtext type data column. […]
Export table without BLOB column
Question : I have a big table with BLOB objects and some references from other tables to this one. I […]
MySQL Index for searching for NULL values in text fields
Question : I need to do the simple query SELECT id FROM table WHERE blob_field IS NULL. blob_field is a […]
Does having a big table that I do not query cause the whole DB to be slower?
Question : I have a log table that I use for logging files sent to clients. I’m not querying that […]
BIG Binary column – PostgreSQL 9.2
Question : I’ve got the following table: CREATE TABLE gorfs.inode_segments ( st_ino “gorfs”.”ino_t” NOT NULL, — Inode number the segment […]
postgres backup for specific table with blob oid
Question : I have a table which has an oid column. When I’m taking a backup of this table, it […]
Re-page Oracle tables after removing CLOB fields
Question : I have a table that has a large amount of CLOB data and a large number of records. […]