Is there an easy way to backup Oracle SQL Developer's User Snippets?

Question

I love Oracle SQL Developer so I find myself using it a lot to complete my daily tasks. The thing is that my collection of custom snippets only keeps growing so I though it'd be interesting to learn how to backup them.

Before asking blindly I did a bit of work trying to figure out how. I've performed a search within the application's folder by "snippet" and found the following file:

oracle.sqldeveloper.snippet.jar

which quite probably contains my beloved pieces of code. I could just save that file hoping the best, but why not doing it the right way and perhaps being able to, say, only backup the ones and I've created, avoiding the ones that came out-of-the-box, et cétera?

Any suggestion would be really appreciated!

Answer 1

Why not create a package on the Oracle server for daily maintenance that way it's stored with your DB and in your DB backups?

EDIT: I do this and find it even easier to use them later on when performing routine maintenance tasks. Being able to call a packaged procedure is really, REALLY handy sometimes.

Answer 2

On my WinXP machine, I found my User Snippets at:

C:\Documents and Settings\eddie\Application Data\SQL Developer\UserSnippets.xml

PS: Replace eddie with your username.

Answer 3

Are you running on Windows? Check your "C:\Documents and Settings\\Application Data\SQL Developer" directory for a UserSnippets.xml file, it contains all user defined snippets.

Also, check the online help for "Location of User-Related Information" topic. It has location of files that hold other user defined info.

-Dave

Answer 4

If you use SQL Developer on Mac OS X, then the snippets can be found in ~/Library/Application Support/SQL Developer/UserSnippets.xml