David,
Execute the below

SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL ('USERS');


Thanks,
Ranga


David NGUYEN wrote:

>hello experts,
>
>HAPPY NEW YEAR 2007 .
>
> i use 8i oracle version and dictionnary_management mode for all
>tablespaces in database
>could i change it to extent_management_local mode ..? if yes what is the
>query ..? and what do i have to do..?
>
>thanks in advance
>
>david...
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>


Oracle LazyDBA home page