Convert TS from dictionary to locally managed

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 10 Apr 2003 12:05:36 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703898CC2@lnewton.leeds.lfs.co.uk>

Morning Vangelis,

I think the usual advice is to create a new LMT tablespace and either move or import into it directly. There are problems with the conversion utiltity as it doesn't create uniform sized extents at all but creates extents with the same size as you have now (if I remember correctly) so you end up with the same problem on an LMT as you had on the DMT - un-uniform extent sizes.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Evangelos Giannoulas [mailto:gie_at_pbihag.ch] Posted At: Thursday, April 10, 2003 11:25 AM Posted To: server
Conversation: Convert TS from dictionary to locally managed Subject: Convert TS from dictionary to locally managed

Hi,

Has anyone tried to convert dictionary managed ts into locally using the TABLESPACE_MIGRATE_TO_LOCAL procedure? Received on Thu Apr 10 2003 - 06:05:36 CDT