Re: locally managed tablespaces

There are online reorganization tools out there that can help.

One that I have used is LiveReorg from Quest Software.

http://www.quest.com/livereorg

"farah nur" <gargaare_at_yahoo.com> wrote in message news:257c0775.0204171045.130228d4_at_posting.google.com...
> 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
Received on Thu Apr 18 2002 - 21:37:11 CEST