move a tablespace of table [message #36061] |
Thu, 01 November 2001 19:03 |
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 |
anton
Messages: 6 Registered: November 2001
|
Junior Member |
|
|
select 'alter table '||table_name||'move tablespace users ;' from user_tables where
tablespace_name='SYSTEM';
----------------------------------------------------------------------
|
|
|
|