datafile went offline.

No, all columns.

regards
anandkl

Quote:

---

Originally Posted by anandkl

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.
...
One more thing, both table and lob segments are in the same tablespace.
...
Selven can you please let me know if i can use
insert into table_name as select * from old_table;

---

1) LOB ts. That's the whole idea of specifying a separate LOB TS, isn't it?
...
2) Why?
...
3) Use sqlldr

2. Earlier it was designed like this.
3. Sqlldr, i cannot use becuase all the data is already in a table.For using Sqlldr, i need to spool the data and then load.
Again, how will the CLOB data be store in the spool file.

regards
anandkl

1) exp / imp

2) alter table your_table move lob(your_lob_col) store as (tablespace your_new_ts);