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...
Check datapump expdp/impdp job status
As we learned how to use data pump export/import
utilities here, now we will discuss checking the datapump
job and taking action on it like terminating the job or resuming, etc.
We will take backup of full database, there is a way to add job name to backup
using JOB_NAME parameter, if do not use this parameter, the oracle will
automatically...
Rename pluggable database
There might be a situation when
you created a pluggable database with the wrong name then it's not time to
worry, you can simply rename it using rename command, in another situation
where the client requested to change the name of the pluggable...
All about oracle database auditing
12c, oracle, Oracle 12c, oracle 19c, Oracle user
No comments
As your application and database grow,
more and more users get connected to the database, and it becomes difficult to manage
all the privileges that individual user has granted. So, there is a feature
provided by the oracle called AUDITING.
Users with DBA privileges can do a lot of things
with the database, it is important to make sure that users...
oracle 19c : Metrics parameter in expdp
Here we will be discussing metrics parameter used in expdp or
impdp utility, here is the definition of metrics as per oracle, it provides
additional information about the export job in the export log file, we will see
with the help of an example
METRICS
Report additional job
information to the export log file [NO].
I performed
export...