RE: LMT to DMT

2002-02-17 Thread

Mainly, because we did not heard of GZIP until now?

What is the benefit of GZIP on WinZip (on NT)?

Yechiel Adar, 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
 
 
 
 
 
 
 
   [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
 
 
 Command Line Support Add-On 
  
  Note: at the time of this writing, the command line support add-on has
 still not been officially  released, but a pre-release beta test version 
 is
 available as a free download from the web  page
 http://www.winzip.com/wzcline.cgi . 
   The WinZip Command Line Support Add-On lets you use WinZip's power 
 within
 batch files,  macros, and other situations where you have a specific task
 and would prefer to accomplish it  quickly or automatically, without using
 the usual WinZip graphical user interface. 
  
  Copyright  1991-2000 by WinZip Computing, Inc.  All rights 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. Don't worry, I got it from 
  http://www.winzip.com/xcmdline.htm
  
  Joan
  
  aao eceai wrote:
   
   Hello Joan
   
   Try : pkzip -add zipfilename *.txt
   
   Yechiel Adar, Mehish Computer Services
   [EMAIL PROTECTED]
   
-Original Message-
From: Joan Hsieh [SMTP:[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 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).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
 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

Re: LMT to DMT

2002-02-17 Thread Jared Still


Open source, cross platform, superior command line interface.

On Sunday 17 February 2002 07:03, ? ??? wrote:
 Mainly, because we did not heard of GZIP until now?

 What is the benefit of GZIP on WinZip (on NT)?

 Yechiel Adar, 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
 
 
 
 
 
 
 
  àãø éçéàì [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
 
 
  Command Line Support Add-On
 
   Note: at the time of this writing, the command line support add-on has
  still not been officially  released, but a pre-release beta test version
  is
  available as a free download from the web  page
  http://www.winzip.com/wzcline.cgi .
The WinZip Command Line Support Add-On lets you use WinZip's® power
  within
  batch files,  macros, and other situations where you have a specific task
  and would prefer to accomplish it  quickly or automatically, without
  using the usual WinZip graphical user interface.
 
   Copyright © 1991-2000 by WinZip Computing, Inc.  All rights 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. Don't worry, I got it from
   http://www.winzip.com/xcmdline.htm
  
   Joan
  
   aao eceai wrote:
Hello Joan
   
Try : pkzip -add zipfilename *.txt
   
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
   
 -Original Message-
 From: Joan Hsieh [SMTP:[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 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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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

Re: LMT to DMT

2002-02-17 Thread Jan Pruner

GZIP is commandline interface (or utility) for ZLIB library - the same 
compress library, which is  using WinZip (and  other soft).

JP

On Sun 17. February 2002 16:03, you wrote:
 Mainly, because we did not heard of GZIP until now?

 What is the benefit of GZIP on WinZip (on NT)?

 Yechiel Adar, 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
 
 
 
 
 
 
 
  éçéàì àãø [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
 
 
  Command Line Support Add-On
 
   Note: at the time of this writing, the command line support add-on has
  still not been officially  released, but a pre-release beta test version
  is
  available as a free download from the web  page
  http://www.winzip.com/wzcline.cgi .
The WinZip Command Line Support Add-On lets you use WinZip's? power
  within
  batch files,  macros, and other situations where you have a specific task
  and would prefer to accomplish it  quickly or automatically, without
  using the usual WinZip graphical user interface.
 
   Copyright ? 1991-2000 by WinZip Computing, Inc.  All rights 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. Don't worry, I got it from
   http://www.winzip.com/xcmdline.htm
  
   Joan
  
   aao eceai wrote:
Hello Joan
   
Try : pkzip -add zipfilename *.txt
   
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
   
 -Original Message-
 From: Joan Hsieh [SMTP:[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 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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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

Re: LMT to DMT

2002-02-14 Thread Connor McDonald

sys@cust9 desc dbms_space_admin
...
PROCEDURE TABLESPACE_MIGRATE_FROM_LOCAL
 Argument Name  Type  
 In/Out Default?
 --
--- -- 
 TABLESPACE_NAMEVARCHAR2  
 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).



Re: LMT to DMT

2002-02-14 Thread Joan Hsieh

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_NAMEVARCHAR2
  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).



Re: LMT to DMT

2002-02-14 Thread Joan Hsieh

Thanks, I don't have pkzip, just winzip. Don't worry, I got it from 
http://www.winzip.com/xcmdline.htm

Joan

àãø éçéàì wrote:
 
 Hello Joan
 
 Try : pkzip -add zipfilename *.txt
 
 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]
 
  -Original Message-
  From: Joan Hsieh [SMTP:[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 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).
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   This e-mail was scanned by the eSafe Mail Gateway
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
   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).



RE: LMT to DMT

2002-02-14 Thread

Command Line Support Add-On 
  
 Note: at the time of this writing, the command line support add-on has
still not been officially  released, but a pre-release beta test version is
available as a free download from the web  page
http://www.winzip.com/wzcline.cgi . 
  The WinZip Command Line Support Add-On lets you use WinZip's power within
batch files,  macros, and other situations where you have a specific task
and would prefer to accomplish it  quickly or automatically, without using
the usual WinZip graphical user interface. 
  
 Copyright  1991-2000 by WinZip Computing, Inc.  All rights 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. Don't worry, I got it from 
 http://www.winzip.com/xcmdline.htm
 
 Joan
 
 aao eceai wrote:
  
  Hello Joan
  
  Try : pkzip -add zipfilename *.txt
  
  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]
  
   -Original Message-
   From: Joan Hsieh [SMTP:[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 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).
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This e-mail was scanned by the eSafe Mail Gateway
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?_?  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

RE: LMT to DMT

2002-02-14 Thread Jared . Still

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


Command Line Support Add-On 
 
 Note: at the time of this writing, the command line support add-on has
still not been officially  released, but a pre-release beta test version 
is
available as a free download from the web  page
http://www.winzip.com/wzcline.cgi . 
  The WinZip Command Line Support Add-On lets you use WinZip's® power 
within
batch files,  macros, and other situations where you have a specific task
and would prefer to accomplish it  quickly or automatically, without using
the usual WinZip graphical user interface. 
 
 Copyright © 1991-2000 by WinZip Computing, Inc.  All rights 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. Don't worry, I got it from 
 http://www.winzip.com/xcmdline.htm
 
 Joan
 
 aao eceai wrote:
  
  Hello Joan
  
  Try : pkzip -add zipfilename *.txt
  
  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]
  
   -Original Message-
   From: Joan Hsieh [SMTP:[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 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).
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This e-mail was scanned by the eSafe Mail Gateway
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway

RE: LMT to DMT

2002-02-13 Thread Seefelt, Beth


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: [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: Seefelt, Beth
  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).



Re: LMT to DMT

2002-02-13 Thread Joan Hsieh

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 wrote:
 
 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: [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: Seefelt, Beth
   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).



RE: LMT to DMT

2002-02-13 Thread Srini . Chavali


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 PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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: [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: Seefelt, Beth
  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: 
  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).