How to recover script history from PL/SQL

Asked

Viewed 2,763 times

1

I had to reinstall PL/SQL Developer and so lost all script history. Is it possible to recover? Thank you.

oracle pl-sql

1 answer

1

I assume you’re talking about the history of commands recently executed in the PL/SQL application, famous CTRL+E. I don’t think it’s possible.

There is a table in Oracle that you can consult the history of executed scripts, to V$SQL, you need to access with a user with privileges, such as sys.

SELECT * FROM v$sql

or

select * from dba_hist_sqltext

Source: ORACLE V$SQL

  • I ran this scrip there, but a lot of weird stuff came up here, nothing like any script I’ve ever run. I had already checked this source from where you sent it. I looked in the Appdata Roaming PLSQL Developer 12 path and the Plsrecall file has been modified. I think the program should not replace this file, in case you need it as is my case.

  • The above query should solve, try to put filters per period in the column FIRST_LOAD_TIME, or part of the query you made, remember some term. I made an edit adding another table, see if it solves.

  • Nothing done buddy.

  • A v$sql not only saves Sqls !?

Browser other questions tagged oracle pl-sql

You are not signed in. Login or sign up in order to post.