The Foglight Management Server (FMS) database (Oracle) should be moved to another server with another operating system. The database will be created manually without data and the data from the old database will be imported via 'datapump'. The new database should contain 3 tablespaces: DATA, INDEX and LOB. The old database contains only 2 tablespaces: DATA and INDEX.
Is there a supported method of moving the LOB objects from the DATA to the LOB tablespace?
There is no supported way to move existing LOB objects from one tablespace into another tablespaces.
When the FMS database is set up, the objects containing LOB data will be created in the LOB tablespace, but also during runtime Foglight will create more LOB objects. It is not easy to find all LOB objects which has been created during runtime as the names of the objects are created dynamically.