Data Pump in Oracle
ORA-39170: Schema expression ‘ORAKLDBA’ does not correspond to any schemas : We are getting this error when we export/import in oracle. Suppose you need to take export backup of a schema or import dump of a schema which name contains string like, “ORAKLDBA.DB” or “ORAKLDBA$DB“. Some of the Places users are created with “Identified by … Read more
ESTIMATE required diskspace for EXPORT backup: During this article we are going to discuss about ESTIMATE required diskspace for EXPORT backup using ESTIMATE_ONLY parameter in Oracle Database. Here we’ll do that activity on Oracle 19c Database. ESTIMATE_ONLY parameter in Oracle Database: ESTIMATE_ONLY parameter is utilized in EXPDP command, to estimate the disc space required for … Read more
Datapump sqlfile Parameter in Oracle 19c : During this article we are going to see Datapump sqlfile Parameter in Oracle 19c and the way we are able to use sqlfile parameter in Oracle database. It will be used, only with IMPDP. This sqlfile parameter helps you to generate the DDLs from a dumpfile. Suppose i’ve … 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
