| redirect export in windows to zip [message #74447] |
Sat, 11 December 2004 11:16  |
Ralf Bender
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
hello,
i try redirect the export dump directly to a packer program like zip under windows.
i must prevent my diskspace there.
is there a chance to do that like in unix with mknod?
is it possible to do?
i write a commandline and sql script which reads my database users and exports them to different dump files. after creating (or better while creating) i want to pack them immediatly. calling from the export tool won't work (i try command: system zip ....)
please, answer also to my email adress.
thanks
|
|
|
|
| Re: redirect export in windows to zip [message #74449 is a reply to message #74447] |
Mon, 13 December 2004 00:33  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
try something like this.
bash-2.03$ doexp
************************
Generating the script
************************
exp mag/mag owner=DBADMIN file=DBADMIN.dmp statistics=none
tar -cvf DBADMIN.zip DBADMIN.dmp
exp mag/mag owner=MAG file=MAG.dmp statistics=none
tar -cvf MAG.zip MAG.dmp
************************
Executing the script
************************
Export: Release 9.2.0.4.0 - Production on Mon Dec 13 05:32:52 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DBADMIN
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DBADMIN
About to export DBADMIN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export DBADMIN's tables via Conventional Path ...
. . exporting table A 0 rows exported
. . exporting table B 0 rows exported
. . exporting table BONUS 0 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 106496 rows exported
. . exporting table PLAN_TABLE 0 rows exported
. . exporting table RUN_STATS
. . exporting table SALGRADE 5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
a DBADMIN.dmp 4988K
Export: Release 9.2.0.4.0 - Production on Mon Dec 13 05:33:00 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MAG
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MAG
About to export MAG's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export MAG's tables via Conventional Path ...
. . exporting table A 1 rows exported
. . exporting table B 1 rows exported
. . exporting table DD_TEST 12 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 13 rows exported
. . exporting table MEMBER 3 rows exported
. . exporting table MYDD 1 rows exported
. . exporting table MYTABLE 1353 rows exported
. . exporting table PACKSTUECKBEDINGUNG 0 rows exported
. . exporting table PLAN_TABLE 0 rows exported
. . exporting table RANDOM_STRINGS 200 rows exported
. . exporting table RUN_STATS
. . exporting table SAMPLE 1 rows exported
. . exporting table SESS_EVENT
. . exporting table TABLE_NUM 0 rows exported
. . exporting table TAB_CHAR 1000 rows exported
. . exporting table TAB_NUM 1000 rows exported
. . exporting table T_LT 2 rows exported
. . exporting table lowercase 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
a MAG.dmp 135K
bash-2.03$
echo "************************"
echo Generating the script
echo "************************"
sqlplus -s mag/mag <<EOF
set head off;
set feed off
spool doexp.lst
select 'exp mag/mag owner='||username||' file='||username||'.dmp statistics=none' ||chr(10)||
'tar -cvf '|| username||'.zip ' || username||'.dmp ' from dba_users where username in ('MAG','DBADMIN');
spool off;
EXIT;
EOF
chmod +x doexp.lst
echo "************************"
echo Executing the script
echo "************************"
doexp.lst
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
