Wednesday, 10 September 2014

Virtual Private Database (Part 2)

Other options

In the example we used pretty much the minimum number of parameters to make it work. There are more parameters and options available. For example UPDATE_CHECK. This does pretty much the same as WITH UPDATE CHECK in views. If you insert or update a value the Oracle server checks if the new record will be visible to you using your policy. If it is not visible, and this parameter was set to TRUE then it will not allow you to execute this command.

Saturday, 30 August 2014

Virtual Private Database (Part 1)


When working with views you have several options to hide some of the data. In the article on views I have told you about the way to hide columns from the table. By adding a predicate (where clause) to the view, you can restrict the rows a user sees. This would imply creating different views for different (groups of) users. If you have an interface built to interact with the data, that would also mean you have to maintain multiple versions of these interfaces. Not a big problem if you only have a small number (like two or three) interfaces to maintain, but if the number of interfaces grows, chances are that you will forget to implement changes in one or more of them.

Saturday, 23 August 2014

Should you install or clone Oracle Home?

What is cloning?

Cloning is a process of copying an existing installation to a different server or location. Cloning is similar to an Oracle installation except Oracle universal installation performs the actions in a special mode called “clone mode”.

Starting from 10g onwards, Oracle supports cloning and users can easily clone existing Oracle installations. The source and destination servers should have same configuration and packages installed in order Oracle cloning to work.  The cloning process works by copying all files from the source Oracle home to the destination Oracle home, and files which are not part of the source instance will not be copied to the destination location.

Friday, 25 July 2014

Oracle Database New Features

I found no issues whatsoever with downloading, installing the software and creating a container database plus enabling the in-memory option.

Oracle Database New Features

Friday, 13 June 2014

Oracle 12c – One Database and One Solution

Oracle Database 12c is designed for the cloud and introduces Multitenant Architecture with more than 500 new features. It enables customers to make more efficient use of their resources and reduce IT costs.

What is Multitenant Architecture?

Oracle 12c now introduces multitenant architecture featuring pluggable databases, which makes it easy to consolidate your databases on to the cloud, deliver high density of schema based consolidation without making changes to application, increase utilization of resources, and rapidly provision and clone  database for various purposes by lowering down of Infrastructure & administrative costs.

Tuesday, 27 May 2014

Cross-Platform Transportable Database and Oracle Engineered Systems

Cross-platform transportable database is not the same thing as transportable tablespace. When performing x-platform transportable database we copy the entire database, including the SYSTEM and SYSAUX tablespaces from one platform to another. The usual containment checks are no longer needed and because the SYSTEM tablespace is also being copied, no metadata datapump export/import step is required. But cross-platform transportable database can only be performed between platforms that have the same endian format.

Cross-Platform Transportable Database and Oracle Engineered Systems

Wednesday, 12 March 2014

Mapping SQL Server Features to Oracle Database

Database Security

This category includes three child items: Logins, Server Roles, and Credentials.

Mapping SQL Server Features to Oracle Database