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_at_cust9> desc dbms_space_admin
> ...
> PROCEDURE TABLESPACE_MIGRATE_FROM_LOCAL
> Argument Name Type
> In/Out Default?
> ------------------------------
> ----------------------- ------ --------
> TABLESPACE_NAME VARCHAR2
> IN
>
> the obvious question being - why?
>
> hth
> connor
>
> --- Joan Hsieh <joan.hsieh_at_tufts.edu> wrote: > 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).
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> 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: 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).