import the database

[ashley75]

someone sent me a full export file and he break it up into 7 dmp file

can someone give me the command how to import this into my database ????

For example: I have full_test_1.dmp,full_test_2.dmp,full_test_3.dmp etc .....

Can you please give me the commans to inport these files???

thanks

[Knarayan]

I think it is the same:
imp user/password file=filenames etc
except you have to include all the files in the file parameter separated by ,

Hope this helps

[ashley75]

thanks for your advise

another question

how did he break up the dump file like that using the export utility ????

Please give me the command

Thanks

[Knarayan]

with the filesize option of export which lets you break the files when it reaches the supplied size limit, this is specially helpful so that the file does not cross the 2G limit which is not supported in some systems.
do exp help=y

Hope this helps.

[oravijay]

Hi,

But make sure that when u import the files u import in the same order.

Vijay.