-
EXPORT + IMPORT together
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
-
this facility is not avilable till 10g....
-
yes, i know. But i read on internet about "procedure" with pipe.
Anyone knows something about it?
-
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
Last edited by gopu_g; 04-11-2008 at 05:32 AM.
-
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.
-
Originally Posted by gopu_g
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
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...?
-
Originally Posted by gopu_g
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
ok can we return IT please? :(
any valid idea?? help me please!
-
if you dont want to create a dump file...
You can go for a copy command to move the tables to other databases....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|