DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 14

Thread: datafile went offline.

Threaded View

  1. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Axr,
    Just one question, if the CLOB data is >32k and if we have mentioned "enable store in row", then would it still be in the same tablespace as the table was, or will it go to the LOB tablespace.

    Also, will this insert work for tables having clob columns.

    insert into new_Table select * from old_table;

    Here old_table has clob values.
    I am copying all data from old_table into new_table.

    Will there be any issue with copying clob column values.

    regards
    anandkl
    Last edited by anandkl; 10-07-2005 at 08:05 AM.
    anandkl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width