The tablespace is mostly empty. How do I shrink the datafile?
Ray
"osy45" <member18536_at_dbforums.com> wrote in message
news:2736728.1049694641_at_dbforums.com...
>
> why is it so large ? had there any users been created with no given own
> tablespace; SYSTEM is the default:
>
> then take all the users except sys, system which own objects in system
> tablespace and move them to other tablespaces
>
> alter user <usr1> default tablespace <tablespace1> ;
> atler user <...> default tablespace <...>;
>
> select 'alter table '|| owner||'.' ||table_name || ' move tablespace '||
> <tablespace1> ||';' where owner = <usr1> ;
>
> after finishing that action you possibly can shrink the datafile ...
>
> --
> Posted via http://dbforums.com
Received on Mon Apr 07 2003 - 18:39:57 CDT
