How To Move The Temp Tablespace to Another Diskgroup On Oracle

16 Jul by dbtut Tags: , , , , , , , , , , , , , , , ,

How To Move The Temp Tablespace to Another Diskgroup On Oracle

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 of other reasons. In this article we will do this step by step. First we query the empty spaces in the diskgroups in ASM by using the following script. In […]
15 Jul by dbtut Tags: , , , ,

How To Create a Restore Point On Oracle

  With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information about the Flasback Database you can read the article “What is FLASBACK DATABASE And How To FLASHBACK” With the command below, create a restore point while the database is in […]
14 Jul by dbtut Tags: , , , , , , , , , , , , , ,

sp_configure(Server-Level Configurations in SQL Server)

  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 run the script below to make the configurations we want. [crayon-5c19342976045821119334/]   Then, after this script, we just run sp_configure. Below you can find what I have configured on my […]
14 Jul by dbtut Tags: , , , , , , , ,

How to List PostgreSQL Users and Permission

  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 list users is to run the following command. But it will not give you detailed information. [crayon-5c19342976291716231954/]   With the help of the following script you can see which […]
13 Jul by dbtut Tags: , , , , , , , , , , , ,

What is FLASBACK DATABASE And How To FLASHBACK

  Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK Database as an alternative to incomplete database recovery. Of course, you will get faster results than restore-recovery.   Conditions The following conditions are required in order to return the database […]
13 Jul by dbtut Tags: , , ,

How To Create a Linked Server To Connect To SQL Server From SQL Server

  I have described to create linked server to connect to oracle from sql server in my article titled “How To Create a Linked Server To Connect To Oracle” and to authorize a new SQL Login to this linked server in the other article titled  “How To Define a New Login On The Linked Server“. […]
12 Jul by dbtut Tags: , , , , , ,

How To Find PostgreSQL lib and bin Directories

We find the bin directory of PostgreSQL using the command below. [crayon-5c19342976a7e575517799/]   You can see this directory in the white box in the screen below.   We go to this directory using the “cd” command and run the following command to find the lib directory. [crayon-5c19342976a84849348834/]
12 Jul by dbtut Tags: , , , , , , , ,

How To Create a Linked Server To Connect To Oracle

  In some cases, a database that resides on SQL Server may require the data to be retrieved from the Oracle database.   Requirements First, a related user is created on the oracle side. If the Oracle Client did not installed on the server where your SQL Server is located,, the installation is necessary. The […]