Drop Tablespace
Database Tutorials
by Onur ARDAHANLI
1d ago
In today’s article, we will explain how to use the Drop Tablespace statement to remove a tablespace from the Database. It is best to make a tablespace offline before dropping it. [crayon-6605870c7c5fc073194082/] After ensuring that the tablespace is not used, it can be dropped as follows. [crayon-6605870c7c60b625101974/] If we want the datafiles connected to the … The post Drop Tablespace first appeared on Database Tutorials. The post Drop Tablespace appeared first on Database Tutorials ..read more
Visit website
Delete With Variable In PostgreSQL
Database Tutorials
by Faruk Erdem
2d ago
In this article, we will talk about how to perform the delete operation with the help of variables in PostgreSQL. First, let’s see the data in our veliler table. We see that Utku ERDEM has two records in the veliler table. Let’s delete this one with the help of a variable. Our record number 8 … The post Delete With Variable In PostgreSQL first appeared on Database Tutorials. The post Delete With Variable In PostgreSQL appeared first on Database Tutorials ..read more
Visit website
Tablespaces And Datafiles
Database Tutorials
by Onur ARDAHANLI
6d ago
In today’s article, we will be discussing Tablespace, which is a logical container that allows us to manage datafile groups. A tablespace can have one or more data files. A data file can belong to only one tablespace. Data files are files with *.dbf extension on the disk where our data is stored. SYSTEM, SYSAUX, … The post Tablespaces And Datafiles first appeared on Database Tutorials. The post Tablespaces And Datafiles appeared first on Database Tutorials ..read more
Visit website
Make Flashback Database Monitor
Database Tutorials
by Onur ARDAHANLI
1w ago
In today’s article, we will be cover about how to Make Flashback Database Monitor in Oracle. We get the necessary information about flashback from 3 views. [crayon-65fb02b390314594836051/] [crayon-65fb02b39031c580892251/] INST_ID(NUMBER): Provides instance information. OLDEST_FLASHBACK_SCN(NUMBER): It gives the oldest SCN that the database can receive with flashback. OLDEST_FLASHBACK_TIME(DATE): It gives the oldest time the database can receive … The post Make Flashback Database Monitor first appeared on Database Tutorials. The post Make Flashback Database Monitor appeared first on Database Tu ..read more
Visit website
Insert With Variable In PostgreSQL
Database Tutorials
by Faruk Erdem
1w ago
In this article, we will talk about how to perform the insert operation in PostgreSQL with the help of variables. [crayon-65f5e27847607162202195/] In the example above, we define our variables after the declare section. We add the columns we want to add data to between the begin and end blocks (after the insert into clause), and … The post Insert With Variable In PostgreSQL first appeared on Database Tutorials. The post Insert With Variable In PostgreSQL appeared first on Database Tutorials ..read more
Visit website
Make A Flashback Database
Database Tutorials
by Onur ARDAHANLI
2w ago
In today’s article, we will learn how to create a Flashback Database with the help of commands. 1. We check the existing data of the table on which Logical Corruption will be performed. [crayon-65f311b278dd7299868016/] 2. We create a restore point before the transaction is performed. [crayon-65f311b278de0142484078/] 3. We are learning SCN. [crayon-65f311b278df9894310836/] 4. We perform … The post Make A Flashback Database first appeared on Database Tutorials. The post Make A Flashback Database appeared first on Database Tutorials ..read more
Visit website
How To Declare A Variable In PostgreSQL
Database Tutorials
by Faruk Erdem
2w ago
This PostgreSQL tutorial explains How To Declare A Variable In PostgreSQL with syntax and examples. By declaring PostgreSQL Variables, sometimes we may need to use the values we receive from outside in operations such as insert, update and delete. We can use variables when writing a Stored Procedure or Function. First, let’s talk about the … The post How To Declare A Variable In PostgreSQL first appeared on Database Tutorials. The post How To Declare A Variable In PostgreSQL appeared first on Database Tutorials ..read more
Visit website
Flashback Enabling Procedure
Database Tutorials
by Onur ARDAHANLI
2w ago
In today’s article, we will be talking about what the Flashback Enabling Procedure is. 1. MWRPR replicas must stop. Otherwise, REPLICAT PROCESS will receive an error when the database is closed. [crayon-65ef1bcad2b7a188769127/] 2. In order to use the FLASHBACK feature in the database, the database must be ARCHIVE LOG MODE. [crayon-65ef1bcad2ba3170617598/] 3. Now that the … The post Flashback Enabling Procedure first appeared on Database Tutorials. The post Flashback Enabling Procedure appeared first on Database Tutorials ..read more
Visit website
Create Index On PostgreSQL Materialized View
Database Tutorials
by Faruk Erdem
2w ago
In today’s article, I will be explaining to you how to Create an Index on PostgreSQL Materalized View. Another nice feature of the Materialized view is that we can assign an index to the created Materialized view. I want to add an index to the first_name column to speed up the query below. We see … The post Create Index On PostgreSQL Materialized View first appeared on Database Tutorials. The post Create Index On PostgreSQL Materialized View appeared first on Database Tutorials ..read more
Visit website
Enabling Flashback Database
Database Tutorials
by Onur ARDAHANLI
3w ago
In today’s article, we will be learning how to Enable Flashback Database in Oracle. 1. We check the FRA area. [crayon-65eb4d0fd5325256852547/] 2. We check whether the database is in archive mode. [crayon-65eb4d0fd5337512572265/] 3. We check whether Flashback is enabled or not. [crayon-65eb4d0fd533a391337111/] 4. We determine the Flashback Retention period. [crayon-65eb4d0fd533c974750760/] 5. Flashback is activated. [crayon-65eb4d0fd533e028765040/] … The post Enabling Flashback Database first appeared on Database Tutorials. The post Enabling Flashback Database appeared first on Database Tutoria ..read more
Visit website

Follow Database Tutorials on FeedSpot

Continue with Google
Continue with Apple
OR