IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I will explain the DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error in this …
Read More »
June 8, 2020
Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course
Hi, I will share with you Step by Step Oracle SQL Tutorials For Beginners. 22,528 views l…
May 10, 2020
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this…
April 15, 2020
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database…
December 10, 2019
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA
Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in …
July 4, 2019
Dataguard ( Standby ) Monitoring Lag Command and Scripts | Oracle DBA Scripts All in One -2
Hi, I will share all Oracle DBA Scripts related Dataguard in this post. 18,107 views last…
4 days ago
DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error
I will explain the DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error in this …
4 days ago
ORA-12990: duplicate option specified
I got ” ORA-12990: duplicate option specified ” error in Oracle database during import (…
4 days ago
ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash table/partition
I got ” ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash tab…
4 days ago
ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-27029 | ORA-19507
I got ” ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-2702…
4 days ago
ORA-64308: hybrid columnar compressed table cannot have column with LONG data type
I got ” ORA-64308: hybrid columnar compressed table cannot have column with LONG data typeR…
DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error
ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash table/partition
PostgreSQL – How to Eliminate Repeated Values
Benefits of having a tool to monitor your SQL server
Uninstall SQLT or Drop SQLT ( SQLTXPLAIN ) in Oracle
PySpark Makina Öğrenmesi (PySpark ML Classification Decision Tree)
PySpark Makina Öğrenmesi (PySpark ML Classification) Merhaba PySpark yazılarına devam ediyoruz. Bu yazıda classification algoritmalarından …
Read More »
PySpark Makina Öğrenmesi (PySpark ML Classification Preapering)
PySpark Makine Öğrenmesi
Advanced RDD Actions
PySpark RDD Example
Clustering Wikipedia
Clustering Wikipedia Hi, in this article i’ll make a simple clustering example using wikipedia. You …
Read More »
Dimension reduction with PCA | Python Unsupervised Learning -6
Dimension reduction | Python Unsupervised Learning -5
t-SNE visualization | Python Unsupervised Learning -4
Introduction to gensim (Python)
Azure SQL Database administration Tips and Hints Exam (DP-300)
Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during …
Read More »
JSON in SQL Server
SQL CASE Statement
Software Review – Stellar Repair for MS SQL
Ways to Track Deleted Database in SQL Server
How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers
Hi, I will explain How to Clear ILOM FMA Faults And Reset The SP on …
Read More »
How to Shutdown and Startup Exadata and Oracle Databases
Exadata Temp Tablespace Migration To Flash Disk
Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata -2 Manual 18c Database Upgrade
Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata -1 29757256 Patch Apply
Android Programming -15 Custom Adapter
Hi guys in this tutorial we will continue the custom adapter. In my previous article, …
Read More »
Android Programming -14 Custom Listview-2
Android Programming -13 Custom Listview
Android Programming -12 ArrayAdapter
Android Programming -11 Listview Component
OGG-01454 Unable to lock file | Resource temporarily unavailable on Replicat
Hi, Sometimes You can get ” OGG-01454 Unable to lock file | Resource temporarily unavailable …
Read More »OGG-02028 Failed to attach to logmining server error 24,377 – ORA-24377: invalid OCI function code
OGG-02636 The TABLE specification for the source table does not include a catalog name. The database requires a catalog name
OGG-02058 The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed: No minimum supplemental logging is enabled
OGG-08223 ERROR: One or more containers must be specified when registering Extract for a container database.
How to connect to Oracle from Your Windows Host to a VirtualBox Guest
I am sure that anyone who wants to work on a database or a data …
Read More »Windows İşletim Sistemi ile Oracle Linux Sanal Makinesinin haberleştirilmesi(Virtualbox)
Veri Ambarı Konsepti(OLAP,OLTP)
Tableau Server Architecture
Tableau Server has a high scalable architecture that many users can connect and receive service …
Read More »Tableau Sunucu Mimarisi
DATA WAREHOUSE – ETL/ELT
What is the ETL / ELT? ETL or ELT is not a software abbreviation. It …
Read More »
Introduction of DATA WAREHOUSE-What is DATA WAREHOUSE?
Introduction of DATA WAREHOUSE-What is DATA?
Data Warehouse Architectures
Constraints ( Primary Key, Foreign Key , Unique Key, Not Null and Check ) in Oracle SQL | Oracle SQL Tutorials -30
Hi, I will explain Constraints ( Primary Key, Foreign Key , Unique Key, Not Null …
Read More »Alter Table and Alter Table Add or Drop Column in Oracle SQL | Oracle SQL Tutorials -29
SQL Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -28
Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27
SQL Subquery, Nested Queries and In Any All Operator in Subquery in Oracle SQL | Oracle SQL Tutorials -26
dbms_output.put_line in PL/SQL
I will explain dbms_output.put_line in PL/SQL in this post. 23,411 views last month, 581 views today
Read More »
Alter Session Set NLS_DATE_FORMAT in Oracle with Examples
PL/SQL Conversion/Decoding/NULL-Related Functions
PL/SQL Datetime Functions
PL/SQL – Number Functions
PostgreSQL – How to Eliminate Repeated Values
It’s possible that in a table, some field that has repeated values is necessary to …
Read More »
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Bulk Insert and Bulk Update in Oracle Database
What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16
How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control | Oracle Database Performance Tuning Tutorial -15
Usefull Scripts For Couchbase Dba
Why Couchbase? Today’s mission-critical applications demand support for millions of interactions with end-users. Traditional databases …
Read More »
MongoDB Backup and Restore Using MongoDump
How to Access MongoDB Instance 4.2?
How to Install MongoDB on Windows System?
How To Install MongoDB 4.2 on RedHat/ CentOS 7 systems
Recent Posts
July, 2020
- 13 July
Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27
Hi, I will explain Create Table ( CTAS ) and Data Types in Oracle SQL in this post of Oracle SQL Tutorial series. 3,506 views last month, 15 views today
Read More » - 13 July
SQL Subquery, Nested Queries and In Any All Operator in Subquery in Oracle SQL | Oracle SQL Tutorials -26
Hi, I will explain SQL Subquery and Nested Queries in Oracle SQL in this post of Oracle SQL Tutorial series. 1,267 views last month, 15 views today
Read More » - 10 July
SEARCH ENGINE OPTIMIZATION-3
Google Indexing Indexing of new sites takes place by getting them into the Google archive. When Google bots find a suitable SEO criterion during the first visit of a new …
Read More » - 9 July
Complete Process to Copy Table from One Database to Another ( Export-Import ) in SQL Server
At times, as a DBA, users need to copy tables from one database to another in a similar instance or in an alternate SQL instance, for example, replicating explicit tables …
Read More » - 8 July
Intersect and Minus in Oracle SQL | Oracle SQL Tutorials -25
Hi, I will explain Union and Union All in Oracle SQL in this post of Oracle SQL Tutorial series. 735 views last month, 16 views today
Read More »
