OraFAQ Forum: SQL & PL/SQL » move TABLESPACE

Home » SQL & PL/SQL » SQL & PL/SQL » move TABLESPACE (oracle Release 10.2.0.1.0)

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

move TABLESPACE [message #408283]

Mon, 15 June 2009 10:29

sdey
Messages: 20
Registered: May 2009

Junior Member

Hi ,
The script of TABLE MSG_S is as follows-

CREATE TABLE MSG_S (
storage_id NUMBER(10) NOT NULL,
message_content CLOB NOT NULL,
storage_date DATE NOT NULL,
CONSTRAINT pk_msg_s_st_id
PRIMARY KEY (storage_id)
USING INDEX
TABLESPACE msg_ind1
)
TABLESPACE msg_data1
;

Now I want to move the table space -

sql>alter table MSG_S move TABLESPACE msg_data2;

this is working fine.

How can I move the INDEX TABLESPACE msg_ind1?

Please guide.

Regards,
Sdey.

Report message to a moderator

Re: move TABLESPACE [message #408284 is a reply to message #408283]

Mon, 15 June 2009 10:34

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alter index ... rebuild tablespace ...

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: move TABLESPACE [message #408285 is a reply to message #408284]

Mon, 15 June 2009 10:38

sdey
Messages: 20
Registered: May 2009

Junior Member

Thanks. it works fine.

Regards,
Sdey.

Report message to a moderator

Previous Topic:	NEED FOR QUERY
Next Topic:	Data Grouping (merged 3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 07:29:44 CST 2025