Generate user ddl in Oracle: In this article we will discuss about how to Generate user ddl in Oracle. You can use below scripts to generate DDL statements for a user or multiple users with their roles, system and object privileges. To generate ddl for a specified user: In this case we generate ddl for … Read more
How to generate tablespace ddl in Oracle: In this article we will see How to generate tablespace ddl in Oracle for one tablespace and all tablespaces. Generate one tablespace’s ddl By this below query you can generate tablespace ddl for a specified tablespace. After run this query it will ask you to provide the tablespace_name. … Read more
Drop And Recreate Temp Tablespace In Oracle : During this article we’ll see how to Drop And Recreate temp tablespace In Oracle Database. Note :- While doing this activity, existing temporary tablespace may have existing live sessions, due to same oracle won’t let us to drop existing temporary tablespace. Resulting, we need to kill existing … Read more
Apply Patching On Oracle 19c Database Release Update 19.6.2.0.200714: In this article We are going Apply Patching On Oracle 19c Database Release Update 19.6.2.0.200714 (Patch 31212138). For this activity you can follow Oracle Database 12c Release Update Known Issues (Doc ID 2663985.1) Description:- This article we are going to see steps used to apply the … Read more
Upgrade Oracle Database Manually from 12.2.0.1 to 19c: In this article we will see how Upgrade Oracle Database Manually from 12.2.0.1 to 19c. Follow the below Steps for this activity: Environment : Pre-Upgrade Tasks : Step-1 Take Backup : In this case we take Database RMAN full backup. Take Backup of Network files, init files, … Read more
Datapump DUMPFILE Parameter in Oracle 19c : In this article we will see Datapump DUMPFILE Parameter in Oracle 19c and how we can take export backup in one or multiple dumpfile in Oracle database. This article guides you through the process of using the Export and Import utilities in Oracle Data Pump, or using the … Read more
Datapump Database Level in Oracle 19c : In this article we will see Datapump Database Level in Oracle 19c and how we can take database export backup and import in Oracle database. This article guides you through the process of using the Export and Import utilities in Oracle Data Pump, or using the original Export … Read more
Datapump Tablespace Level in Oracle 19c : In this article we will see Datapump Tablespace Level in Oracle 19c and how we can take one or multiple tablespaces export level backup and import individual or multiple tablespaces in Oracle database. This article guides you through the process of using the Export and Import utilities in … Read more
Datapump Schema Level in Oracle 19c : In this article we will see Datapump Schema Level in Oracle 19c and how we can take one or multiple Schema export level backup and import individual or multiple Schema in Oracle database. This article guides you through the process of using the Export and Import utilities in … Read more
Datapump Table Level in Oracle 19c : In this article we will see Datapump Table Level in Oracle 19c and how we can take one or multiple table export level backup and import individual or multiple table in Oracle database. This article guides you through the process of using the Export and Import utilities in … Read more
