Migrate to locally managed tablespaces

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 - 06:51:15 CDT