Q

Importing from split export files

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close