Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

9i full export for a large database

PhaniJun 1 2011 — edited Jun 2 2011

Hi Dear All,

My organization is going to make one database read only. so requested to take a full export backup of the same which grew upto 600GB. I want to take it into splits of 2gb. what parameters shall I use.
Prepared the parfile like:

FILE=/exp/prod/exp01.dmp,/exp/prod/exp02.dmp,/exp/prod/exp03.dmp
FILESIZE=2G

Pls suggest me can I proceed with above parameters and what should be the parameter file for importing+* the same.

Thanks in Advance
Phani Kumar

This post has been answered by Lubiez Jean-Valentin on Jun 2 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2011

Added on Jun 1 2011

#database-key-features, #export-import-sql-loader-external-tables

4 comments

1,037 views