Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do you convert from Extent management local to dictionary?

Re: How do you convert from Extent management local to dictionary?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Thu, 01 May 2003 05:57:07 GMT
Message-ID: <7nd1bvoi2c1e8dbn1qpclqgk4tv67c7hvv@4ax.com>


On Thu, 01 May 2003 05:35:55 GMT, Peter <peter_at_nomorenewsspammin.ca> wrote:

Looks like I have to use DBMS_SPACE_ADMIN Subprograms TABLESPACE_MIGRATE_FROM_LOCAL and TABLESPACE_MIGRATE_TO_LOCAL

Originally I was looking for a way of doing it with some basic "alter tablespace....." commands. Now I know it cannot be done.

>On Wed, 30 Apr 2003 23:12:15 +0200, "Anton Buijs"
><remove_aammbuijs_at_xs4all.nl> wrote:
>
>>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.
>
>Well, I know LMT is a lot more efficient than DMT. But it is really
>not my decision to look into it.
>Thanks.
>
Received on Thu May 01 2003 - 00:57:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US