| CLOB and BLOB , pls replyyyyyyyyyyy ,. [message #64279] |
Sun, 09 January 2005 08:15  |
orcl
Messages: 3
Registered: January 2005
|
Junior Member |
|
|
hi.. well i have gone through some suggestion on the asktom site but i m frankly not satisified which forced me to come to this forum
i will b highly grateful if u xplain me a bit in a clear manner.
i have a database.. table.. which has a column that contain resumes...
and another table will need to be created which contain one of the column in which i need to store the picture.
well well well
How can i do this.. i only kows is that we need CLOB for resume and BLOB for pics.
Now plz explain me how oracle manages it.. i mean suppose i have pic placed at D:abspic.jpg
NOw what will happen when i insert this into table. first of all im confused how to insert it.. should i give the path of the pic in that column..
like inserting in table A
values ( 1,'steelmill','d:abspic.jpg); is this the way to insert it..
well v v v
and secondly tell me about back up this blob and clob.. export import..
etc,
well thnx alot if you can help me getting know about dealing with this type of data types ...
Somebody has suggested me to have seperate tablespace for bLOB .well how can i only take or partitioned one column..
tell me about some column wise partitioning as well.
i m really grateful if this forum wll help increasing my knowlege..
may b many other readers will eventually get to know
about it..
Thnx alot
|
|
|
|
| Re: CLOB and BLOB , pls replyyyyyyyyyyy ,. [message #64292 is a reply to message #64279] |
Mon, 10 January 2005 04:19  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
There are many methods of loading LOB columns. For starters, look at this sample script - http://www.orafaq.com/scripts/plsql/loadlob.txt
> secondly tell me about back up this blob and clob.. export import
Normal exports or RMAN backups will do. You don't need to do anything special for backing up data in LOB columns.
> tell me about some column wise partitioning as well.
Check the syntax for "CREATE TABLE" in the SQL Reference Guide. The "... LOB ... STORE AS ..." syntax will allow you to store the LOB column in a different tablespace.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
