import the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: import the database

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    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

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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
    KN

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    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

  4. #4
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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.
    KN

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    Hi,

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

    Vijay.
    Say No To Plastics

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width