ORA-01450: maximum key length (3215) exceeded

Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem.

Solution: The issue was fixed with rebuilding the […]

Read More

ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE

You might encounter ORA-16179 error while changing the archive destination.

There is syntax error in above command . It should be like log_archive_dest_n [n is a integer from 1 to 31]=’LOCATION=path_for_archive_log’ example :

Thank you for giving your valuable time to read the above information. If you want to be updated with all […]

Read More