EXPORT + IMPORT together

[master.jimmy]

hi experts!
I'm with oracle 9.

I want to make an EXPORT/IMPORT job, but i don't want to create the export file.dump. I prefer export 1 row (or whatever thing, structure, grants, etc..) and import, export and import, export and import. I have several limit on free space, and i cant create the export file. So i'd like a real time (and automatic) export/Import.
Is this possible? how?

Tnx all

[gopu_g]

this facility is not avilable till 10g....

[master.jimmy]

yes, i know. But i read on internet about "procedure" with pipe.
Anyone knows something about it?

[gopu_g]

yes you can use linux pipe to export and import....
at the time of exporting you can do the import..

then also you have to create the dumpfile..

ORACLE_SID=MYSID
export ORACLE_SID

DIRECTORY=/app/oracle/work; export DIRECTORY
FILENAME=${DIRECTORY}/exports/${ORACLE_SID}-`date +%d`.dmp.gz; export FILENAME
LOG=${DIRECTORY}/exports/${ORACLE_SID}-`date +%d`.log; export LOG
PIPE=${DIRECTORY}/export_pipe.dmp; export PIPE

test -p ${PIPE} || mknod ${PIPE} p
chmod +rw ${PIPE}

cat $PIPE | /usr/local/bin/gzip > ${FILENAME} &
${ORACLE_HOME}/bin/exp $1 tables=$2 log=${LOG} buffer=10485760 file=${PIPE} consistent=yes full=no << EOF
system/password

you can check this link to get the more details..

http://www.dba-oracle.com/t_exp_imp_...ganization.htm

[gopu_g]

1. create a pipe:


$ mknod gzpipe p2. start gzip

$ gzip -c < gzpipe > exp.gz &3. run exp

$ exp scott/tiger file=gzpipe ... import would then be:

$ gunzip -c < exp.gz > gzpipe &$ imp scott/tiger file=gzpipe ... Unfortunately piping cannot be used with 10g datapump. Here's what oracle whitepaper says:

Can I use gzip with Data Pump?
Because Data Pump uses parallel operations to achieve its high performance, you
cannot pipe the output of Data Pump export through gzip. Starting in Oracle
Database 11g, the COMPRESSION parameter can be used to compress a Data Pump
dump file as it is being created. The COMPRESSION parameter is available as part
of the Advanced Compression Option for Oracle Database 11g.

[PAVB]

Unfortunately piping cannot be used with 10g datapump

Poster clearly stated he is running on Ora9i... what part of it wasn't clear enough?

Also, Yes... you can export to a pipe and import from it. We do that all the time.

[gopu_g]

Poster clearly stated he is running on Ora9i... what part of it wasn't clear enough?

I did't say that it is not using in !0g...?

[PAVB]

I did't say that it is not using in !0g...?

Here is how it works, poster asks a question in regards to Ora9i and most probably is looking for an answer he can apply on his environment.

You happily say it can't be done on Ora9i -which is not true and then you start posting references to Ora10g and even Ora11g; don't you see you are not helping at all?

[master.jimmy]

ok can we return IT please? :(
any valid idea?? help me please!

[gopu_g]

if you dont want to create a dump file...
You can go for a copy command to move the tables to other databases....