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

    Unanswered: recover view defination in oracle

    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.


  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    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:

    Tips for good questions:

  3. #3
    Join Date
    Jun 2004
    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
    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