RE: looking for export with dynamic compress script on VMS

Thanks to all of you who responded to my question.

Best Regards,
Prasad

"Jesse, Rich" <Rich.Jesse_at_qtiworld.com> on 05/08/2001 03:56:49 PM

To: "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com> cc: "'Prasada.Gunda1_at_hartfordlife.com'" <Prasada.Gunda1_at_hartfordlife.com>

Prasad,

If you are on v7+ of OpenVMS (or is it v7.1+?), you can use the DCL PIPE command to emulate Unix-style pipes. Although I haven't tried it, it may produce something similar. For example, instead of the traditional DCL:

     $ DEFINE/USER SYS$OUTPUT T.T
     $ SHOW SYSTEM
     $ SEARCH T.T ORA

...which is similar to the unix "ps -ef|grep ORA" command, you can shorten it up to:

     $ PIPE SHOW SYSTEM | SEARCH SYS$PIPE ORA You may also want to investigate GNUZip for OpenVMS. http://www.openvms.digital.com/freeware/FREEWARE50/000TOOLS/ should contain a directory called "ALPHA_IMAGES" (8i will not run on VAXen, just Alphas) which will contain a GZIP.EXE file for ya. Yes, I'm aware that the link will forward you to Compaq's site. Just in case Ken Olsen is watching from Somewhere Above... :)

HTH!

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Prasada.Gunda1_at_hartfordlife.com
> [mailto:Prasada.Gunda1_at_hartfordlife.com]
> Sent: Tuesday, May 08, 2001 14:56
> To: Multiple recipients of list ORACLE-L
> Subject: looking for export with dynamic compress script on VMS
>
>
> Hi VMS & DBA gurus,
>
> As part of migration process from Oracle v7 to v8i, we are
> trying to do the
> complete export of our database. Due to the lack of disk
> space, we can not
> land such a big export file.
>
> Our v7 database is on VMS platform and I am looking for the
> VMS script,
> which does dynamic compression (like the way pipes work on
> Unix systems)
> while export is running.
>
> If any one has such script and would like share it, please
> post it on the
> list.
>
> I really appreciate for your help.
>
> Thanks in advance,
>
> Best Regards,
> Prasad
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Prasada.Gunda1_at_hartfordlife.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).