How can I import from split export files?
Requires Free Membership to View
Oracle lets you create a dump file with a limited size by using the
FILESIZE parameter. This is useful when you are writing the dump file
to a filesystem that does not support large files (like FAT32 on
Windows). You will find that the files for the entire dump are number
sequentially. Let's assume that there are three files exp01.dmp,
exp02.dmp, and exp03.dmp created by the Oracle export utility (exp). To
import those files, list them in the FILE parameter for import,
seperated by a comma. For instance, to import the entire contents of
all three dump files in my example, use the following:
imp userid=system/manager file=exp01.dmp,exp02.dmp,exp03.dmp full=y
This was first published in June 2005
Join the conversationComment
Share
Comments
Results
Contribute to the conversation