In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left in the ASM or because …

  With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information …

  You can configure SQL Server with sp_configure at instance level. In this article I want to explain most important configurations in sp_configure. First we …

In this article I will share a few scripts in postgres databases that I think will help you manage your users. The easiest way to …

  In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script. [crayon-676f7ec6c1980807512046/]   …

  Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK …

  I have described to create linked server to connect to oracle from sql server in my article titled “How To Create a Linked Server …

We find the bin directory of PostgreSQL using the command below. [crayon-676f7ec6c1fc8210381245/]   You can see this directory in the white box in the screen …

  In some cases, a database that resides on SQL Server may require the data to be retrieved from the Oracle database.   Requirements First, …

Previously, I have described the definition of a linked server to connect to Oracle in my article titled “How To Create a Linked Server To …