Export with Date and TimeHello friends, in this article we are going to discuss how to take export backup with date and time, so follow me step by step. In Oracle, the EXPORT dump file name includes Date and Time.If you are taking export backup using EXP command the use below formats to generate dump… Read more: Export Backup with Date and Time

Hello friends In this article, we going to discuss how to import view only using impdp from the old dump file.How to import view only from export backupSomeone asked me how to restore a single view or all view only using impdp from any dump file. So my suggestion is below. I created three views… Read more: Import view only using impdp

DataPump Hello friends my name is Shripal Singh and in this article, I’m going to show you three topics related to Oracle Data Pump EXPORT & IMPORT, listed below.Oracle Data Pump 10g, 11g, 12c, 18c, 19cOracle Data Pump is an alternative to the “exp” and “imp” utilities which are used in older Oracle versions, Data… Read more: Oracle Data Pump

Data Pump UtilityIn this tutorial, we are going to describe the oracle data pump utility step by step.What is Data Pump Utility?Oracle Data Pump is a very fast and high-speed utility. Through the Data Pump utility, we can move data and metadata from one database to another database very fast.Oracle Data Pump flexible, faster, and… Read more: Oracle Data Pump Utility

How to set limit the file size of dumpfile in Datapump?In this article we are going to discuss how to split the datapump dumpfiles, actually, the FILESIZE parameter is used to set limit the dumpfile size. For eg., if you want to limit your dumpfiles to 50m,  you can issue use the below command.Note:  The %u will assign numbers… Read more: How to split the datapump dumpfiles || limit the file size of dumpfile in Datapump

How to Remap table during import?REMAP TABLE/SCHEMA/TABLESPACE parameter, Like you want to import a table from your existing logical backup (export backup), but the table already exists. So in this situation, how to import that table because, so in this case you can import this table with another name using REMAP_TABLE parameter. Import Table with RemapCommand will… Read more: How to use REMAP_TABLE parameter in impdp utility

Hi, in this article we are going to learn how to check datapump dump file is corrupted or not. Actually, sometimes we face the situation. We take the export backup a long time back and we are not sure the dump file is still valid or not. Sometimes the application team says the dump file… Read more: Check Datapump dump file is corrupted or not

Hello, friends in this article we are going to discuss how to display all the tables in a schema with foreign key relations and the number of records for the parent and the child tables.How do I see all foreign keys to a table or column?The following query will solve our problem, execute it as… Read more: Display all the tables with foreign key

DDL of usersIn this article, we going to discuss how we will get the ddl of users and roles. We can get the ddl of users and roles using toad also, but in this article, we are going to get metadata manually.Generally, DBA’s need to check the following details for a user, listed below.SYSTEM GRANTROLE… Read more: How to get DDL of users and roles?

Hello friends, today we are going to discuss how to change the oracle user password without showing the actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in the case of alter command, the password will show on screen, and in the case of PASSWORD, the keyword did not. In my case,… Read more: How to Change password without showing the actual password on screen?

How to use SQL select statement?In this article, we are going to learn how to use SQL select statement to retrieve data from tables or views. In the database, data stored in tables format and if you want to check that data then you should know how to use Oracle SQL statements.Important points for SQL select… Read more: Using SQL Select Statements

What is SQL, DBMS and RDBMSHello friends, in this article we going to discuss what is SQL ( Structured Query Language), DBMS (Database Management System), and RDBMS (Relational Database Management System), also understand what is the difference between DBMS and RDBMS.What is SQL?SQL (Structured Query Language) is used for Data Manipulation and Retrieval Language in… Read more: What is SQL, DBMS, and RDBMS

In this article, I’m going to show you how to create a DB Link step by step. How to create a database link, A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access… Read more: How to create DB Link?

Hello friends, In this article, we are going to discuss, how to use the ALTER TABLE ORACLE MODIFY column. Using this command we can modify table structure if required after table creation.Alter Table Oracle ModifyIn this practical, we are using the following table which has three columns.Modify ColumnSuppose, I want to change the datatype of… Read more: Alter table drop column Oracle

In this article, we are going to learn how to create and use SEQUENCE.What is SEQUENCE?SEQUENCE is an oracle shareable object which is generated numeric values and it can be unique. you can use this value as a primary key and unique value. Let see how to create SEQUENCE and how to use sequence step by step.How to create SEQUENCE?To create a… Read more: How to create a SEQUENCE step by step

Single row functions operate on a single row only then return one result for each row, there are many types of single-row functions.Following are the types of Single Row Functions.Number FunctionAlways accept only numeric values and also return always numeric values. Number Function has three sub-functions like ROUND, TRUNC, MODE.ROUND:- It’ll be round a value to the… Read more: Single Row Functions

What is Character FunctionsHello, friends in this article we are going to discuss how to use Character Functions in SQL. The character functions accept only Character type values and return in character and number both.Type of Character FunctionsThere are Eight types of Character Functions in SQL.CONCATSUBSTRLENGTHINSTRLPADRPADREPLACETRIMSo, let's understand the working of each function one by… Read more: SQL Character Function

Export Tablespace Using ExpdpHi, In this article we are going to learn how to export tablespaces using expdp data pump utility practically.What is tablespace?A tablespace is a logical unit of storage that is used by the database to store database objects like tables and PL/SQL codes.We can export tablespaces using the expdp utility which is… Read more: How To Export Tablespace Using Expdp Data Pump Utility?

In Data Pump EXPDP command use estimate only, to check the estimate the disk space required for the export backup job without performing real export backup. Before creating the export dump it's better to check dump size using estimate_only.For example we are going to take demo of scott user.EXPDP Estimate onlyStep 1. Check segment size… Read more: Estimate Required Disk Space for Export Using Estimate_only

Export Tables using PARFILE, Table export also known as the table level export in oracle data pump utility. DBA take table level export using expdp data pump command. Oracle DBA perform export import task as per there requirements. Export backup also called as logical backup.The export backup we can perform as table level, schema level,… Read more: How to Export Tables using PARFILE STEP BY STEP

How do you monitor Expdp Impdp process?This article is all about monitoring oracle DataPump jobs, checking expdp or impdp jobs status, killing running jobs,troubleshoot hang jobs, etc. Here you will get different queries, which you can use to start, stop, resume, kill and see the status of data pump jobs. So, let's monitor the Monitor… Read more: Queries to Monitor Expdp Datapump Jobs Status

Hello, friends in this article we are going to learn how to schedule database export backup automatically. Yes, it is possible to export backup automation with a crontab scheduler. How to schedule Export BackupUsing shell scripting, we can schedule the export backup as per our convenient time. Using the following steps we can schedule expdp… Read more: Export Backup Automation in Oracle On Linux

Applications regularly utilize some type of impermanent information store for processes that are too convoluted to finish in a solitary pass. Regularly, these transitory stores are characterized as data set tables or PL/SQL tables. From Oracle 8i ahead, the upkeep and the board of transitory tables can be assigned to the waiter by utilizing Global… Read more: Global Temporary Tables

In this article, we going to learn how to use the network_link parameter in oracle datapump export & import activity step by step. Case:Sometimes we need to move a table or schema from one database to another database but don't have sufficient disk space on the production server. As you know the dump file takes… Read more: Data Pump Export Import Over the Network using network_link