ORA-01244

ORA-01244: unnamed datafile(s) added to control file by media recovery

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

EXPDP Estimate only

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. …

Read moreEstimate Required Disk Space for Export Using Estimate_only

ORA-12919 Can not drop the default permanent tablespace

ORA-12919: Can not drop the default permanent tablespace

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

Character Functions in SQL

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 …

Read moreSQL Character Function

Enable Notifications    OK No thanks