Using Oracle SQL Developer with MS SQL- this will be useful for the Oracle developers, we offer high quality of salesforce training. Salesforce training in chennai # posted by karthik: Tuesday, 09 February, 2016.
This is a follow up to post Has the macro function been dropped? I got a question from “ Bob Thompson“, he asked if the macro function has been removed in SQL Developer version 4.01. So I tried to use the function on my computer and it still worked. But then I looked in the preferences (menu “Tools/Preferences”) under “Shortcut Keys”: the macro commands are no loger there!
The macro feature is still there, what’s missing from version 4.01 on is the ability to add the neccessary shortcut keys via the preferences window. That’s why it still working on my computer – the update to version 4.01 took over the settings for the shortcut keys. Workaround Here is workaround to add the shortcut keys for macro recording and playback manually:. Quit Oracle SQL Developer.
Look for the file settings.xml in the following folder:%USERPROFILE% AppData Roaming SQL Developer system4.0.1.14.48 o.ide.12.1.3.2.41.1 settings.xml On some systems it might be in a different place:%USERPROFILE% Application Data Sql Developer system4.0.1.14.48 o.ide.12.1.3.2.41.1 settings.xml. Open the file settings.xml with the text editor of your choice. Search for the following section in the file: oracle/ide/ceditor/keymap/accelerators.xml oracle.ide.keyboard.KeyStrokeMap'. Add the following lines underneath the tag “”: toggle-macro-recording shift control PERIOD playback-macro control PERIOD. The final result should look like this: oracle/ide/ceditor/keymap/accelerators.xml oracle.ide.keyboard.KeyStrokeMap' toggle-macro-recording shift control PERIOD playback-macro control PERIOD. Save the file.
Restart Oracle SQL-Developer and use the macro function as describe here: Additional informations can be found in these OTN Community posts:.
And then yes. Well, it depends. What are your requirements? Backup / Restore Capabilities Do you want a backup of the database. For a restore.
To perform recovery. To roll forward additional archive logs Then RMAN is your tool of choice.
Yes, RMAN is pretty complex and has a steep learning curve. However, once you have mastered it, you will benefit from a large variety of possibilities that RMAN provides you with, e.g. For multiple Oracle instances. Export / Import Capabilities Do you want a dump of a database. For a 'restore' to a new server/instance.
No recovery required. No additional roll forward of archive logs.then you might want to consider using the EXPDP (see: ) and IMPDP (see: ). These tools provide you with the ability to obtain schema-specific data and import the data into different tablespaces; or to filter the export via table names, dependencies. On import the schema can then be re-linked to a different schema (see: ), etc.
SQL Developer SQL Developer has the capability to export data using a wizard. This is similar to the built-in EXPDP and IMPDP tools provided with the RDBMS installation.
A quick guide to using the wizard can be found at: and there in the section Using SQL Developer for Exporting and Importing (Tools Database Export).