|
|
|
|
Re: How to change schema's tablespace [message #328172 is a reply to message #328167] |
Thu, 19 June 2008 04:04  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Upgrade to CLOB/BLOB.
Failing that, you're going to have to either:
1) Create the new table by hand, copy all the non-long data over, and then write a piece of pl/sql to do a row by row update of the long column,
2) Do an export of the table, and import it into a different schema, set up to use a different default tablespace
3) Upgrade to CLOB/BLOB.
3 is the best option.
Seriously.
|
|
|