Home » RDBMS Server » Backup & Recovery » export dmp is of 3 files how to import?
export dmp is of 3 files how to import? [message #115984] Fri, 15 April 2005 12:53 Go to next message
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 Go to previous message
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

Previous Topic: Trigerring RMAN daily at a specified time for backup
Next Topic: Does import overwrite existing data ?
Goto Forum:
  


Current Time: Thu Mar 28 18:58:34 CDT 2024