Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In SQL Server, sometimes you do not want anyone to see the contents of an important column in an important table. In such a …
Read More »
dbtut
ORA-24247: network access denied by access control list (ACL)
Assume that the user receiving the error is SCOTT. In this case a checklist should be created for the SCOTT user. You can use …
Read More » How To Detach and Attach a Database Containing FileStream Data
You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …
Read More »Running SQL Server With High Performance(High Performance)
It is a setting made on windows so that SQL Server can work with higher performance. This setting can be made on Windows Server …
Read More »Enterprise Manager OC4J Configuration issue
ERROR : OC4J Configuration issue. <ORACLE_HOME> / oc4j / j2ee / OC4J_DBConsole_ <SERVER> _ <SID> not found. SOLUTION : The passwords of sysman and dbsnmp …
Read More »ORA-01552: cannot use system rollback segment for non-system tablespace ‘XXXX’
The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …
Read More »What is Contained Database and How To Create
We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …
Read More »How To Move Logins To Another Instance(sp_help_revlogin)
If you do not use a contained database, you must also move your logins when you move the database to another instance. You can …
Read More »ARCn:Switch failed , ARC1:Switch failed
This error is taken when the archive log target directory is filled in databases that are in archive log mode. SOLUTION: As a solution, …
Read More »How To Create a Login On SQL Server(Manage Logins)
From the Security tab, right-click on Logins and click on new login. In the window that opens, we give a name to Login from …
Read More »