Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    14

    Unanswered: Is there any way to check the import history in oracle 10g

    Hello Friends,

    I am using oracle 10g in my windows environment. I want to know if there is any way to check out when I run the import command on my database last time. I mean to say if I know the import history in oracle. I am not sure if oracle stores such kind of information

    Best Regards
    Milind

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Got log files?

    Not unless:

    1) You kept the log file from last/each import -- or --
    2) You know the name of an object "created" during the last import.

    Otherwise you need to be keeping the import logs.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Mar 2009
    Posts
    46
    I agree with LKBrwn on the atlernative 1. (ie for you to keep the imp.log) files for your imports.

    However, I do not know how knowing the name of an object created during an import can help in tracking the import history.
    I needed an educaiton here
    Thanks

  4. #4
    Join Date
    Mar 2009
    Posts
    46
    Quote Originally Posted by FoKwame
    I agree with LKBrwn on the atlernative 1. (ie for you to keep the imp.log) files for your imports.

    However, I do not know how knowing the name of an object created during an import can help in tracking the import history.
    I needed an educaiton here
    Thanks
    "The Future belong to those who believe in the beauty fo their DREAM" Eleanor Roosevelt

Posting Permissions

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