OraFAQ Forum: Server Administration » How to transfer a group of tables into another tablespace ?

Home » RDBMS Server » Server Administration » How to transfer a group of tables into another tablespace ?

Fri, 08 June 2001 04:01

Thirumalai and Prakash
Messages: 23
Registered: March 2001

Junior Member

Hi,
Pls, direct us,
We have a group of tables in default tablespace, I have to transfer all these tables into another tablespace.

Regards
Prakash

Fri, 08 June 2001 04:45

sandeep
Messages: 110
Registered: October 2000

Senior Member

In order to move the tables from 1 tablespace to another, use ALTER TABLE
Move Tablespace
;
Remember , this is a new feature in 8i.

Fri, 08 June 2001 04:49

sandeep
Messages: 110
Registered: October 2000

Senior Member

U can use ALTER TABLE table_name MOVE TABLESPACE tablespace_name; This is a new feature in Oracle 8i.

Fri, 08 June 2001 04:56

sandeep
Messages: 110
Registered: October 2000

Senior Member

U can use ALTER TABLE table_name MOVE TABLESPACE tablespace_name; This is a new feature in Oracle 8i.

Previous Topic:	How to transfer a group of tables into another tablespace ?
Next Topic:	how to replace the cl scr

Goto Forum:

]

Current Time: Mon Dec 23 14:06:54 CST 2024