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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.