How can I import from split export files?
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
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.