Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
Learn how to protect oracle database using ORACLE’s revolutionary feature – Database Vault.
In this first chapter we will show you how to install ORACLE Database Vault, and PROTECT schema objects using DV REALMS.
Oracle 10g Supply a new alter table option that enables online table reorganization, this option is shrink
Programmers often retrieve big result set using queries and need to split them up in order to display the result correctly. This tip shows you how to split oracle query result sets into pages.
In some cases we have to connect to the database as a specific user, but don’t know the password.
There are two ways to handle this problem:
Log shipping is the process of automating transaction log copy and apply in order to maintain identical database copy for high-availability or disaster recovery proposes.
Learn how to audit sql server’s login, its simple and its quick.
Microsoft SQL Server enables you to back up and restore your databases. The SQL Server backup and restore component provides an important safeguard for protecting critical data stored in SQL Server databases.
SQL Server 2005 provides a set of high availability methods that the users can use to achieve fault tolerance and to prevent server outages and data loss. The selection of the high availability method depends on various factors. Some DBAs need the servers to be available 24/7, while others can afford an outage of a couple of hours. Cost also plays a role in the selection. For example, Clustering is an expensive high availability method when compared to Database Mirroring, but it allows the user to failover immediately.
enjoy the benefits of single sign-on to all of your applications, whether you are connected to the corporate network, traveling away from the office, roaming between computers or working at a shared workstation.
Learn how to fully utilize database vault factors to control access to your database objects.