Oracle blob jpg photo extract

Asked By Daniel Nicholass 30 points N/A Posted on - 09/18/2012

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

• Status: Open
• Question Views: 1005
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Niktha Busch

Go To Solution

Best Answer

Best Answer

Answered By Niktha Busch 0 points N/A #149402

Oracle blob jpg photo extract

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.

About Niktha Busch

Questions
1

Answers
100

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 09/26/2012
• Question Category: Oracle Database

Answered By Manning Wickersham 0 points N/A #149403

Oracle blob jpg photo extract

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.

About Manning Wickersham

Questions
1

Answers
33

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/22/2013
• Question Category: Oracle Database