| 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';
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
