1. SQL Server Schema Compare DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures. It is an excellent tool for any project development team or DBA managing multiple copies of the same database on an SQL Server. This database comparison tool has a clean and … Continue reading
Create database directories Execute the following commands to create a database directory. This directory must point to a valid directory on the same server as the database: Login SQLPlus 1. Start Menu > run > type “cmd” <enter> 2. c:\>set oracle_sid=<oracle_sid> 3. c:\>sqlplus system/<pwd> SQL> CREATE DIRECTORY dmpdir AS ‘/opt/oracle’; Directory created. SQL> GRANT read, … Continue reading