Does anyone know how i can change the tablespace of a table that uses blobs. I want to change the tablespace for the LOB Storage but have so far been unsuccesful. I am using the following SQL statement:-
ALTER TABLE IMAGE MOVE TABLESPACE XSU001
But when i go and check the table the tablespace being used for the LOB_STAORAGE is the old one and the tablespace being used for the Table is XSU001. But ideally i would like the whole database in 1 tablespace.
Originally posted by hummy I tried the export and import method mentioned but that did solve the problem as it still looked for the old tablespace name because the LOB segment was stored in the old tablespace.
I'll have a look at the link mentioned above and try that.
It is impossible, if you create object and import data with option ignore=Y, you will not get any errors at all.