Home » RDBMS Server » Server Administration » how to shift tables from one tablespace to another
how to shift tables from one tablespace to another [message #369441] Fri, 22 September 2000 00:33 Go to next message
alkakaneja
Messages: 10
Registered: February 2000
Junior Member
Hi all,

I have to shift some of my tables from the existing tablespace to a new table space, how to do that?

thanks in advance,

alka

Report message to a moderator

Re: how to shift tables from one tablespace to another [message #369489 is a reply to message #369441] Sun, 01 October 2000 11:19 Go to previous message
S. Vijaya Kumar
Messages: 5
Registered: September 2000
Junior Member
Hi Alka,

You don't have any direct method. You can try any one of the following steps:

1. Create a temporary table and specify a tablespace for that based on the original table.
2. Drop the main table.
3. Rename the temporary table to main table.

2nd Method:

1. Export the original table.
2. Drop the table.
3. Import the table back into a differnt tablespace.

Report message to a moderator

Previous Topic: INSTALATIONI OF ORACLE 8i in WIN 98
Next Topic: Re: restore database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 16:57:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.