How to avoid ORA-01555 “snapshot too
old" error?
From the developer’s
perspective:
Restructure your PL/SQL code to
avoid fetching across commits that cause the ORA-01555 error.
One possible reason can be if we
leave the cursor open for fetching while
we are processing and committing data changes for a long time.
To chmod /change the permissions of the file on FTP server For a given scenario , if you want to change the permissions of a…
During rescue mode, there can be problems with grub-installation if we are not able to ‘chroot’ in the correct OS environment. so, if the rescue…
Installing sample schemas(HR,OE,PM etc…) in Oracle 10g R2
1. Get the companion disk for Oracle 10g from oracle.com
2. Unzip and extract the contents on the server
3. Run the Oracle Universal Installer to install the components, choose "Oracle database products"
Read more
A no. of errors are encountered while importing dump files in Oracle database.
Some of them are due to
1. Tablespace not found.
2. User/Role not found.
3. Incorrect database charset
If correct parameters are not provided to the person doing the import, it a more of HIT/TRIAL methdology.
Try using this query to identify the approach to attack invalid objects in the schema select referenced_name, count(referenced_name) cnt from user_dependencies where referenced_name in (select…
NMap tutorial for beginners-part 2 It’s assumed that you are root. Many options won’t work or better to say will switch to other…
With the default installation of Ubuntu 7.10, while trying to browse the connected bluetooth devices such as a phone, the following error is displayed
To get sound working with HDA-INTEL sound card on Linux there are many help pages available but the below option worked for me in a couple of Linux distributions.
To play different video files in GNU/Linux, there are various players,however to get them working, you need to have all available plugins to play the…