Home » SQL & PL/SQL » SQL & PL/SQL » move TABLESPACE (oracle Release 10.2.0.1.0)
move TABLESPACE [message #408283] Mon, 15 June 2009 10:29 Go to next message
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.
Re: move TABLESPACE [message #408284 is a reply to message #408283] Mon, 15 June 2009 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: move TABLESPACE [message #408285 is a reply to message #408284] Mon, 15 June 2009 10:38 Go to previous message
sdey
Messages: 20
Registered: May 2009
Junior Member
Thanks. it works fine.

Regards,
Sdey.
Previous Topic: NEED FOR QUERY
Next Topic: Data Grouping (merged 3)
Goto Forum:
  


Current Time: Fri Dec 02 12:25:16 CST 2016

Total time taken to generate the page: 0.04983 seconds