Home » SQL & PL/SQL » SQL & PL/SQL » move a tablespace of table
move a tablespace of table [message #36061] Thu, 01 November 2001 19:03 Go to next message
vikas
Messages: 29
Registered: November 2001
Junior Member
i have one problem my 50% table created in system table space and now i want to move to USER tablespace
how can it poss....

waiting for reply

----------------------------------------------------------------------
Re: move a tablespace of table [message #36356 is a reply to message #36061] Mon, 19 November 2001 19:58 Go to previous messageGo to next message
anton
Messages: 6
Registered: November 2001
Junior Member
select 'alter table '||table_name||'move tablespace users ;' from user_tables where
tablespace_name='SYSTEM';

----------------------------------------------------------------------
Re: move a tablespace of table [message #36748 is a reply to message #36061] Mon, 17 December 2001 07:35 Go to previous message
Sidic
Messages: 1
Registered: December 2001
Junior Member
You can use Alter Table .. MOve on Oralce8i

http://certcities.com/editorial/columns/print.asp?EditorialsID=36

----------------------------------------------------------------------
Previous Topic: Re: Error in Stored Procedure
Next Topic: Re: Error in Stored Procedure
Goto Forum:
  


Current Time: Thu Aug 06 08:40:16 CDT 2020