Add Column Constraint PostgreSQL
Database Tutorials
by Faruk Erdem
1d ago
In the table, we can use column restrictions on how to keep the data in general, whether to enter a null value in the relevant column in the table, what to do if an empty value is entered, and in cases where we do not want the same data to be entered more than once. … The post Add Column Constraint PostgreSQL appeared first on Database Tutorials ..read more
Visit website
Dump File Reuse
Database Tutorials
by Onur ARDAHANLI
2d ago
We can use the existing dump file with the same name only once. If we want to use it continuously, reuse_dumpfiles=y is used. [crayon-63de75d76286d033459293/] The post Dump File Reuse appeared first on Database Tutorials ..read more
Visit website
Empty Trash In Oracle
Database Tutorials
by Buğra PARLAYAN
4d ago
In today’s article, I will answer the question of How to Empty the Trash in Oracle Database. To remove the entire contents of your recycle bin, issue the following statement: [crayon-63dc70ce6d599773235456/] To remove the entire contents of all recycle bin, issue the following statement: [crayon-63dc70ce6d5a3468164180/] The post Empty Trash In Oracle appeared first on Database Tutorials ..read more
Visit website
Oracle Make Copy Of Schema
Database Tutorials
by Onur ARDAHANLI
6d ago
Today I will be explaining How to Make Copy of Schema in Oracle Data Pump. 1. We take an export backup of the schema to be copied. [crayon-63d95c7b31036721413180/] 2. With the import operation, we give a new name to the schema and a backup of the original schema is created with all the objects. [crayon-63d95c7b31042403313808/] … The post Oracle Make Copy Of Schema appeared first on Database Tutorials ..read more
Visit website
ORA-01665: Control File Is Not A Standby Control File
Database Tutorials
by Buğra PARLAYAN
1w ago
In today’s article, I will share with you the solution to the error I got after restoring the backup database from the RMAN backup. Error: ORA-01665: Control File Is Not A Standby Control File Solution: First we check the database_role of STANDBY. [crayon-63d830b37b155885398139/] After, we convert Primary database to Standby database. [crayon-63d830b37b168307284574/] Finally: [crayon-63d830b37b16c688362583/] The post ORA-01665: Control File Is Not A Standby Control File appeared first on Database Tutorials ..read more
Visit website
Create Table In PostgreSQL
Database Tutorials
by Faruk Erdem
1w ago
In today’s article, we will talk about What is a Table in PostgreSQL and How to Create it. We opened our database to collect our data in one place, but we do not know in which data type and which names they will be kept, so we will learn the concept of tables. Creating a … The post Create Table In PostgreSQL appeared first on Database Tutorials ..read more
Visit website
Stop The Job
Database Tutorials
by Onur ARDAHANLI
1w ago
It may be necessary to temporarily stop a running export/import process for some reason. In this case, we may need to attach it first. 1. Let’s have an export as below. [crayon-63d569b020fa5691639145/] 2. From another terminal window, connect to the database with SQL*Plus and learn the owner of the job and the name of the … The post Stop The Job appeared first on Database Tutorials ..read more
Visit website
Active Session In Oracle
Database Tutorials
by Buğra PARLAYAN
1w ago
In today’s article we will learn How to See Active Session in Oracle Database. With the help of the code block below, we can see the Active Session. [crayon-63d48618bb1e4622877289/] The post Active Session In Oracle appeared first on Database Tutorials ..read more
Visit website
PostgreSQL Data Type Limits
Database Tutorials
by Faruk Erdem
1w ago
In today’s article, we will learn about integer data types and the last values they will take in the range section. These values are given in the table below. For example, you cannot enter more than 32767 in a column with data type smallint. When you try to insert the number 32768 into the column … The post PostgreSQL Data Type Limits appeared first on Database Tutorials ..read more
Visit website
Export/Import Job Attach
Database Tutorials
by Onur ARDAHANLI
2w ago
We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need to know the owner of the running process. The owner of the running process can be seen by querying the DBA_DATAPUMP_JOBS view. [crayon-63cfac4ad60d8662965673/] In order to see the query results … The post Export/Import Job Attach appeared first on Database Tutorials ..read more
Visit website

Follow Database Tutorials on Feedspot

Continue with Google
OR