Re: performance comparision between LMT and DMT

on the machine. So my question is that if this is normal or I miss something here? Another questions is that from your experience how much improvement in terms of performance did you see after you convert dmt to lmt? TIA Guang Mei [EMAIL PROTECTED] http://www.geocities.com/guangmei/ -- Please see

performance comparision between LMT and DMT

of performance did you see after you convert dmt to lmt? TIA Guang Mei [EMAIL PROTECTED] http://www.geocities.com/guangmei/ _ MSN 8: advanced junk mail protection and 3 months FREE*. http://join.msn.com/?page=features

RE: LMT to DMT

recipients of list ORACLE-L Subject: RE: LMT to DMT Why bother with WinZip? www.gzip.org [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 10:56 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc

Re: LMT to DMT

Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 14, 2002 9:54 PM To: Multiple recipients of list ORACLE-L Subject:RE: LMT to DMT Why bother with WinZip? www.gzip.org àãø éçéàì [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED

Re: LMT to DMT

, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 14, 2002 9:54 PM To: Multiple recipients of list ORACLE-L Subject:RE: LMT to DMT Why bother with WinZip? www.gzip.org

Re: LMT to DMT

sys@cust9 desc dbms_space_admin ... PROCEDURE TABLESPACE_MIGRATE_FROM_LOCAL Argument Name Type In/Out Default? -- --- -- TABLESPACE_NAMEVARCHAR2 IN the obvious

Re: LMT to DMT

Thanks a lot. I know it is very easy. Just can't remember how to do it. Joan Connor McDonald wrote: sys@cust9 desc dbms_space_admin ... PROCEDURE TABLESPACE_MIGRATE_FROM_LOCAL Argument Name Type In/Out Default? -- ---

Re: LMT to DMT

:[EMAIL PROTECTED]] Sent: Wed, February 13, 2002 10:32 PM To: Multiple recipients of list ORACLE-L Subject: LMT to DMT Hi listers, How to convert the locally management tablespace back to dictionary management tablespace? I used dbms_space_admin migrated all the tablespaces

RE: LMT to DMT

reserved. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Joan Hsieh [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 14, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: LMT to DMT Thanks, I don't have pkzip, just winzip

RE: LMT to DMT

Why bother with WinZip? www.gzip.org àãø éçéàì [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 10:56 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: LMT to DMT

LMT to DMT

Hi listers, How to convert the locally management tablespace back to dictionary management tablespace? I used dbms_space_admin migrated all the tablespaces to LMT. Now I want convert back on some tablespaces, I remember I read the notes indicate step to step how to do this. Just can't find it

RE: LMT to DMT

Sorry, I can't answer you're question, but I'm curious - why do you want to revert back to DMT? Just for my own edification... since I'm in the process of converting to LMT myself. -Original Message- Sent: Wednesday, February 13, 2002 3:32 PM To: Multiple recipients of list ORACLE-L

Re: LMT to DMT

Well, that's my habit. if I upgrade database, I will have to know how to downgrade. (scripts ready) if I go one way, find something wrong or I don't like it. I always can find easy way to come back without get burn to much. Just kidding. I am curious to know how to do it. Joan Seefelt, Beth

RE: LMT to DMT

Beth/Joan, Pretty simple actually ! Just run dbms_space_admin.tablepsace_migrate_from_local ('tablespace_name') as system. Does not take long to run ! HTH Srini Chavali Oracle DBA Cummins Inc Seefelt, Beth [EMAIL PROTECTED]@fatcity.com on 02/13/2002 03:53:36 PM Please respond to [EMAIL