Is there an easy way to backup Oracle SQL Developer's User Snippets?
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:
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!
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.
How to backup an Oracle database from SQL Developer, Importing Data into a Table using Insert Method. Oracle SQL Developer makes it very easy to import data into an existing table. Perform the following steps to� 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.
Agreeing with Eddie Awad, just copy the xml file. And for windows7 the sqldeveloper User-Snippets file can be found here:
Importing and Exporting using the Oracle SQL Developer 3.0, Backing up and restoring Oracle Database XE is based on protecting the Although there is an RMAN command line client similar to the SQL Command Line, you do and any uncommitted transactions that were under way when the failure took You can use SQL Developer to view the contents of the recycle bin, restore� (This is for SQL Developer 3.0.04, Build 4.34) Go to Menu Tools => Database Export. Select your options for backup from there (export format, options, encoding, etc), then types, objects, and data, and voila! Also, I didn't Google this as I had an SQL developer instance already open, but I don't think it would've been too hard. At all.
If you use SQL Developer on Mac OS X, then the snippets can be found in ~/Library/Application Support/SQL Developer/UserSnippets.xml
Backing Up and Recovering, Mostly Making oracle easy, mostly: Creating Oracle Connections…from outside of SQL Developer; Exploring the latest SQL Developer Web in the Oracle Autonomous Database; Changing the User Interface Language in Oracle SQLcl; It’s 2020, and SQL Injection is STILL a Serious Problem
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.
Use <database> SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql ORDER BY execquery.last_execution_time DESC SOURCE: Recover unsaved SQL query scripts. Is there a way to do this in Oracle SQL Developer?
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.
Simple SQL Backup is a free software program intended for use by network administrators. Simple SQL Backup makes performing an immediate backup of a SQL Server database very easy.
Ok, point-click, go sounds good, let’s go get that thing. Oracle SQL Developer is the GUI, and you’ve downloaded and got it up and running in five minutes. Awesome. Let’s do this.
To install SQL Developer, simply download and unzip the file. SQL Developer users can connect to any supported Oracle Database. Oracle SQL Developer 3.0 introduces a DBA Navigator and provides support for DBMS Scheduling. Other features include a new Query Builder, SQL Tuning Advisor, and Explain Plan Diff utility.
Oracle SQL Developer is a free, development environment that simplifies the management of Oracle Database in both traditional and Cloud deployments. It offers development of your PL/SQL applications, query tools, a DBA console, a reports interface, and more.
- Wow, it's there! Thanks much! Clearly for some reason Windows search is not indexing that location.
- Thanks much for your comment! I'd have to sort of disagree with you here, I don't think that performing such a server-side operation would be the best way to backup user snippets.
- What are you backing up? Snippets of SQL? Your "daily tasks" you use "a lot" are going to be performed much faster as pre-compiled procedures rather than run-once statements. Not only do you gain a performance standard, you gain the backup capability. However, if these snippets you want to save are user-specific then I misunderstood your question.