export dmp is of 3 files how to import? [message #115984] |
Fri, 15 April 2005 12:53 |
balavignesh
Messages: 180 Registered: March 2005
|
Senior Member |
|
|
Hi ALL,
the whole database export file was too large so it was split up into 3 files of 2g,2g and 1.5 g. the blob field in a table is alone 3g and i need to import just that table whose records are split up in all 3 files. what is the syntax import command.
thanx
bala
|
|
|
Re: export dmp is of 3 files how to import? [message #116082 is a reply to message #115984] |
Sun, 17 April 2005 09:37 |
pscjhe
Messages: 38 Registered: April 2005
|
Member |
|
|
Quote from Oracle "Utilities" book
FILE
Default: expdat.dmp
Specifies the names of the export files to import. The default extension is .dmp. Because Export supports multiple export files (see the following description of the FILESIZE parameter), you may need to specify multiple filenames to be imported. For example:
imp scott/tiger IGNORE=y FILE = dat1.dmp, dat2.dmp, dat3.dmp FILESIZE=2048
|
|
|