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? > ------------------------------ > ----------------------- ------ -------- > TABLESPACE_NAME VARCHAR2 > IN > > the obvious question being - why? > > hth > connor > > --- Joan Hsieh <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
