Oracle blob jpg photo extract

Asked By 30 points N/A Posted on -
qa-featured

How to extract Oracle blob jpg photo for different modules and forms? I am preparing lecture for my new employees.

SHARE
Best Answer by Niktha Busch
Best Answer
Best Answer
Answered By 0 points N/A #149402

Oracle blob jpg photo extract

qa-featured

Hey Daniel,

To extract Oracle blob jpg, do the following –

I have to export table with lob column (3 GB is the size of lob segment) and then drop that lob column from table. Table has about 350k rows.

1. Make a new table space
2. Copy the table with CTAS being a new table space
3. Change it to NOLOGGING
4. Use APPEND hint to insert all rows.
5. Use transport table space feature to extract the rows.
6. Drop previously created table space

That should do it.

Answered By 0 points N/A #149403

Oracle blob jpg photo extract

qa-featured

Hello Daniel,

You have to make a new table space => copy the table with CTAS being a new table space => change it to NOLOGGING => use APPEND hint to insert all rows => use transport table space feature in order to extract the rows => and finally drop the previous created table space.

Login/Register to Answer

Related Questions