No question at this time
DBA Top 10
1 B. Vroman 12800
2 M. Cadot 9900
3 J. Schnackenberg 8300
4 T. Boles 7650
5 A. Kavsek 6000
6 M. Hidayathullah ... 2100
7 G. Lambregts 1100
8 T. P 1000
8 P. Wisse 1000
10 . Lauri 800
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48302
Total active users1585
Act. users last 24h5
Act. users last hour2
Registered user hits last week210
Registered user hits last month869
Latest Forum Threads
Forcing parallel refresh for materialized view


I am working on Oracle 12c (as developer role).

Im trying to improve the execution time fo... (6 repl.)
Where is parallel option stored for materialized views DDL?


Materialized views can be created and decorated with parallel option:
create materialized vi... (2 repl.)
Primavera Issue

I am configuring my primavera P6v7 and I have this errer : Bad public user name or password. Databas... (1 repl.)
Purge 2PC

I'm trying to clear a single 2pc the transaction exists in all 3 expected tables (pending_trans$, ... (0 repl.)
Unable to refresh mv with out_of_place option (with ORA-12097)


I am working with Oracle RDBMS 12cR1.

I get the following error when I am trying to refres... (3 repl.)
Notification for a new Java version


Do you know a good way to be notified when a new version of Java has been released by Orac... (4 repl.)
RAC to NON RAC standby without asm

Hi masters,

i want to configure 2 node RAC (primary) on single instance (standby) without asm.
... (2 repl.)
--> Start a new thread ...
What is your experience with pluggable databases so far?
I have some experience with pluggable databases. Until now for databa...
With a licence for only one PDB out of the box it's not the most widel...
Actively using it for testing applications, database on the fly in min...
Already using it....but not extensively yet...
Already using. One or two gotcha's but generally ok.
R&D at the moment, with the intention of utilizing the CDB architectur...
Early days yet but a bit clunky.