ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 11744051

SQLerror

This error occur in case you have miss used values of memory_target and memory_max_target.

To overcome the same follow the following steps

Continue reading
  0 Comments

Mass Change of Material Groups in Material Master (SAP MM)

If you want to change the several materials old material group to new material group then follow the following steps :- 

Step 1. Find all the materials with old material group either from MM60 or SE16(MARA table)

Continue reading
  0 Comments

Error :Specify KERN_DIR= while Installing VirtualBox Guest Additions

04-failed-to-install
05-install-success

Issue Description

While installing Guest Additions faced with the following error

Continue reading
  0 Comments

How to search a new line character and remove it from your database?

Introduction

While working on the Database, I encountered an unique issue where I found a new line character ('\n' or Enter) at the end of my data. This leads to wrong output.

Continue reading
  0 Comments

Temporary tables in Oracle Database

Consider the following situation - a customer goes to a travel website to find out the different options for travelling to his vacation spot. For this, he/she creates a number of iteneraries out of which only one will be finalized at the end or all of them will be discarded. These iteneraries donot need to be stored in the database on a permanent basis. Storing them in a temporary table to be discarded/deleted at the end of session/transaction makes sense in such cases.

Simply put, temporary tables are used to store data temporarily during a transaction or session.

Continue reading
  0 Comments