Export a 40GB database

[bensmail]

I want to do a full export DB(40GB).
Can someone tell me if i can splite this export in several files.
if so, how is the syntax of the export
OS:WinNT
VOracle:8.0.5

Thank's

[adewri]

use the FILESIZE parameter during exp to restrict the size of your dump file.

I'm not sure if RESUMABLE parameter is available in 8.0.5, you can use this just to be on the safer side. This will help you suspend when a space related error is encountered.

HTH

[bensmail]

With the parameter FILEZISE=n will create several files whith n as filesize
If so, how to do a full import?

thank's

[adewri]

While importing, start with the first file, as import continues it will ask you for the next file when the first one ends. Then enter the name of the next file.

Or simply use file=filename1.dmp,filename2.dmp...

HTH

[bensmail]

Thank's a will try it today

Bensmail

[adewri]

And don't forget to give the absolute path for the filenames. ie drive:\path\filename

[jmodic]

Originally posted by bensmail
Thank's a will try it today

Don't bother - FILESIZE parameter is not available in 8.0.5!

[adewri]

Originally posted by jmodic
Don't bother - FILESIZE parameter is not available in 8.0.5!

That's bad then you need to use pipe to compress the dump on the fly...

Oops its NT, try using winzip to compress the files on the fly don't know how you can do that...

Best of luck

[adewri]

Try using the NT compress attribute.

Go to the destination directory for the dump file, right click on the folder. Click on the Properties and under "Attributes", enable (click) the "compress" attribute. Any files copied/created under this folder/directory, will be compressed.

HTH

[pando]

you cannot, there is no filesize parameter in 8.0.5!