Results 1 to 3 of 3

Thread: Import Command

  1. #1
    Join Date
    Jun 2009
    Posts
    46

    Unanswered: Import Command

    Hi,

    I want to Import the backup in database for that i am using below command:

    C:\>imp hikal/hikal789 FILE=d:\BEEHIVE\hikalbkp.dmp LOG=hikal.LOG fromuser=beehive touser=hikal

    Now the Problem which i am facing is that the object which are allready exist in my Database those object are not getting imported in database.
    and i am getting message object is ignored.

    but in my backup(dmp) i have the data also with the object (Table) which i want to import in my database.

    Please suggest me whate commant should i run for that?

    Regard's
    Prasad

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Use the option ignore=y

    Check out the manual for details:

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/exp_imp.htm#i1019282

  3. #3
    Join Date
    Jun 2009
    Posts
    46
    Hi,
    Thanks shammat for your help.

    Regard's

    Prasad

Posting Permissions

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