Home » RDBMS Server » Server Administration » urgent
urgent [message #54061] Mon, 28 October 2002 01:38 Go to next message
Puneet Vats
Messages: 33
Registered: June 2002
Member
Hi dear,

I have designed a table tb01 in tablespace ts01 and now this table has 100000 rows and i want to transfer its tablespace from ts01 to ts02 how can i do it.

Please help me.
mail me please

Report message to a moderator

Re: urgent [message #54062 is a reply to message #54061] Mon, 28 October 2002 01:51 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
export the table and its data.
drop the table
create the table in ts02
import the data from the export you took initially.

Report message to a moderator

Re: urgent [message #54075 is a reply to message #54061] Mon, 28 October 2002 11:46 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hi,
Before working out what Mr.smyth has told , please try even this methodology

alter table
tablespace
;

sai

Report message to a moderator

Previous Topic: dropping all indexes on the table
Next Topic: checkpoint no.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:19:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.