In TOAD For Oracle (currently using version 12), I see that there is an option in SQL Recall (F8) to import and export savedsql.dat files now. I also see that there is an “append” option, but it doesn’t seem to work for me.
What I want to be able to do is take a savedsql.dat file from another computer and MERGE it into my savedsql.dat. I have tried to do this with the Import and Append option, but it always overwrites my current history with just the history from the file I am importing. Is this a bug or is it not designed to work that way.
How can I merge two savedsql.dat files together and have access to all the combined history going forward, that’s my goal.
~bill
There is no way to merge.
Michael
On 01/14/2014 02:40 PM, billprew wrote:
"Merging" SQL Recall history ?
Thread created by billprew
In TOAD For Oracle (currently using version 12), I see that there is an option in SQL Recall (F8) to import and export savedsql.dat files now. I also see that there is an "append" option, but it doesn't seem to work for me.
What I want to be able to do is take a savedsql.dat file from another computer and MERGE it into my savedsql.dat. I have tried to do this with the Import and Append option, but it always overwrites my current history with just the history from the file I am
importing. Is this a bug or is it not designed to work that way.
How can I merge two savedsql.dat files together and have access to all the combined history going forward, that's my goal.
~bill
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Okay, I guess it is what it is then. So what is the “append” setting on the Import dialog all about, what is that trying to say?
~bill
Ok, I should've checked that first. I see what you're talking about. I forgot that feature was even added. It's working for me, perhaps you're at the max history limit and that's blocking. In Options|Editor|Code Assist increase the SQL Recall statements to
save setting. Double it or so. Click OK and now try your import again.
On 01/14/2014 02:46 PM, billprew wrote:
RE: "Merging" SQL Recall history ?
Reply by billprew
Okay, I guess it is what it is then. So what is the "append" setting on the Import dialog all about, what is that trying to say?
~bill
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Bingo! Thanks. I did wonder at one point if there might be a size limit, but didn’t think to look in “Code Assist” for a history setting. Thanks much for the help.
~bill