fbpx
en English
ar Arabiczh-CN Chinese (Simplified)nl Dutchen Englishfr Frenchde Germanit Italianpt Portugueseru Russianes Spanish

sql

  • Export Backup with Date and Time
    Export with Date and Time Hello 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 … Read more
  • Import view only using impdp
    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 backup Someone 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 … Read more
  • Oracle Data Pump
    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, 19c Oracle Data Pump is an alternative to the “exp” and “imp” utilities which are used in older Oracle … Read more
  • Oracle Data Pump Utility
    Data Pump Utility In 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 … Read more
  • How to split the datapump dumpfiles || limit the file size of dumpfile in Datapump
    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 … Read more
  • How to use REMAP_TABLE parameter in impdp utility
    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 Remap … Read more
  • Check Datapump dump file is corrupted or not
    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
  • Display all the tables with foreign key
    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 … Read more
  • How to get DDL of users and roles?
    DDL of users In 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 … Read more
  • How to Change password without showing the actual password on screen?
    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
  • Using SQL Select Statements
    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 … Read more
  • What is SQL, DBMS, and RDBMS
    What is SQL, DBMS and RDBMS Hello 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 … Read more
  • How to create DB Link?
    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
  • Alter table drop column Oracle
    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 Modify In this practical, we are using the following table which has three columns. Modify Column Suppose, I want to … Read more
  • How to create a SEQUENCE step by step
    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 … Read more
  • Single Row Functions
    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 Function. Date Function. Character Function. Conversion Function. General Function. Number Function Always accept only numeric values and also return always numeric values. Number Function … Read more
  • SQL Character Function
    What is Character Functions Hello, 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 Functions There are Eight types of Character Functions in SQL. CONCAT SUBSTR LENGTH INSTR LPAD RPAD … Read more
  • How To Export Tablespace Using Expdp Data Pump Utility?
    Export Tablespace Using Expdp Hi, 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 … Read more
  • Estimate Required Disk Space for Export Using Estimate_only
    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 only Step 1. … Read more
  • How to Export Tables using PARFILE STEP BY STEP
    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 … Read more
  • Queries to Monitor Expdp Datapump Jobs Status
    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 … Read more
  • Export Backup Automation in Oracle On Linux
    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 Backup Using shell scripting, we can schedule the export backup as per our convenient time. Using the following steps we can schedule … Read more
  • Global Temporary Tables
    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
  • Data Pump Export Import Over the Network using network_link
    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 … Read more