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.

Report message to a moderator

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;

Report message to a moderator

Previous Topic: Group function count
Next Topic: Oracle Forms 6i Button Trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 03:18:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.