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: ...
Installation of Python 3.10 on windows
This is going to be a short article with just a few steps for the installation of pythonStep 1: download python for windows for installation from https://www.python.org/downloads/windowsStep 2: click on .exe file for execution, you will...
Introduction to Python and Writing first program
Python is an open-source programming language, open-source refers to
free availability and cost-effectiveness. Python is a cross-platform language- it means once the program is
written in python, the same code can be executed on any operating...
ORA-39161: Full database jobs require privileges
I was trying to take full export
backup of the database using user from the pluggable database, the export
command threw below error
Users\shaik>expdp userid=techno_user@technopdb directory=export_dir
dumpfile=expdp_full_db.dmp logfile=expdp_full.log full=y
Export: Release 19.0.0.0.0 - Production on Tue Jun 14 20:42:47 2022
Version...