Re: locally managed tablespaces

farah nur wrote:
>
> Hello,
>
> I am trying to fully migrate oracle applications tablespaces (apps
> 1155, db 817) to fully Locally managed tablespaces. The database is
> 200 Gig.
>
> Here is what I was planning to do:
>
> -exp schema
> -exp data
>
> -create new database with LMT tbs
>
> -imp schema
> -drop indexes
> -disable primary keys
> -imp data
> -enable primary keys
> -recreate indexes
>
> However, I am finding out since the apps modules are bundled now,
> there thousands of indexes to deal with, which will increase down time
> when dropping and recreating.
>
> Has anyone done a better way?
>
> Thanks

The concept is the same, but possibly a safer method is:

alter table xxx move tablespace new_lmt; alter index yyy rebuild tablespace new_lmt;

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."