Export of 74Gb to tape

[Francesco_13]

Hi ,
how i can export to tape (dat tape DDS3 compressed capacity 24Gb) a entire oracle database with 74Gb of data?.
I do it to export in various media, I have a one only dat driver.
How i do it to set volsize parameter? I dont want compress if it's possible .
After export i do it to import in another box in a new database without data.
Thanks
Regards.
Francesco

[Claudio Cilloni]

I never used the VOLSIZE parameter and at this moment I haven't a tape device available.

But maybe you can split your export into multiple files (for example using FILESIZE=10GB and givin eight/nine names to the FILE= parameter) and then copy each file to a tape.
Moreover, usually the export files could be strongly compressed though utility like 'gzip', 'zip' or 'compress'. You 74GB export could fit into one or two 12GB tapes once compressed.

hth,
Claudio

[Francesco_13]

Hi Claudio,
i never used a parameter filesize and multiple file names. Can you write a example,please?
exp user/pass file= .... filesize=.... full=yes log=example.log

Thank you.
Best regards.
Francesco

[Claudio Cilloni · Accepted solution]

you can do so:

$ exp system/manager file=file1.exp,file2.exp,...,file8.exp full=y direct=y log=exp.log filesize=10GB

if you omit the file= parameter or if the number of filenames you listed isn't enough, it will prompt you for a new filename when needed. this can help you to suspend the export after the creation of a new chunk and begin with a new chunk giving the new filename.

Ciao
Claudio