| Creation of zip file [message #81372] |
Wed, 12 February 2003 02:41  |
Arun Kumar Singh
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
All,
I need help from all of you.
While creating a flat file in D2k Form using TEXT_IO.
I want to zip also using HOST command.
Could anybody let me know
what will be command in unix and dos.
Any help would be highly appricated .
Regards
Arun
|
|
|
|
| Re: Creation of zip file [message #81377 is a reply to message #81372] |
Wed, 12 February 2003 04:04  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
a script wich i copied from this site
----------------------------------------------------------------------------
-- -
-- Purpose: Dynamically zip a process's trace file -
-- -
-- Synopsis: @trc_zip -
-- -
-- Description: This script creates a named pipe in place of the process's -
-- trace file and spawns a gzip process to compress it. -
-- -
----------------------------------------------------------------------------
column trc_file new_value trc_file noprint
column zip_file new_value zip_file noprint
select p.value || '/ora_' || u.spid || '.trc' trc_file,
p.value || '/ora_' || u.spid || '.trc.gz' zip_file
from sys.v_$session s,
sys.v_$process u,
sys.v_$parameter p
where s.audsid = userenv('SESSIONID')
and u.addr = s.paddr
and p.name = 'user_dump_dest'
/
set define :
host mknod :trc_file p && nohup gzip < :trc_file > :zip_file &
set define &
alter session set max_dump_file_size = unlimited
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
