- Keep permissions – if the check box is ticked the source environment permissions will be exported. Objects archived with that option can affect the existing permissions on target environment depending on the unarchiving option.
- Unticked – no permissions are exported. If the object already exists in the target environment will maintain the permissions of the target environment. If the object doesn’t exist will inherit the permissions from its new parent folder.
How to check which objects are locked in Oracle database?
Sometimes its necessary to check which tables are locked on the database (be it by running ETL sessions or other database users). Information on current locks on the Oracle database objects can be found in the V$LOCKED_OBJECT view. Here’s a SQL query to check the locked objects on Oracle database: Continue reading
How to enable line numbers in Oracle SQL Developer?
Line numbering is a very helpful feature, especially when you need to go to a code line specified in the error message. The feature is disabled by default in Oracle SQL Developer.
The colors of Oracle’s new user interface
Oracle announced Alta User Interface – a new design and set of guidelines for the developers for the latest Oracle applications (cloud-based products, Fusion Middleware and mobile applications) and the next Oracle products to come. Alta UI is created as a responisve, mobile-ready, flat and clean interface design Continue reading
How to check the tablespace usage in Oracle database?
Here’s a handy query to get the values of tablespace size, used and available free tablespace and usage percentage on Oracle database: Continue reading
How to get only the first rows from query results?
Sometimes you need just to fetch first few rows from the query results, not the whole results set. Different databases offer functions to limit the rows displayed from the query results. Continue reading
How to deal with a single quote character in SQL?
When trying to execute a statement with a single quote (or apostrophe) inside a string in a SQL client:
SELECT * FROM employees WHERE name = 'd'Artagnan'
you get an error:
ORA-00933: SQL command not properly ended
How to enable auto replace shortcuts in Oracle SQL Developer?
In the Auto replace shortcuts in Toad post I showed you how to add auto-replace shortcuts in a Toad client. You can acheive the same in Oracle SQL Developer – here that feature is called SQL Editor Code Templates.
How to add a code template shortcut in SQL Developer?
First, go to Tools / Preferences:
Choose Database / SQL Editor Code Templates and click on Add Template button. For example add these two code templates:
saf - SELECT * FROM scaf - SELECT COUNT(1) FROM
Now to use the auto replace code template type the shortcut and press CTRL and SPACEBAR keys. Shortcut will be replaced with a pre-defined statement.