Export and import settings for catalog objects in OBIEE

Archiving options:
Check if the security permissions in Development Environment should be migrated to UAT or Production environment.
  • 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.
Unarchiving options:
 
REPLACE: Old – replaces existing objects with last modified date older than the migrated ones. Usually this one is used.
REPLACE: All – replaces existing objects with the same name, overwriting only those that do not have the read-only attribute set
REPLACE: Force – replaces existing objects with the same name, overwriting even those that have the read-only attribute set
REPLACE: None – doesn’t replace the objects if an object with existing name exists on the target environment
 
ACL: Create – existing groups/roles in the target environment will be used. The groups/roles used by the migrated object that don’t exist in the target environment will be CREATED.
ACL: Preserve – existing groups/roles in the target environment will be used. The groups/roles used by the migrated object that don’t exist in the target environment will be DISCARDED.
ACL: Inherit – assigns permissions of the parent folder on the target environment

Check locked objects in Oracle database

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

Oracle Alta UI color palette

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 designOracleAltaUI1 Continue reading

Auto replace shortcuts in Oracle SQL Developer

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.

SQLDeveloper_Auto_replace

How to add a code template shortcut in SQL Developer?

First, go to Tools / Preferences:

SQLDeveloper_Auto_replace

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.