-
How Can I See Hidden Parameters In Oracle Database
Q : How Can I See Hidden Parameters In Oracle Database SELECT a.ksppinm AS parameter ,a.ksppdesc AS description ,b.ksppstvl AS…
Devamını Oku » -
How Can I See Invalid Object In Oracle Database
Q : How Can I See Oracle Invalid Object SELECT OWNER ,object_type ,object_name ,STATUS FROM dba_objects WHERE STATUS = 'INVALID'…
Devamını Oku » -
ORA-01555:Snapshot too old rollback segment number
ORA-01555: snapshot too old: rollback segment number string with name “string” too small. Cause: Rollback records needed by a reader…
Devamını Oku » -
ORA-01000: Maximum Open Cursors Exceeded
SELECT Max(a.value) AS highest_open_cur, p.value AS max_open_cur FROM v$sesstat a, v$statname b, v$parameter p WHERE a.statistic# = b.statistic# AND b.name…
Devamını Oku » -
ORA-00020: Maximum Number Of Processes Exceeded
When i tried to connect to database, i got the ORA-00020: maximum number of processes (%s) exceeded error. Even from…
Devamını Oku » -
ORA-24247: Network Access Denied By Access Control List (ACL)
ERROR :While sending mail using utl_mail or utl_stmp in oracle 11g, you may get access denied error: begin utl_mail.send(sender =>…
Devamını Oku » -
ORA-39358: Export Dump File Version Not Compatible
ERROR :While importing dump file, got error as ORA-39358: Export dump file version 12.2.0.1.0 not compatible with target version 11.2.0.4.0…
Devamını Oku » -
ORA-39095: Dump File Space Has Been Exhausted: Unable To Allocate
ERROR :While running data pump with filesize parameter, got below error $ expdp dumpfile=DBABUZER.dmp logfile=DBABUZER.log directory=DP_DIR filesize=500m full=y Starting "SYS"."SYS_EXPORT_FULL_01":…
Devamını Oku » -
ORA-28017: The Password File Is In The Legacy Format
PROBLEM:While granting sysdba privilege to an user, got below error. SQL> grant sysdba to ABUZER; * ERROR at line 1:…
Devamını Oku » -
ORA-01950: No Privileges On Tablespace ‘USR_ABUZER’
ERROR :While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. SQL> create table ABUZER.SAMPLE_TBL as select * from user_objects;…
Devamını Oku »