A database link is an important
schema object in the oracle database, we should know details about it in order
to implement it in real-time applications,
Assume you have two different
applications with two different databases, and while generating reports, you
need to fetch and merge data from both the database, it’s a good idea to use a database
link,...
Snowflake : Different editions of snowflake
As we know, the
snowflake is a very hot data warehouse technology today. we will see a
different aspect of a snowflake in different articles, here we will discuss its
different editions available for use.
The below image gives
an...
Snowflake : Introduction and Architecture
Snowflake is a very trending data
warehouse technology due to its benefits and features over traditional database
technology, here we will have a brief introduction to snowflake data warehouse
and its architecture
Snowflake is true software...
AWS : Setup free demo account
We have discussed the
basics of AWS in a previous article, now let's create an amazon web service
free demo accountPre-requisites A valid email idA valid payment
option such as a credit or debit card
once you are ready, open
https://aws.amazon.com...
Flashback query in oracle
You must have heard
about the time machine in movies or magazines, just think of an oracle
providing the same feature with its databases, and that is called a
flashback.
We can go back in
time to query data from the table, of course, there are certain limits to it,
but it’s possible, we will learn this with an example.
Here is the table
employee, with...
pfile and spfile in oracle database
In this short article, we will discuss the server parameter
file and initialization parameter file i.e., spfile and pfile
pfile - parameter file, is a text-based
file, readable and editable with any text editor
spfile- server parameter file,
binary file, readable with only some utility and can not be edited.
pfile is
called...
using nid to change oracle database SID or oracle database name
In this article, we
will discuss using the nid utility to change database sid or database name
without dropping and recreating the database, before starting this activity
make sure you have a good backup of the database as a rollback strategy.
current database name:
technodb
new database name: ...