• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

History of the Oracle SQL Developer

I have been using the Oracle SQL Developer for about a year. I have a scripts I wrote and used two months ago. I have lost them and I had cleared the history on my machine. I would want to have them back but have failed.

I have contacted the data administrative team and they say they don't know if they can retrieve them

I am requesting for assistance on how I can advise them to retrieve the scripts.

I some times use PLSQL but cannot find the history facility

Thank you
0
Anthony Matovu
Asked:
Anthony Matovu
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
On my version 11.5, history is set under the ribbon Tools | Preferences | Environment, and your actual statements are likely under c:\users\you\AppData\Roaming\SQL*Developer -- your actual results will vary by OS version.

To address your recovery question, my best guess is that you don't keep a backup.  And, you removed the files from your file store / directory.  Short of getting someone to do a sector-level search on the hard drive, I don't have a happy solution to offer.   Regrets.
0
 
Anthony MatovuBusiness Analyst, MTN UgandaAuthor Commented:
Thank you dvz,

is it okay to clear that folder?

thank you

anthony
0
 
DavidSenior Oracle Database AdministratorCommented:
I honestly do not know, my opinion is, however, yes.  That said, please copy the folder first as a backup, then delete the copy later if you don't need it.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now