OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » CLOB Storage

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CLOB Storage [message #58385]

Thu, 21 August 2003 15:09

sidd
Messages: 130
Registered: May 2003

Senior Member

i created a table as follows
create table t (c1 number,c2 varchar2....c66 CLOB);
now i haven't specified any storage to c66 column.. and i inserted data into the table.. about quater million recds. now i want move the c66 which is a clob to a different datafile.. how do i do this

Report message to a moderator

Re: CLOB Storage [message #58388 is a reply to message #58385]

Fri, 22 August 2003 06:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please refer this recent posting
http://www.orafaq.net/msgboard/server/messages/20908.htm
it deals with moving a lob object to another tablespace.
the only change you will need is to add you new storage definitions

[i]
alter table test move tablespace tools  
lob(c1) store as lobsegment (tablespace tools STORAGE (new_storage));

Report message to a moderator

Re: CLOB Storage, 1 more doubt [message #58390 is a reply to message #58388]

Fri, 22 August 2003 08:29

sidd
Messages: 130
Registered: May 2003

Senior Member

But i want to move CLOB only to diff tablespace. and clob is not an external file.. its a txt field. how do i move CLOB only to a different tablespace?

Report message to a moderator

Re: CLOB Storage, 1 more doubt [message #58391 is a reply to message #58390]

Fri, 22 August 2003 09:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

alter table table_name move < new_tablespace >;

Report message to a moderator

Previous Topic:	What is the hardware requirment for this
Next Topic:	Temporary Segments

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:45:10 CDT 2024