Home » SQL & PL/SQL » SQL & PL/SQL » Altering a table's tablespace
Altering a table's tablespace [message #18985] Mon, 25 February 2002 00:59 Go to next message
Frank Chileshe
Messages: 7
Registered: November 2001
Junior Member
Help out please.

Is there a way I can alter any table's tablespace
without dropping and then re-creating the table
with the correct tablespace?

Senario: I have table X in tablespace TS1.
Requirement: I want to change the tablespace to TS2
for this table X, without dropping it and
re-creating it in tablespace TS2.

Awaiting your feedback.

Regards,

Frank.
Re: Altering a table's tablespace [message #18987 is a reply to message #18985] Mon, 25 February 2002 01:31 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
alter table table_name move tablespace tablespace_name;
Previous Topic: Group function count
Next Topic: Oracle Forms 6i Button Trigger
Goto Forum:
  


Current Time: Mon Sep 27 17:32:22 CDT 2021