Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

migrate PDF docs from the documentum to BLOB

551264May 29 2008 — edited May 29 2008

We ran utility to migrate 1930 PDF attachments (of size 447 MB) from the documentum to BLOB. Before doing the migration we took the details of available free tablespace.

When we compare the free bytes availability between before and after migration, it shows that about 5.23 GB of tablespace bytes has been occupied for inserting 1930 BLOB's of size 447 MB.
BLOB's datatypes requires how much space?
Is there any efficient way to store the BLOB into the Oracle database?

Oracle version is 9.2.0.7.. will be upgraded to 10g shortly.

All storage parameter has default value.

Please suggest asap,

Thanks & Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2008

Added on May 29 2008

#general-database-discussions

1 comment

317 views