The workspace I was working on was lost

Toad for Oracle - Beta
1

The content of the workspace I was working on in the previous version was lost after updating to the current version.

Windows 11
Toad for Oracle Base Edition (64-bit)
Add-Ons:
26.1.126.7769

toad-ws-1
toad-ws-11065×653 24.1 KB

toad-ws-2
toad-ws-21065×653 18 KB

Can I get it back?

2

Maybe, if it was saved in a backup.

Utilities -> Manage User Settings.
Click "Recover settings from Backup"
Under that, check only "Workspaces"
On the right, select a backup file that you think might have the workspace contents

image
image1259×1188 45.6 KB

3

It remains the same, it's as if that specific workspace cannot be displayed. I have rolled back to 19 December without success.
The difference was updating to the latest beta version.

4

Are you sure that there are no windows open, maybe far off to the right or down?

Click the "Window" menu to see if any windows exist.

5

If you email me your workspaces.dat file, I will take a look at it.

We added ability to import/export selected workspaces in November. That was the last workspace change that I am aware of.

One thing you can try with the various backups:
After restoring a backup, export the problematic workspace to a text file like this:

image
image1147×552 34.2 KB

The Export dialog will tell you how many connections and windows that each workspace contains. This can tell us if the workspace really doesn't have these windows anymore, or if Toad is having some problem opening the workspace.

6

I am sending you my file by email. I can find the workspace at this path:
C:\Users\usuario\AppData\Roaming\Quest Software\Toad for Oracle\26.1 beta\User Files
right?

7

That is correct

8

It seems that there is nothing

toad-ws-4
toad-ws-41065×653 24.3 KB

toad-ws-5
toad-ws-5692×417 16.1 KB

9

I think somehow the workspace got saved while you didn't have any connections or windows open.

Is it possible that

  1. you selected the workspace
  2. It loaded successfully, then later all your connections/windows got closed, but the workspace was still selected (not <No workspace selected>)
    OR
    it did not load successfully (maybe there was some connection error), but was still selected
  3. The workspace got saved again with no windows/connections (either by auto-save, or manual click on the "save" button)?

That's all I can think of.

Maybe an older backup still has the contents of that workspace

10

I have a copy containing information in the workspace that I need. But I ONLY need to restore the specific workspace and not everything. Can I do that?

11

Yes. Follow these steps.

  1. Copy of your current/broken Workspaces.dat to c:\temp or somewhere to save it.
  2. Copy the Workspaces.dat which still contains your workspace to C:\Users\YOUR_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\26.1 beta\User Files\Workspaces.dat
  3. Start Toad
  4. Click "Export Workspace" as before. Select only the Pry-Analysis--BOLETIN--Des-v2 workspace and click OK. Save it to some file like c:\temp\Pry-Analysis--BOLETIN--Des-v2.txt
  5. Close Toad.
  6. Copy your workspaces.dat from step 1 back to C:\Users\YOUR_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\26.1 beta\User Files\Workspaces.dat
  7. Start Toad
  8. Click here to import
    image
    image573×280 13.5 KB
  9. Choose the file c:\temp\Pry-Analysis--BOLETIN--Des-v2.txt
  10. You will see a prompt to overwrite the workspace. Choose YES
12

I followed the steps you indicated and was able to restore a version so as not to lose everything.

Thank you John

1 Like