It is possible to import files like csv and txt into an oracle database table. There are two similar ways. Using SQL*Loader or using External Table. Their mode of operation is similar, but depending on the case, it is more suitable... read more
What is Oracle Data Guard
Data Guard is Oracle's database solution for high availability and disaster recovery. In the article we will analyze how it works and the types it has. In its use we define our production base as primary… read more
How databases are stored and what indexes are
We have seen what a relational database is and that our entities are logical objects called tables. But how are they stored “physically” in an RDBMS (relational database management system)? Tables as objects are stored and… read more
How Oracle database works
One of the most well-known RDBMS (database management system) with one of the largest percentages in the market is Oracle Database. What is special about Oracle DB compared to the competition, it offers active/active technology, i.e. a clustering of different... read more
What are databases?
We use them every day, they are necessary, most of us don't know what they are and maybe even their existence... We are talking about databases. But what do we define as a database? By term we define any set of organized data stored in a… read more
