Oracle Virtualization and Cloud Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

ORA-01762: vopdrv: view query block not in FROM

ORA-01762: vopdrv: view query block not in FROM

01762. 00000 - "vopdrv: view query block not in FROM"

*Cause:

*Action:

Error at Line: 29 Column: 18

 

Answer:: Relace join with simple muti-join table query , see below e.g.

 

WITH

NewsT AS ( SELECT P.related_id ID

FROM Profiling P

JOIN Account A

ORA-29855 error in oracle and solution & Oracle Text

We sometime see the error when insufficient privileges are assigned and CTXSYS is not presented in oracle db 10g.

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

DataPump

Typical Export & Import of Few Tables and Sequences

Export(without sequence)11.2.par

DIRECTORY=DATA_PUMP_DIR

DUMPFILE=IIS_ORACLE_VODAFONE_UAT4_02122010.DMP

LOGFILE=exp_4_BSQUAT_VODAFONE_UAT4_02122010.log

Oracle SQL STRIP HTML Tags

You can strip all HTML Tags from a text string using:

SELECT REGEXP_REPLACE('string or column containing HTML goes here','<[^>]+>','') FROM DUAL

-- CREATE FUNCTION

ORA-06553: PLS-801: internal error [56319]

Few things to do

1) Running utlirp.sql (this is going to invalidate most (for me around 80,000 objects) and then recompiles them again) Took a helluva time.. but got it sorted out. in the end.

2) Had to run utlirp.sql when database is in migration mode. (remember I ported the db from 32 bit to 64 bit).

ORA-29024: Certificate validation failure

Recently we had the pleasure of a last minute emergency replacement of a SSL certificate. I think most IT shops have been there, done that. But the problem is that the replacement renewal certificate didn’t work – now how does one proceed?

Solution of ORA-28002: the password will expire within 5 days

Error Description:
-----------------------------------

Whenever a user try to connect to database it raise ORA-28002: error.

ORA-17502: ksfdcre:5 Failed to create file +data

[oracle@VOL-ORATEST bin]$ rman target sys/xxxxx@bsquat catalog rman/xxxxx@gridem auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 19 13:12:26 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: BSQUAT (DBID=12345678)
connected to recovery catalog database
connected to auxiliary database: AUX (not mounted)
RMAN> duplicate target database to aux nofilenamecheck;
view counter