Oracle Export compress on Windows

I have a big database need to copy on windows client machine. I believe I cant not use pipe command as UNIX, is there any work around.

Sachin
sachin_dbaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tangchunfengCommented:

do a cold backup and restore

shutdown the db and copy the datafiles when db is down
0
sachin_dbaAuthor Commented:
Sorry ... Actually I need to export the database. the disc space on client machine is not sufficient to hold all database back. I need to compress files during backup, sometime like pipe command, but in windows.
0
tangchunfengCommented:
expdp -help

COMPRESSION           Reduce size of dumpfile contents where valid keyword.
                      values are: ALL, (METADATA_ONLY), DATA_ONLY and NONE.

this should help you if you use oracle 10g
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

tangchunfengCommented:
or you may enable the disk compression on your NTFS file system
0
sachin_dbaAuthor Commented:
we have 9i do expdp is not possible. how to check "enable the disk compression on your NTFS file system". do we need to write some scripts.
0
mrjoltcolaCommented:
Have you tried RMAN backupsets, they are compressed by default because they do not include unused database blocks.

If the client has no disk space, and you cannot use expdp or export remotely, you can mount a remote disk / network drive and use RMAN to clone onto the remote disk, although I believe Oracle prefers that RMAN backups go t local disk or tape, it should still work.

If not, your only other easy solution is to shutdown the database and do a cold copy over to a network drive.
0
tangchunfengCommented:
no , right click on LocalDisk D:
choose property
select the checkbox of enable compression to save disk space at the bottom of the window
0
sachin_dbaAuthor Commented:
thanks mrjoltcola, but the requirment is for export dump.

tangchunfeng: I am not sure how this compress help.

Can we define filesize while export, say filesize=1024GB and keep zipping those one by one while export writes on other files.

Sachin
0
mrjoltcolaCommented:
>>thanks mrjoltcola, but the requirment is for export dump.


  exp system/admin@ORA1 full=y filesize=1024000000 file=exp1.dmp


exp will prompt (and wait) for each, then you can zip the old one before continuing, but I advise smaller increments than 1gb to get the job done faster. How large is it?

I would try 500mb chunks so you can be zipping more in parallel of the export, else you have to wait for each 1GB to complete.

  exp system/admin@ORA1 full=y filesize=512000000 exp1.dmp

Then just type in exp2.dmp, exp3.dmp, etc. in succession
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tangchunfengCommented:
the compression ratio depends on the type of the files
http://www.tmsnetwork.org/blog/content/2008/04/01/save-disk-space-compressing-my-documents-folder
the author save more than 1GB space by compressing my 3.44GB My Documents folder
you may test on your machine to calc the compression ratio for dump file
feedback of the ratio is appreciated

The compact command without any parms will display the compression ratio of
a folder.

0
sachin_dbaAuthor Commented:
I created the scripts with filesize option and then malually zipping.
0
mrjoltcolaCommented:
>>I created the scripts with filesize option and then malually zipping.

That was my suggestion in http://#24384473 so I don't understand why you are closing the question without points.
0
mrjoltcolaCommented:
Hi, actually after my objection the OP did score and close the question correctly. It is not reopened, though, so there was a timing issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.