Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2013
    Posts
    6

    Unanswered: recover view defination in oracle

    hi
    i have mistakenly dropped a view in production database may i be guided how to recover the defination of that view.

    recyclebin is empty and tried the "select * from v$sqlarea" ;

    didn't find anything.

    appreciate your help.

    thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Unless you have your SQLs stored somewhere that definition is gone. You will need to restore your backup.

    If you don't store your DDL scripts in a version control system and you don't have a backup then clearly the view wasn't that important to start with.

    Btw: V$SQLAREA only contains SQL statements that have been executed recently. Even if the view had been used, you'd only find a SELECT * FROM VIEW_NAME in there.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Do you have a Test/Development database that you can use to recreate the definition?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jan 2013
    Posts
    6
    Thanks for your help.

    Seems the view is gone. it was on client database.

Posting Permissions

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