Home
Search results “Oracle delete no undo”
Oracle Undo & Redo Explained
 
15:11
Comparison Of Oracle Undo & Redo Database Checkpoints Transaction Commits
Views: 5155 John Boyle
Oracle SQL Developer Tutorial For Beginners  43   Handling a Transaction   UNDO
 
03:08
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1170 Sam Dhanasekaran
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 20599 Abbasi Asif
4.ORACLE WORLD - How to Recover drop table from Recyclebin using Flashback in oracle database
 
07:57
Hello guys in this demo I'm just showing to you that we can easily recover the dropped table from recyclebin in oracle using flashback technology very fast without shutdown the database... By lalit saini
Views: 4803 Oracle World
Oracle tutorial : Recover deleted rows in Oracle PL SQL using flashback
 
10:59
Oracle tutorial : Recover deleted rows in Oracle using flashback oracle tutorial for beginners oracle recover deleted rows In this video, we have used as of timestamp concept of oracle. Example : select * from table as of timestamp(systimestamp-interval '1'minute ) Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 1538 Tech Query Pond
Add,Update,Delete and Clear records -Visual Basic ADODC and MS Access-Step by Step Tutorial
 
25:51
How to add,Update ,Delete and Clear records using Ms Access Database and Visual Basic 6.0 ADODC control -(Step by step full tutorial with explanation of each step)-An Advanced Visual Basic Database Application. This tutorial is focused on following points. * How to create a simple database with MS Access. *How to add ADODC Control on the Visual Basic Toolbox. *How to use the ADODC control and set the properties and establish database connection using Ms Access . *How to set the properties of each fields according to database application. *How to hide ADODC control. *How to add Record navigation buttons i.e First,Previous,Next,Last. *How to perform Database Operation i.e ADD Record,Delete Record,Update Record and Clear the records. * How to search records by Name or Roll No.https://youtu.be/1yNScTVAqZ4 In this tutorial,every step is explained with supportive text within the video.so everyone can follow the steps to build such applications quite easily. link:- http://selfcomputerlearning.blogspot.in/2015/09/how-to-addupdatedelete-and-clear.html New: Add,Delete Update Search Using VB6 dataGrid Adodc and Ms Access-Complete Tutorial:https://youtu.be/K8jq2H3aamk if you have any queries,suggestions or problems,please leave a comments. for more Visual Basic tutorials,please visit Youtube Channel:https://www.youtube.com/user/sandydehrian Computer Gyan Blog:http://selfcomputerlearning.blogspot.in/ Do share and Subscribe to my channel :-) _____________________________________________________________ Here is my updated List of Tutorials. _____________________________________________________________ Create and store data in Microsoft Excel Sheet using visual basic https://youtu.be/qcUqaxFD2Dw Search records in listview control https://youtu.be/IvdwG_iIcgQ Create and Display Popup menu in Visual Studio https://youtu.be/Ue8s_EJggaw Search Records between Two dates using DataGrid https://youtu.be/hngeOF1hqcs How to Connect Listview with Database and Load data into Listview https://youtu.be/w2MXRpaXbNU Add Delete Search and Sort Listitems in Listview control https://youtu.be/5JNfrTYm7sI How to Reset Forgotten Password by User Verification in Visual Basic 6.0 https://youtu.be/mMuM99gPyoo How to Connect Datagrid control with Access database without VB6 ADODC https://youtu.be/QNqDcESIzCg How to Make installer for Visual Basic Database https://youtu.be/zd9MkOf1CI0 ImageCombo and ImageList-Display Image with Combo items in Combobox https://youtu.be/pctajfImKd4 Create Save Update Delete and Search Student Profile Using Visual Basic/Ms Access-Step by Step https://youtu.be/bL03PrGt8WY Advance Login System (Splash Screen with Progress Bar,User Registration,Login system,Welcome ) https://youtu.be/s-BU03egpWA Add Delete Update Search Records https://youtu.be/K8jq2H3aamk How to Print Data Report in VB6 https://youtu.be/vjQDtKMUCKk How to Use Data Manager in VB6 https://youtu.be/27IrMsEXlBc Create Tool Bar,Status Bar and Menu Bar https://youtu.be/3l6bciTAC7Q Common dialog control- Font and Color Dialog https://youtu.be/4DBy2ghmu7U Search Records in Database (By Name or ID) https://youtu.be/1yNScTVAqZ4 Login Form using Visual Basic 6.0 https://youtu.be/XXKjfta5kkg Add Delete Update and Clear records https://youtu.be/tYS7uncH8Ds Simple Visual Basic Database Application https://youtu.be/PldGe0-FnI8 Design Font Dialog Box in VB 6 https://youtu.be/C0CMtoXIFY4 Road Traffic lights Animated system https://youtu.be/74Zvl0bXeAY ListBox Control( Advanced) https://youtu.be/Q6NYtmH7z9Q ListBox Control -Add,Delete and Clear items https://youtu.be/YlmKSyk0l2k Custom Progress Bar with percentage completed on Splash Screen https://youtu.be/jGSxrhYZAbE Frame Control,Check Box and Option Buttons https://youtu.be/9x9dmM0V4CU Picture Viewer+Browser in Visual Basic https://youtu.be/POd1Kmpvc0M Splash Screen with Progress Bar- https://youtu.be/95hw5z7lq4A Create Menus,Drop Down Menus ,Nested menus in Menu Bar https://youtu.be/fNtJaQgnuEs #visualbasic #visualbasictutorial #vb6
Views: 221371 Sandeep Kaundal
The Delete Query in Microsoft Access
 
04:09
It is really important that if you are using a delete query you have made a copy or backed up your data. An Access delete query will delete data based on criteria you set. You cannot undo it. It is good, however, for removing old data that is no longer required, although there is usually a backup of it somewhere. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.
Views: 5323 jargonfreehelp
How to restore tablespace in case of NO backup?
 
04:38
Oracle RMAN restore tablespace without backup of this tablespace.
Views: 5075 Mahir M. Quluzade
Oracle Database11g tutorials 9 || What is archive log mode and how to enable archive log mode
 
07:23
weblink: www.rebellionrider.com What is archive log mode What is noarchive log mode How to enable archivelog mode in oracle 11g How to enable archivelog mode in oracle 10g This SQL tutorial and Oracle database 11g tutorial for beginners will show what are ARCHIVELOG mode and noarchive log mode and how to enable archivelog mode in oracle database 11g or 10g Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 93807 Manish Sharma
UNDO In oracle
 
17:42
Views: 245 Sainora Annanagar
How to Delete a Virtual Machine from VirtualBox
 
02:16
VirtualBox is a VM utility which is free for personal use and made by Oracle. You can download it from http://www.virtualbox.org If you have any questions or this was helpful to you, please feel free to like, subscribe and comment. Also feel free to share this video. If you'd like more information about Lions Park Computers visit http://www.lions.com Follow us on twitter @lionsdotcom http://www.twitter.com/lionsdotcom
2 WAYS TO UNDO|Accidentally|diskpart|clean command|2018
 
03:39
There will be two ways to undo the clean affects in windows without any software. 1: Using the GUI mode. 2:Interactive mode using the cmd NOTE: Don't panic. Your data is safe.
Views: 742 EBS STUDIO ORACLE
How to configure Microsoft Excel to connect to an Oracle Database
 
11:52
Mike van der Velden, Product Manager at Simba Technologies, provides a step-by-step guide for configuring Microsoft Excel to connect with Oracle Database OLAP Option. Mike walks through the one-time set-up of Oracle's Transparent Networking Substrate (TNS), followed by the Data Source Name (DSN) and Office Data Connection (.odc). Once configured, Microsoft Excel connects easily to Oracle Database OLAP Option for ad hoc data query, data analysis and BI reporting.
Flashback Query Oracle Database||  Recovery Deleted Row
 
05:41
MD.Rahim Uddin Shohag Founder - Oracle Bangla https://www.oraclebangla.com/ fb :: https://www.facebook.com/oracle.shohag email: [email protected] Recovery Deleted Row in Oracle using Flashback Query ============================================ i'm show you how to recovery Deleted row in oracle database following Step :: ================== /* FLASHBACK QUERY NO NEED DBA */ CREATE TABLE DEMO_CUSTOMER ( CUST_ID NUMBER CONSTRAINT DEMO_CUSPRIMARY PRIMARY KEY, CUST_NAME VARCHAR2(100 BYTE), CUST_ADDRESS VARCHAR2(200 BYTE), CUST_PHONE VARCHAR2(15 BYTE), CUST_WEBSITE VARCHAR2(100 BYTE), CREATE_DATE DATE DEFAULT SYSDATE ); SELECT SYSDATE FROM DUAL; --------------- INSERT RECORD --------- INSERT INTO DEMO_CUSTOMER VALUES(100,'SHOHAG','DHAKA','121212','www.oraclebangla.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(101,'RAHIM','Feni','121212','www.google.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(103,'Rubel','karwan bazar','121343','www.obn.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(104,'Karim','DHAKA','1212432','www.OCA.com',SYSDATE); COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER SELECT SYSDATE FROM DUAL; ---- AFTER FEW MINUTE -------- DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 100; DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 101; DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 103; COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER -----Way No 1 AFTER 1 MINIUTE ---------- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '1' MINUTE) ; SELECT COUNT(*) FROM DEMO_CUSTOMER; SELECT * FROM DEMO_CUSTOMER; /* IF SPECIFIC TIME FINDE DATA HISTORY */ ---- why no 2 SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM'); ---============== recovery data ============= SELECT * FROM DEMO_CUSTOMER; --------------------------- SPECIFIC DATA RECOVERY -------------------------- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE); INSERT INTO DEMO_CUSTOMER (SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE) WHERE CUST_ID = 101); COMMIT; SELECT * FROM DEMO_CUSTOMER; --- RECOVERY SINGEL RECORD FLASHBACK 2ND WAY SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM'); INSERT INTO DEMO_CUSTOMER ( SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 100 ); COMMIT; SELECT * FROM DEMO_CUSTOMER; ---IF YOU RECOVERY DATA ALL DELETE RECORD JUST SIMPLE TECHNIC ----- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') MINUS SELECT * FROM DEMO_CUSTOMER INSERT INTO DEMO_CUSTOMER( SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') MINUS SELECT * FROM DEMO_CUSTOMER); COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER; ------ IF YOU UPDATE RECORD FLASHBACK QUERY CHECK --- UPDATE DEMO_CUSTOMER SET CUST_NAME = 'Oracle' WHERE cust_id = 104; commit; SELECT * FROM DEMO_CUSTOMER; SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104 SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:30:00 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104
Views: 601 Oracle Bangla
Recovery of Redo log file using Log Sequence number by RMAN
 
13:50
Hi friends today I am showing you to Recovery of Redo log file using Log Sequence number by RMAN (Recovery Manager).This is a simple method and easy way to recovery redo members. #Recovery #Redologfile #LogSequence #RMANrecovery Oracle database Unbeatable,Unbreakable Platform..
Views: 5791 Oracle World
Oracle Instance Recovery Tutorial - Module 2 - Tutorial Agenda
 
02:40
Q. Is It Possible to Corrupt an Oracle Database? A. No, You Cannot - Not If It Is Properly Administered. Why? Because the mechanism of redo and undo is the best yet developed on this planet. In this free tutorial, Oracle Certified Master John Watson will explain redo, undo, commit, instance recovery and demonstrate why your database can never lose one row of committed data. Learn what actually happens, in memory and on disc, when DML is issued. John will demonstrate that instance recovery is automatic, and unstoppable. This is critical and essential knowledge for all Oracle Administrators and DBA students. Presenter: John Watson, Oracle Certified Master See all free Oracle Database tutorials at www.SkillBuilders.com/OracleTutorials
Views: 613 SkillBuilders
Oracle Core,  Лекция 4
 
43:44
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1hqsC6hEGybAbEEPko56razF7eLBJQEZ3L-ECWtp7rbM/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции:https://docs.google.com/document/d/1UFayi0YIXxLrRuj4-JZj-jooyvpoa4rKLOryBloTtag/edit?usp=sharing 1. Create table: permanent tables, temporary tables (on commit delete/preserve rows) 2. Physical properties таблицы: tablespace, logging, pctfree, pctused, initrans 3. Pctfree и pctused 4. Initrans и maxtrans 5.Storage clause: initial, next, minextents, maxextents, pctincrease, freelists, freelist groups, optimal, buffer_pool (keep,recycle), flash_cache (keep, none), encrypt 6. Table properties: column_properties, cache, result_cache, enable_disable_clause, flashback_archive_clause 7. Alter table: column_clause, constraint_clause, alter_table_partitioning, move_table_clause, enable_disable_clause, rename to, shrink space 8. High water mark. Low high water mark 9. Create index: table index clause, index_expr, index_properties, unusable 10. Reverse indexes 11. Function based indexes 12. Alter index: сжатие (shrink space), параллелизм, физические атрибуты (pctfree, pctused, initrans), logging/nologging, rebuild, enable/disable, unusable, visible/invisible, rename to 13. Индекс по внешнему ключу 14. Причины неиспользования индексов 15. Оператор truncate 16. Неявный commit при выполнении ddl 17. Словари данных Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Oracle DBATutorial ||onlinetraining|| Temporary TableSpaces by Shiva
 
13:13
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
How to Uninstall a Kodi Build from your Fire Stick or Fire TV
 
06:38
In this video tutorial I walk you through a very easy way to uninstall a Kodi Build from your Fire Stick or Fire TV. Also, I show you how to add the Ares Wizard in order to install and try out new builds on your device. ✅ Ares Wizard Link ► http://kdil.co/repo/ ✅ My YouTube Gear ► https://www.amazon.com/shop/richmanknowstech ✅ Richman's VPN Recommendation is IPVanish https://goo.gl/E1iTzj. Having a good VPN is not an option anymore and these guys have your privacy as their priority! 🔴 If you Like this video, please hit the Like button! 🔴 Subscribe for more free tips ► https://goo.gl/DdAWXw 🔴 Share this video with a YouTuber friend ▶︎ https://youtu.be/oME6fnIXYsI ======================================================== ✅ The information contained in this video is for informational purposes only** 🔴 Why NOW is the TIME to get a VPN: https://youtu.be/MDNJVJCGf2g 🔴 The CURE for KODI FRUSTRATION: ▶︎ https://youtu.be/HnWKZTDRidE 🔴 Why Pay for CABLE TV? Best build of 2018! https://youtu.be/-sN1vWhDJTk 🔴 This IPTV For Kodi Will Blow You Away!!! https://youtu.be/dGBApwo9-cY 🔴 My Build Recommendations for KODI: https://www.youtube.com/watch?v=q7N43t77-O0&list=PLO4lOJyItBPYkt8VtRNcdaxIEkq0jR68D 🔴 Time to Leave Kodi Behind? I'm Loving These APK's! ► https://youtu.be/I_Ne7Q22p9U 🔴 Time to Leave Kodi Behind? Pt. 2 - More Android Apps to Love! ► https://youtu.be/5anQsJV15PI 🔴 Time To Leave Kodi Behind? Pt.3 - Is This The End Of Kodi? https://youtu.be/GY1b9s_7fyA 🔴 Kodi 17 - 6 Essential Must-Have Add-ons for a No Frills Kodi Build ► https://youtu.be/UX08xT_Mbtk 🔴 Live FREE Sports in HD without Kodi? No way...Way!!! ► https://youtu.be/ZbfzxdzXJAo 🔴 Complete Set Up Guide for a Fire Stick or Fire TV ► https://youtu.be/q1JzXVf-5MI 🔴 Speed up Kodi: Delete Old Addons and Repos ► https://youtu.be/4aSAwt8HMe8 🔴 Kodi: The REAL Solution for HD links - REAL DEBRID ► https://youtu.be/i_3ZtodqSp8 🔴 How to Speed up Your Fire Stick or Fire TV 100% and reinstall a Fresh Copy of Kodi 17 ► https://youtu.be/frORpRk9wpk 🔴 The Most Powerful Feature in Kodi That No One Uses - The Favorites Folder ► https://youtu.be/ijILAR3s2NA 🔴 How to Remove or Delete Items from the Favorites Folder in Kodi ► https://youtu.be/fKP6K7uMM_E
Views: 76601 Richman Knows Tech
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2426 SkillBuilders
Oracle tutorial : Global Temporary Table In Oracle PL SQL
 
08:49
Oracle tutorial : Global Temporary Table In Oracle PL SQL create temp table sql This video will explain to you how to create Temporary Tables in Oracle Oracle tutorial : Global Temporary Table In Oracle 1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session. 2)The definition is visible to all sessions. 3)After commit or disconnection, the data is lost but the definition of the table remains. 4)Indexes created on a temporary. 5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions. 6)Foreign key constraints are not applicable in case of Temporary tables 7)Temporary tables cannot contain column of persistent collection type Syntax : CREATE GLOBAL TEMPORARY TABLE table_name ( column_name column_data_type … … ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TABLE Emp ( id number(5) NOT NULL, name varchar2(50) NOT NULL, city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’); INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’); INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’); SELECT COUNT(*) FROM emp; Result = 3 rows COMMIT; SELECT COUNT(*) FROM emp; Result = 0 rows For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 3741 Tech Query Pond
How to table create in oracle
 
03:20
Design Tables Before Creating Them. Consider Your Options for the Type of Table to Create. Specify the Location of Each Table. Consider Parallelizing Table Creation. Consider Using NOLOGGING When Creating Tables. Consider Using Table Compression. Consider Encrypting Columns That Contain Sensitive Data. https://youtu.be/0lwvKpmztJY
Views: 59 Computer Expert
Temporary file folder in Windows 7 (disk cleanup/ delete temp files)
 
08:42
Check my blog here: http://www.techtutorialvideo.com/ If you are running out of disk space, your computer is running slow or responding late; first thing you may want to check is disk space used by different temporary folders. Sometime temporary folders grows up too much and takes multiple GB of size. So it is better to clean up temporary folders periodically. You can do this manually by your own or using different utilities. This tutorial will help you to understand what these temporary file folders are and how to clean them manually. Different topics that are covered in this tutorial are: 1. What is temporary file folder? 2. Why to delete Temporary files? 3. Is it safe to delete Temporary Files? 4. Different Temporary folders in Windows 7 5. Location of Windows Temporary folder 6. Location of Application Data Temporary folder 7. Location of Internet Temporary folder 8. How to delete temporary files 9. Other Options - utilities to delete temporary files like Disk Cleanup, CCleaner etc Check this video tutorial for more details of temporary file folder in Windows 7. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 382373 TechTutorialVideo
5 Minutes with Primavera P6 Professional - Deprogress a Schedule
 
03:15
Reuse an existing project to create a new project by removing all actuals, resetting the remaining durations to equal the original durations and making all percent completes zero. The video is part of the 5 Minutes with Primavera P6 Professional series, developed by the Oracle Primavera Curriculum Team to demonstrate, explain, and enhance your experience with the application. Click the CC icon to display subtitles; click the Settings icon to change subtitle language. Useful links: Send feedback, comments, questions: [email protected] View more Oracle Learning Library videos: https://www.youtube.com/user/OracleLearning/playlists View additional Oracle Primavera training content: http://www.oracle.com/oll/primavera ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Userenv function in oracle
 
04:02
This session tells you what is userenv function in oracle and how to use it.
Views: 174 kiran sethy
How to remove syskey encryption password
 
05:56
How to remove syskey encryption password In this video I will show you how to reset the syskey. How does this happen? there is a scam called. This is Microsoft Support telephone scam, they will ask you to let them remotely connect to your computer and then try and scam you out of money, then if you start to get cold feet and don't want to pay there fee, they run syskey on your system and remove system restore points so you can't roll back the system. http://www.briteccomputers.co.uk
Views: 120660 Britec09
MySQL - Restore lost data in MySQL using InnoDB engine without file ibdata1
 
06:54
Below are the tutorials: 1. Enable innodb_file_per_table=1 inside my.ini / my.conf 2. Install MySql Utilities Console 3. If you can't install software above, make sure you have Visual C++ Installed in your computer. If you don't have, just download it by searching at google. 4. Open Command Prompt 5. Point to your old database directory. Ex: cd c:\xampp\mysql\data\xxx 6. Type command: see video 7. Command above will create txt file contains the script to create the old table. 8. Just open your txt file in the same directory. --------------------------------------------------------------- NEXT STEP --------------------------------------------------------------- 1. Open your mysql command inside your mysql bin folder. Ex: mysql -u root -p 2. Create new database. Ex: create database xxx; 3. Choose that database. Ex: use xxx; 4. Copy and paste script to create the old table. 5. Type: ALTER TABLE `name_of_table` DISCARD TABLESPACE; 6. Go to your old database directory, then copy your name_of_table.ibd file manually into new database folder. 7. After that you can just type: ALTER TABLE `name_of_table` IMPORT TABLESPACE; 8. Done 9. You can test with query: Select * from name_of_table limit 0,10; Thank you, www.000software.com Subscribe us
Views: 20639 Next Wallpress Inc.
Can you flashback table into SYSTEM tablespace?
 
10:02
Flashback feature in Oracle database is well known to roll back the table to a specific timestamp (depends on undo retention) or to restore dropped table and many more. We must have used this flashback feature so far on application schema objects and found working without any issues. As an Oracle DBA did you configure any tools (might be monitoring, RMAN catalog or any) with objects created in SYSTEM tablespace? If so, you probably would see some problems later when you need to use Flashback on these objects though they are not Oracle supplied objects. Let us go through a case study which will clearly explain you the functionality of Flashback table. Did you like the video? Subscribe now, Like it and share it. Looking for Oracle DBA training or services? redirect to www.orskl.com WhatsApp to +919951696808
Views: 1553 OrSkl Academy
10. Undo last delete | Deshacer último borrado
 
01:04
Did you accidentally erased a product? Don't worry! Recover it using "undo last delete" ------------------------------------------------------------------------------------------------------------------------ ¿Borraste un producto por accidente? ¡No te preocupes! Recupéralo usando "deshacer último borrado"
Views: 53 megaphonik1
Oracle Backup & Recovery - Parte 02 - Quem Sabe Faz Ao Vivo
 
05:34
O cenário sorteado desta vez a perda de meu único DATAFILE de UNDO. Veja como se recuperar desta situação.
Views: 1225 Nerv
Oracle Tutorial - How to recover a corrupted NON SYSTEM datafile (database in ARCHIVELOG mode)
 
06:19
The following scenario describes what happens when a non system datafile is lost. Before proceeding be sure to have a complete backup of your database and be sure your database is in ARCHIVELOG mode. by Lalit saini
Views: 2106 Oracle World
php tutorial in hindi - Difference between DROP, DELETE and TRUNCAT table in mysql
 
21:38
Difference between DROP, DELETE AND TRUNCAT in mysql DELETE ------ DML (Data manipulation language) 1)The DELETE command is used to remove rows from a table. 2)After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it. 3) Delete operation perform for all rows or single row, But it does not free the space containing the table. TRUNCAT --DDL (Data definition language) 1)TRUNCATE removes all rows from a table. 2) can't ROLLBACK operation 3) Free the space containing the table DROP --- DDL (Data definition language) 1)The DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed. 2)DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. . 3)Once a table is dropped we cannot get it back, How to get a 3rd highest salary from mysql database https://youtu.be/wbAO0SrjZxE Mysql LIKE Clause in php https://youtu.be/olhBzYcLF8A Mysql INSERT INTO SELECT query to create database copy https://youtu.be/HQCWp9Ai0Ps mysql INNER JOIN query in hindi step by step https://youtu.be/QzJL5yb0sWM Mysqli Join query to get data from multiple table in hindi step by step https://youtu.be/3eWqSJTVDqk Mysql select query using order by in hindi https://youtu.be/vKkEC6dcRJU Mysqli select query using limit and offset in hindi https://youtu.be/OB3HOtnJczo MySQL query to select record using left and right join in php https://youtu.be/sl0hf1SVHUg Mini Project Part6: How to login using html login form https://youtu.be/iZ8ZEpm0q3Y Mini Project Part 7: User Dashboard redirection after login https://youtu.be/osH_Lx4Y5c4
Views: 147 Tutorials Website
Oracle 10g Redo Log Files
 
36:36
Session About Oracle 10g Redo Log Files and Archived files. How to manage and maintain Redo logs groups and files (Create, Add, Drop, Rename, Move and Switch)
Views: 3091 ITLecture
Read-Only Tables in Oracle
 
02:08
Here's a quick video showing how to create Read-Only tables in Oracle. For more information see: https://oracle-base.com/articles/11g/read-only-tables-11gr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by David Peake Blog: http://dpeake.blogspot.com/ Twitter: https://twitter.com/orcl_dpeake Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 824 ORACLE-BASE.com
Minecraft No Undo Function: Advertisement 1
 
00:31
If you liked the video, please leave a like or subscribe if you want to see more. Please email me at [email protected] if you have any comments, questions, or challenge suggestions. Thanks to SkinZer0 on minecraftskins for the "Adventure Steve" skin.
Views: 2245 timulation29
onlinetraining|| RMAN Crosscheck|Obsoleted backup|Expired backup Part - 1 by Shiva
 
32:42
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 6511 BhagyaRaj Katta
How to remove file from past git commit
 
11:29
Accidentally committed a file in git? No problem. This video shows an example of simple git history editing with interactive rebase to remove a file from a previous git commit. To remove the file from the .git directory, try the following (dangerous, understand you're permanently deleting git's reflog and stored objects): rm .git/logs git gc --aggressive --prune=now Advanced file removal with filter-branch: http://stackoverflow.com/a/8741530/2425921 In-depth git maintenance and data recovery: http://git-scm.com/book/ch9-7.html
Views: 8698 FoundationSeries
Oracle DBA Tutorial || Oracle DBA Introduction by shiva
 
16:40
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Interview Questions and Answers of SSIS Part I || MSBI Interview questions and answers
 
04:59
Q1. SSIS - What Is ETL (Extract, Transform, Load) ? ETL Stands for Extract Transform and Load. Every day working at different organization/s we come across different scenarios where we have to extract data from different sources such as Excel, Text Files, XML, Database systems etc. and then clean that data or transform that data according to our required format and save it to Destinations such as Database system or in different file types. To perform ETL task , there are different tools available in market. Some of them are listed below • SQL Server Integration Services • IBM Infosphere Information Server • PowerCenter Informatica • Talend Studio for Data Integration • Oracle Data Integrator (ODI) • Clover ETL • Centerprise • Pentaho Data Integration SQL Server Integration Services is an ETL tool that can be used to extract data from different types of sources by using Sources (OLE DB Source, File File Source, Excel Source etc.) that are built in the tool. To Transform data, SSIS Provide different type of transformations such as Aggregate, Lookup, Data Conversion,Derived Column etc. so the source data can be transformed in any required format. For Loading, It provides different types of Destinations such as OLE DB Destination, ODBC Destination, ADO Net Destination , Flat File, Raw File ,Excel File etc. where data can be loaded once transformed in required format. ***************************************************************************** Q2. SSIS - New Features Of SQL Server Integration Services (SSIS) 2012 Here are some improvements in SQL Server Integration Services 2012 from SQL Server Integration Services 2008. 1-Undo Change in SSIS Package: Undo was not available in SSIS Package. Once you have deleted any Task or Transformation, there was no way to undo the change. SSIS 2012 has added Undo facility. You can use Ctrl+Z or Click on the Button as shown in below picture 2-Group Tasks and Transformations: The Tasks and Transformations can be grouped together. You will not be using this Group to connect to other Containers or Tasks. This grouping is just for arranging the Tasks or Transformations but you will not be able to set the properties like Containers. 3-Change the Scope of Variable/s: In earlier versions of SSIS, to change the scope of variable from one Task to another Task or from Task level to Package level, we had to delete the variable and then create with new scope. In SSIS 2012, we can change the scope of variable without deleting and recreating it as shown below. 4-Decimal Data Type Variable: New Data Type is added for Variables as shown below. 5-Expression Character Limit We often have to write expression in Execute SQL Task for source query. The character limit for SQL Server 2008R2 and old version are 4000. This limit is removed in SQL Server 2012 Integration Services. 6-Zoom In and Zoom Out For Zoom in and Zoom out a scale is added at the right bottom corner of Package design surface. Also the Button for navigation button is removed that was available in right bottom corner of Package design surface in SSIS 2008R2 and old versions. 7-Parameters With new Project Deployment Model, Parameters are added to provide configuration values. The Parameter can be on Project level or Package level. We can change the value of these parameters without making any change in Package or Project itself while Package is going to execute in different environments such as DEV, QA, UAT and Prod. Parameters can be accessed by Right Clicking on Tasks, Containers etc. You will also see the Parameters while writing expressions and you can use them if required. When you create a new Parameter, you can Add to Configuration as well from SQL Server Data Tools. 8-New Added Functions for Expressions Below are the newly added functions which can be used while we write expressions. • LEFT • TOKEN • TOKENCOUNT • REPLACENULL 9- Row Count New GUI Row Count GUI is simplified, The purpose of Row Count was to save the Count in user variable but Row Count Transformation in SSIS 2008R2 and earlier versions were also displaying all system variables. In SSIS 2012, it only displays the Variables which are Integer Type and does not provide the list of all variables that helps to configure this Transformation quickly. 10. In SSIS 2012 , Only Grid is available and other types are removed. 11-ODBC Source and ODBC Destination ODBC Source and ODBC Destination is added in SQL Server Integration Services 2012. 12-CDC Control Task The CDC Control Task is added to SSIS 2012 to perform initial load for CDC enable table. 13-CDC Source CDC Source is added to read the change data from CDC tables. 14.CDC Splitter Transformation is added in SSIS 2012 to split the data into multiple flows for Insert, Update and Delete Operation.  What's New (Integration Services) SQL Server 2014 Integration Services is unchanged from the previous release. https://msdn.microsoft.com/en-us/library/bb522534(v=sql.120).aspx
Views: 130 Softtech forum
Enable/Disable Archive Log Mode in Oracle 11g Database
 
13:57
Learn how to change the log mode of database from NoArchive Log mode to Archive Log Mode and ViceVersa.
Views: 48 linux recipe
Oracle 10g - Tablespaces - LAB
 
26:03
Oracle 10g, Physical and logical structure cont. LAB.
Views: 1416 ITLecture
03 Dead Lock in oracle database
 
11:37
DML Locks DML locks or data locks guarantee the integrity of data being accessed concurrently by multiple users. DML locks help to prevent damage caused by interference from simultaneous conflicting DML or DDL operations. By default, DML statements acquire both table-level locks and row-level locks. The reference for each type of lock or lock mode is the abbreviation used in the Locks Monitor from Oracle Enterprise Manager (OEM). For example, OEM might display TM for any table lock within Oracle rather than show an indicator for the mode of table lock (RS or SRX). Row Locks (TX) Row-level locks serve a primary function to prevent multiple transactions from modifying the same row. Whenever a transaction needs to modify a row, a row lock is acquired by Oracle. There is no hard limit on the exact number of row locks held by a statement or transaction. Also, unlike other database platforms, Oracle will never escalate a lock from the row level to a coarser granular level. This row locking ability provides the DBA with the finest granular level of locking possible and, as such, provides the best possible data concurrency and performance for transactions. The mixing of multiple concurrency levels of control and row level locking means that users face contention for data only whenever the same rows are accessed at the same time. Furthermore, readers of data will never have to wait for writers of the same data rows. Writers of data are not required to wait for readers of these same data rows except in the case of when a SELECT... FOR UPDATE is used. Writers will only wait on other writers if they try to update the same rows at the same point in time. In a few special cases, readers of data may need to wait for writers of the same data. For example, concerning certain unique issues with pending transactions in distributed database environments with Oracle. Transactions will acquire exclusive row locks for individual rows that are using modified INSERT, UPDATE, and DELETE statements and also for the SELECT with the FOR UPDATE clause. Modified rows are always locked in exclusive mode with Oracle so that other transactions do not modify the row until the transaction which holds the lock issues a commit or is rolled back. In the event that the Oracle database transaction does fail to complete successfully due to an instance failure, then Oracle database block level recovery will make a row available before the entire transaction is recovered. The Oracle database provides the mechanism by which row locks acquire automatically for the DML statements mentioned above. Whenever a transaction obtains row locks for a row, it also acquires a table lock for the corresponding table. Table locks prevent conflicts with DDL operations that would cause an override of data changes in the current transaction. Table Locks (TM) What are table locks in Oracle? Table locks perform concurrency control for simultaneous DDL operations so that a table is not dropped in the middle of a DML operation, for example. When Oracle issues a DDL or DML statement on a table, a table lock is then acquired. As a rule, table locks do not affect concurrency of DML operations. Locks can be acquired at both the table and sub-partition level with partitioned tables in Oracle. A transaction acquires a table lock when a table is modified in the following DML statements: INSERT, UPDATE, DELETE, SELECT with the FOR UPDATE clause, and LOCK TABLE. These DML operations require table locks for two purposes: to reserve DML access to the table on behalf of a transaction and to prevent DDL operations that would conflict with the transaction. Any table lock prevents the acquisition of an exclusive DDL lock on the same table, and thereby prevents DDL operations that require such locks. For example, a table cannot be altered or dropped if an uncommitted transaction holds a table lock for it. A table lock can be held in any of several modes: row share (RS), row exclusive (RX), share (S), share row exclusive (SRX), and exclusive (X). The restrictiveness of a table lock's mode determines the modes in which other table locks on the same table can be obtained and held.
Views: 225 OnLinE ReSoUrCe
How to restore your default file format and icons (Windows7)
 
05:35
Have you ever messed up your Default File Format And Icons by using open with option? Now you don't have to worry anymore as I have come up with new idea and proper explanation. In this video you will learn how to bring back to your default file format and icons. Please make sure that you follow the exact steps. If you are not clear with this tutorial then feel free to leave me a comment or email me and I will try to help you ASAP. To see step by step instruction clearly please click the lick below. http://goo.gl/BhTj3 or you can email me at: [email protected]
Views: 648182 The Beginners
How to hide all unused cells in all columns and all rows in Excel spreadsheets
 
04:04
A demonstration on how to hide unused cells in all columns and rows in Excel 2013, 2010 and 2007. Also visit our blog at my-excel-tutorials.blogspot.com BEST VIEWED IN FULL SCREEN, HIGH RESOLUTION
Views: 151169 United Computers
Primavera P6: Difference between Delete and Dissolve
 
05:06
Users often confuse between Delete and Dissolve commands in Primavera P6. Following video provides more information on delete and dissolve commands through sample projects. Enjoy watching those. 24x7Coach offers training for PMP, MS Project, Primavera P6, Agile, Scrum, and JIRA. Conducts face-face classroom training, virtual/online training (instructor led) for individuals, groups and for corporate companies. Also offers customized training for corporate companies as per client requirement. Gopi Aitham is project management Enthusiast, Advisor, Blogger & Coach with more than 2 decades of diversified experience. Founded 24x7Coach.com to help professionals and organizations in imparting knowledge, exercising best practices in project management arena. Looking for a training? To know more about services, visit us: www.24x7coach.com Contact us: [email protected]
Views: 3952 24x7Coach.com
How to Delete Files That Cannot Be Deleted - Windows 10,8,7,XP (Compress to RAR file)
 
02:47
How to Delete Files That Cannot Be Deleted Methods:Windows 10, 8,7,XP. Download and install winrar it is completely free Watch my video. Winrar : http://www.rarlab.com/download.htm .......................................................................................... Watch my other video: (1)How to make bootable pendrive using windows USB/DVD tool https://youtu.be/YC1w53BgGSc (2) How to disable windows 10 update - 100% working https://youtu.be/x-SYkK4Cc0s ..................................................................................................... Description : If you're trying to delete a file and your computer isn't letting you, it's most likely because another program is currently trying to use the file. This can occur even if you don't see any programs running. Deleting these files is usually a matter of forcing the program that's using the file to close. Be careful when doing this; deleting the wrong file can have nasty effects on your system. ............................. How to delete or rename a file in use | How to delete a corrupt file or a locked file in Windows ............................................. Every experienced PC user is familiar with error messages along the lines of "This file is still in use". Unfortunately, while Windows is quite keen on educating users on their lack of access, it doesn't always tell which program is to blame. Here's how to successfully deal with locked files, and rename or delete them. ......................................... FAQ How to delete or rename a file in use in Windows, How to Delete Files That Cannot Be Deleted, How To Delete A Folder That Won't Delete, Cannot delete file or folder, Item Not Found error, How to Delete Undeletable File, Deleting folders which cannot be deleted, how to delete folder using cmd, how to delete folder access denied, How to Delete Files That Cannot Be Deleted, could not find this item, this is no longer located in C, location and try again, ALL SOLVED. ........................................................................................................ Subscribe AAK It's free : https://bit.ly/2xYvQYp Subscribe AAK VLOGS It's free too: https://bit.ly/2oNHQoe Like My Official Facebook Page The AAK https://bit.ly/2H56xmN Like My Official Facebook Page AAK VLOGS : https://www.facebook.com/AakVlogs Follow me On Instagram : https://www.instagram.com/aak_vlogs/ Follow me On Twitter : https://twitter.com/Aak_Vlogs ShopAAK https://www.facebook.com/ClickShopAAK/ Join AAK Global Group https://www.facebook.com/groups/AAKVLOGS THANKS FOR WATCHING...........!
Views: 176990 Aak Vlogs
Part 2- Undo Tips in Primavera P6
 
32:59
A video demonstrating Undo command in Primavera P6 and the impact of the other commands on it. What are the windows which clearing Undo history? What mistakes and disasters might happen if you delete something? What Impact of you user security profile on the availability of delete, remove and undo? Is Undo active in all windows?
Views: 81 ZAlbasir EPPM
Recuperar Dados
 
12:09
Esse vídeo mostra como recuperar dados deletado mesmo após o commit; --CRIANDO A TABELA DE EXEMPLO CREATE TABLE Produto( ID_PROD integer constraint Prod_PK primary key, Descricao varchar2(80), Vl_Custo number(5,2), Vl_Venda number(5,2)); --POPULANDO A TABELA insert into produto values(1,'Teclado Sem fio',1.0,3.0); insert into produto values(2,'Mouse Sem fio',1.0,2.0); insert into produto values(3,'Teclado Sem fio',5.0,15); insert into produto values(4,'Monitor de 20"',1.0,3.0); insert into produto values(5,'Cd',1.0,3.0); insert into produto values(6,'DVD R',1.0,3.0); insert into produto values(7,'PenDrive',1.0,6.0); insert into produto values(10,'Teclado Sem fio',1.0,3.0); commit; --VERIFICANDO O FLASHBACK select flashback_on from v$database; --CONSULTANDO A TABELA select * from produto; --REMOVENDO ALGUMAS LINHAS DA TABELA DELETE FROM produto WHERE ID_PROD in(4,7); rollback commit; --CONSULTNADO A LINHA DELETADA NO UNDO select * from produto as of timestamp (systimestamp - interval '8' minute); --RECUPERANDO A LINHA DELETADA insert into produto (select * from produto as of timestamp (systimestamp - interval '8' minute) WHERE ID_PROD in(4,7)); commit;
Views: 164 Target Database

Drafting cover letter samples
A sample annotated bibliography in mla format
Cover letter job references sheet
Quality writing service
Writing service testimonials