Fix IMP-00058: ORACLE error 1950 encountered


Error Description:
Import using conventional imp utility is failing with following error.

IMP-00058: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USERS'
Import terminated successfully with warnings.

Blogger Blogspot Page views Reset to Zero Today - Resolved


It is a surprise to me that my blogger page views are reset to zero today(15-Oct-2012) and a fresh counter started. This is the first time I am seeing this problem in my blogging life. As per the blogger support team it is a known issue.

Rail Radar: How to Live Locate Indian Railway Trains in Google Map!!

Indian railway launched live locator for the trains running on the Indian railway tracks with the help of the Google Maps. When you launch the web site you will get the Indian map with train indicators and you can zoom-in and zoom-out as like in Google Maps.

Index Rebuild Online Failed Oracle 11gR2: ORA-01450: maximum key length (3215) exceeded


Problem Description: Index creation or rebuild with online clause failed with following error in Oracle 11gR2.

ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded

Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory


Error Description:
Oracle 11g Client SQL* PLUS is failing with following error.
$ORACLE_HOME/bin/sqlplus
/opt/oracle/client_11_2/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

How to Find out / Check / Set Values for Hidden Underscore _ Parameters in Oracle?


Short Note on Hidden/Undocumented Parameters:
Undocumented parameters need to be tested in test database before implementing in production. Also, better to get support from oracle before going to production. Hidden parameters are for internal purpose of the oracle. You have to be very careful before implementing as they are very dangerous. It starts with ‘_’.

Validate Exception Queue: ORA-24017: cannot enable enqueue on QUEUE

Error Description:
exec DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E'); command is failing with following error.

SQL>  exec DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E');
BEGIN DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E'); END;

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer