In this article, we are going to learn how to create an ASM diskgroup, so here I’m going to show you the complete steps to creating ASM devices and then the ASM disk group. To creating ASM diskgroups you can use asmca (Oracle ASM Configuration Assistant) which is providing a …
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 …
Hi friends, in this article we are going to solve the ORA-01244 error, that you will be facing during manual database recovery. ORA-01244 unnamed datafiles added to control file by media recovery Cause: Actully that error most of the time you will face during the recovery, due to the datafile …
Read moreORA-01244: unnamed datafile(s) added to control file by media recovery
In this article we are going to learn how to load oracleasm module or solve if oracleasm not mounted. Some time we face loading module oracleasm failed error. During creating the ASM disk we are facing the below error Read: Oracle Database Migration from Non-ASM to ASM oracleasm module not …
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. …
Read moreEstimate Required Disk Space for Export Using Estimate_only
How to fix ORA-01654 unable to extend index in tablespace Hi guys, I’m getting an “ora-01654 unable to extend index” error during the production database shutdown in the system tablespace. Actually, in my case, the database is created manually and the tablespace size is 200MB and autoextend also is off. …
Hello friends, in this article we are going to learn how to rename a database using the NID utility step by step. So in this demo, we are going to rename the db11g database name to ocptech. Before the NID utility, we can rename the database using creating a new …
Hi, Today I am getting the “ORA-12919: Can not drop the default permanent tablespace” error. Actually, I tried to drop users tablespace which is the default tablespace for the database user and I’m getting the above error. ORA-12919 Can not drop the default permanent tablespace Cause – We tried to …
Read moreORA-12919: Can not drop the default permanent tablespace
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 …
Read moreHow To Export Tablespaces Using Expdp Data Pump Utility?
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 …