Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you convert from Extent management local to dictionary?
Wrong, there is is (assuming the method has no bugs, nobody is using it).
But it looks like you don't read all posts. Norman's solution might be the
safest way.
Again: explain WHY you want to go back from LMT to DMT because LMT has so
many advantages.
And again: please stop cross-posting.
Peter <peter_at_nomorenewsspammin.ca> schreef in berichtnieuws
0kb0bvkputh12dnhsbd6ldliuah44pmnup_at_4ax.com...
| On Wed, 30 Apr 2003 15:11:08 +0100, Norman Dunbar
| <Norman.Dunbar_at_lfs.co.uk> wrote:
|
| So basically there is no way to migrate from LMT to DMT directly,
| beside dropping everything and then recreating them.
|
| I thought there is a similar method of migrating directly from DMT to
| LMT.
|
| Thanks
|
| >Hi Peter,
| >
| >export.
| >Drop tablespace including ontents and datafiles.
| >create tablespace as DMT.
| >import.
| >
| >Although, having used LMT, I can't see why you would want to go
| >backwards :o)
| >
| >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: Peter [mailto:peter_at_nomorenewsspammin.ca]
| >Posted At: Wednesday, April 30, 2003 2:34 PM
| >Posted To: server
| >Conversation: How do you convert from Extent management local to
| >dictionary?
| >Subject: How do you convert from Extent management local to dictionary?
| >
| >
| >How do you convert from Extent management local to dictionary?
| >I thought this is not possible at all. But since you can convert from
| >dictionary managed to locally managed.
| >
| >Thanks
|
Received on Wed Apr 30 2003 - 16:12:15 CDT