Categories

▼
Thursday, 26 October 2023

Generate OpenSSH rsa ssh key pair

›
Generate OpenSSH rsa ssh key pair     Windows         1. Open the Command prompt         2. Generate ssh key pair (private and public SSH ke...
Friday, 21 December 2018

How to find out if the temporary tablespace is autoextensible or not

›
Situation The user runs into multiple ORA-01555 errors stating that the TEMP tablespace is unable to extend the temp segment by a particu...

Selecting DISTINCT values from an associative array

›
Problem : Is there any built-in function in Oracle for selecting distinct values from an associative array. Answer : You can use SET op...
Friday, 24 August 2018

How to set current value of a sequence without dropping/recreating

›
Oracle does not let you change directly the value of a sequence. If you need to change its value, you should re-create the sequence. On the...
1 comment:
Friday, 23 March 2018

PLS-00313: "xxxxxx" not declared in this scope

›
PLS-00313: "string" not declared in this scope Cause : There is no declaration for the given identifier within the scope of refe...
1 comment:
Wednesday, 14 February 2018

How to Fix "ORA-12505, TNS: listener does not currently know of SID given in connect descriptor"

›
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the lis...
Wednesday, 31 January 2018

Change a user's password in Oracle

›
Question: How do I change the password for a user in Oracle? Answer: To change a user's password in Oracle, you need to execute the al...