datatype LONG in different tablespace ?
- From: steen bartholdy <steenbdkoraclel@xxxxxxxx>
- To: freelist oracle <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Dec 2005 14:25:26 +0100 (CET)
version 9204/9207
Can a LONG columnn exist in a different tablespace than the other columns,
just like LOB columns ?
something like press_release in this examble
>>
CREATE TABLE print_media_new
( product_id NUMBER(6)
, ad_id NUMBER(6)
, ad_photo BLOB
, ad_graphic BFILE
, press_release LONG
)
LOB ( press_release ) STORE AS
(TABLESPACE LONG_TAB )
<<
maybe its a RTFM, but I want to make sure
TIA
SteenB, Denmark
BTW we are not able to migrate from LONG to LOB's :-(
Other related posts:
