After 9 years i got this video. Explanation was great 👍
@KitsuCuts5 ай бұрын
are ya a dba?
@nagavamsitata7289 Жыл бұрын
i surprised withway of your teaching 1-time i am good at this issue bro....tqq
@chiu31526 жыл бұрын
at 12:05 how did you have copy of putty on notepad? Thanks
@venkateshjilla64478 жыл бұрын
sir super explanation ,very need full for beginners. thanks a lot
@mazharnazar19357 жыл бұрын
Please you should have to make a playlist of oracle??
@jamsjams30839 жыл бұрын
Nice Real time scenario,,, useful for future purpose :)
@hailelove13 жыл бұрын
awesome thank u. what if I want to restore a data committed by specific user. in your scenario it will restore the whole scott.dept table
@parasgupta01086 жыл бұрын
Thank you for sharing such a valuable information with us
@SNRCHANNEL99 жыл бұрын
Really awesome demo
@pasupuletiramanatha99236 жыл бұрын
hi ramkumar i am working as a ORACLE DBA i need to do practice more so will you provide lab servers at lease two two node RAC set up? If you dont mind i ll pay rent also.
@godhulidas38965 жыл бұрын
Why after the commit show parameter undo statement gives the error of table or view does not exist?
@ibbure7 жыл бұрын
good one looking for more.. if time exceeds like one or two hours then same procedure will work.
@sightraja8 жыл бұрын
hi incase undo_retention time 900s i lost the table before 1hr its possible this method?
@sainathsai77192 жыл бұрын
Hi hello in oracle DBA mainly on what concepts should I focus more for fast growth in this domain can you please tell me
@i_shout34936 жыл бұрын
Can you please make a video on making a database using command prompt in windows as well, using sqlplus.
@nadunsamarasinghe55924 жыл бұрын
It's really helpful, Thank you so much...!
@unitrfpl4073 жыл бұрын
Any classes will be taken ??
@OrSklAnlaytics3 жыл бұрын
Not at the moment.
@karunakarpe72286 жыл бұрын
This is very informative.. can you please let me know the fee and points or syllabus of online dba course.
@OrSklAnlaytics4 жыл бұрын
Please whatsapp on +919951696808 for career guidance
@ramsri71488 жыл бұрын
Good Tutorial and Teaching method is very good and clear.
@xiaodongli17878 жыл бұрын
Thank you! Very helpful!
@henrijeune10 жыл бұрын
Awesome demo man!
@vinayakbudapanahalli1926 жыл бұрын
Very easy to understand for beginners!!
@kkrkk11132 жыл бұрын
Hello sir Direct comes to back flash query why use so many lines sir
@mayurikarlewar93133 жыл бұрын
Need Real time scenarios. How to contact you?
@ashokkumar96760 Жыл бұрын
Hi Kumar, This is Ashok can you please do a video for me on " i taken backup of Source DB on 01.09.2023 and i copied it to Target Database server as nfs - type in mountoint u01. now i lost my controlfiles in that backup which is in Target server. "How to recover lost Controlfiles from backup in Target server. and Restore with that control files on 27.09.2023.
@dharmatejakothuri24537 жыл бұрын
nice one thank you for the demo.. much useful
@sahamnadeem47257 жыл бұрын
u skipped to create directory ....... i was in great trouble :(
@prakashkanaka7 жыл бұрын
Very nice demo, useful, thank you very much.... I have a small query. can you help me on this ? in the last, you shown the log of the whole session, how ? can you please tell me how to take the log of a particular session ?. Many thanks in advance for your prompt response :)
@manpreetsingh856 жыл бұрын
Fantastic sir it's working. I checked it
@ajeshkumar85606 жыл бұрын
So do we need flashback enable in database to do this flashback activity?
@mizanulkarim84664 жыл бұрын
Can i get back of data before 30 days using flahback?
@msham20058 жыл бұрын
Hi it's good one,, One doubt... During the user error and the time of flashback , there will be at the same time other transactions occur in the same table by other users... So when we flashback table as per one user's request , all transactions made by others are also flashed back!! Hence, how will other user tolerate the flashback ? Is there any method to flashback only a particular statement and not the whole thing? LogMiner is the solution ? please tell. thanks
@OrSklAnlaytics8 жыл бұрын
+Shameem. M. Thats exactly what happens... In case if you know other transactions and their time frames as well, then there is a possibility of rolling back only the transactions which are faulty.
@msham20058 жыл бұрын
Ya.. But , suppose thousands of transactions can occur in between while we flashback someon'e fault... Hence what about all people's real transactions.. ? Could you answer this doubt?
@msham20058 жыл бұрын
hi...
@OrSklAnlaytics8 жыл бұрын
Hi, Nice point you made. Flashback itself has got an option to do this with "FLashback transaction query" and also "Flashback version query" which can help you get this done.
@RasKay098 жыл бұрын
OrSkl Academy
@MrCloudDBA9 жыл бұрын
Useful demo
@poojasonavane2 жыл бұрын
Should I be master in oracle ?? Or freshers can handle this ??
@khalidisin5 жыл бұрын
what is the other method if flashback is not enabled ? how would i get my table back?
@ansarikhalid5940 Жыл бұрын
Using rman you can recover the table from 12c this feature is introduced
@SanjeetKumar-ch4wq8 жыл бұрын
How to Contact you, what are fees, time and duration etc? I am willing to join asap. May be this week.
@mohamednawas33269 жыл бұрын
Great work.
@as9552 Жыл бұрын
i would like to join your class ...offline or online whatever mode...please share your contact details thanks...
@chitrakgarg11143 жыл бұрын
Why we use scott.dept. What Scott represents in this query?
@ansarikhalid5940 Жыл бұрын
Scott is the schema and dept is the table under scott user
@asadulislam57067 жыл бұрын
hlw sir your explanation is really good...i'hv one query that can you explain about ora-12154 through youtube vedio.....if do ...i'll be pleased....thx.!!!
@abbeydudeuk6 жыл бұрын
bring back table or record? if its table in prod they will fire employee
@bhawnadhiman21016 ай бұрын
Hi , i want to join your class
@kumkumsingh56224 жыл бұрын
Thank you! Very helpful!Sir
@sriK55807 жыл бұрын
Its awesome demonstration.
@daveat9577 жыл бұрын
when the data is overwrote what is the process to undo the error
@tejupansare49474 жыл бұрын
When say exit it directly close sql plus
@chuimurimi8 жыл бұрын
I want to be a DBA how can I contact you for more information.
@purushothampuru47708 жыл бұрын
nice sir..
@sahamnadeem47257 жыл бұрын
what if before 15 mins mu table has 8 rows n now i have 20 rows what if i flash back now ... will my table be remain same or will be 8 rows again??
@monday67407 жыл бұрын
Logically, it would have 8 rows, since that is what the Flashback function was asked to do. You'll have to get the new (12) records back another way, but not using the IMP/replace function.
@mohan19589 жыл бұрын
The link you provided does not work on facebook..
@OrSklAnlaytics8 жыл бұрын
+Mohan Ramaswamy Hi, it works ... facebook.com/orsklacademy or our website www.orskl.com
@kadapalaraghu23345 жыл бұрын
any online training ?
@asifiqbal58775 жыл бұрын
very good lecture.
@ericksoncena9 жыл бұрын
nice video
@askarihassan98177 жыл бұрын
helo sir kindly can you provide me the complete database administration tutorial using oracle tool .i have done the introduction to sql tutorial but i require the complete tutorial.
@abhirai32515 жыл бұрын
Sir is there any Oracle University in Kolkata or Bangalore ? where we can learn Oracle DBA . If yes then please give details of it
@abdulquadir87852 жыл бұрын
ORA-39002,39070,39087 these error's are occurring sir after providing the password before going to next step please help me......!!!!!
@atulchandge47346 жыл бұрын
How to check Database Health?
@hasibullahmamozai34843 жыл бұрын
thank you sir
@vamsee02469 жыл бұрын
how can i learn directly these real time activities in oracle dba
@OrSklAnlaytics8 жыл бұрын
+vamsee0246 You can check our website www.orskl.com for the course on real time activities.
@hemantkumar55785 жыл бұрын
Hi all, If i deleted the temporary tablespace, then can i open the Database ¿¿ or while opening its will show missing temporary file
@ansarikhalid5940 Жыл бұрын
If you drop the temporary tablespace nothing will happen on next startup the temporary tablespace will be created automatically by using controlfile
@ibrahimmuhammad95093 жыл бұрын
Lecture is soft toooo
@srikrishnagiri53368 жыл бұрын
Nice lecture
@karthiksrirambatla30747 жыл бұрын
i want some more realtime activities
@komalayaddanapudi905910 жыл бұрын
A good demo :)
@pavanmanikantakumar2 жыл бұрын
Hai sir i need oracle apps dba tutorial .
@PrakashPraaku8 жыл бұрын
Hello sir, I'm a non technology background student, working in an MNC company, can non technology people also learn Oracle DBA and get job in that field, are there any such instances, please respond, Thanks in advance.
@moixcodez15856 жыл бұрын
Sir how to save script file in oracle:plz help me i really need this
@mohammednouh55275 жыл бұрын
you can use spool c:filename.txt after finishing your work than you will say spool off
@AZAKISMART9 жыл бұрын
how i can contact you ?
@OrSklAnlaytics9 жыл бұрын
facebook.com/orsklacademy
@ziadfawzi2 жыл бұрын
Thank you.
@karthiksrirambatla30747 жыл бұрын
thank u for giving the rough idea
@AllINONEAwez6 жыл бұрын
Thank u sir
@VIJAYSINGH617 жыл бұрын
nice experience
@cizzlen075 жыл бұрын
Thank you so much
@blessiousphiri3109 Жыл бұрын
Kindly share the text file
@sanjayjadhav8817 жыл бұрын
This is good for us
@premprakashnayak26363 жыл бұрын
More videos bro
@aamersaif8996 жыл бұрын
Make a video step by step without any errors , you are showing it easy by complicating the beginnings who is watching by making mistakes and not showing from straight point to point .. I expect you to give a straight clean demo ..
@rakeshkumarpaul58816 жыл бұрын
Iske bad kya karu
@rakeshkumarpaul58816 жыл бұрын
Sir may BSC IT Kar Raha hu
@menakabarathi81856 жыл бұрын
To learn Oracle DBA Enroll now www.trainingmarathahalli.com/oracle-dba-training-in-marathahalli/
@AZAKISMART9 жыл бұрын
cool , great demo
@YTFEUS6 жыл бұрын
Hey guys, I just created a custom test for the administration 062 exam by myself here www.udemy.com/course/1658424