Posts

Showing posts from December, 2015

ORA-12054 while trying to create materialized view with sysdate

while trying to configure materialized view with sysdate today , Fast Refresh on commit , i received the following error :-

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view.

Regarding to Oracle Documentation there is some restriction should be considered while trying to create materialized view Check Here  or here.


But there is always workaround,

1- i create dummy table contain 1 row with 1 column only contains sysdate.
2- create Job that this sysdata on daily basis.
3- call this column in where condition of materialized view.


Problem solved.

Thanks
Osama

2015 Brief, The last Post of the year

Merry Christmas and Happy Holiday everyone.

2015 is almost done and the doors will be closed soon, and start the new year 2016 within 5 days only, I would like to thank everyone here , Family , Friends and my blog readers who keep me motivated always to write new articles when i can, and special thanks to my mother.

i learnt a lot of things this years, sadness moment gives me experience and the happiness teach me and show me who is my real friends, i met new people around the worlds make new friends, discuss different topics with people, one of the biggest achievement for me this year to be Oracle ACE Director a dream come true, when i remember this moment i also remember my friends who nominate me because without them it will not be possible Gurcan OrhanHeli Helskyaho, Jeff Smith , Tim Hallkamran agayevIloon Ellen-Wolff, Kai Yu, and Tariq Farooq , and i would like to take this opportunity to thanks Oracle ACE program who make it real for me and for the biggest effort they prov…

Import hangs On index level.

Today some customer contact me complaining that they are trying to sync the development with UAT, when i check the issue everything was normal for the first time, but the alert logs indicate that database could complete the checkpoint.

so this what i did to make the import faster ( which i completed it as well ) :-


Change database to no archive mode.increase sga_target temporary.use parallel command depend on cpu core.Use commit=N with import parameters.you can exclude indexes by exclude=indexes but i don't prefer this at all.increase db_cache_size.
This simple steps that could help someone to make import little faster or solve hang issue.
let me know if you need anything :)
Cheers Merry Christmas guys  Osama