RE: LMT to DMT

From: <Srini.Chavali_at_Cummins.com>
Date: Wed, 13 Feb 2002 13:42:44 -0800
Message-ID: <F001.0040EBC0.20020213132353@fatcity.com>

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" <Beth.Seefelt_at_TetleyUSA.com>@fatcity.com on 02/13/2002 03:53:36 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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

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 anymore. Could you please give me some light on this?

Another question I posted yesterday, but no replied so far. I post here again. Thanks,

JOan

I am looking for a solution to zip all the backup files into one backupset.zip file on NT. I have trouble to find the dos command line to do this.(pkzip or winzip command line? should executed in a batch file after backup) Can you share this info with us? This should be a very easy thing to do. NT comand compact /C is not what I want. Thanks,
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Srini.Chavali_at_Cummins.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 13 2002 - 15:42:44 CST