To Check SQL> SELECT * FROM HR.EMPLOYEES AS OF TIMESTAMP TO_TIMESTAMP ('2016-12-19 21:35:00', 'YYYY-MM-DD HH24:MI:SS') To Save Data As Temp Table SQL> CREATE TABLE HR.EMPLOYEES_TEMP AS SELECT * FROM HR.EMPLOYEES AS OF TIMESTAMP TO_TIMESTAMP ('2016-12-19 21:35:00', 'YYYY-MM-DD HH24:MI:SS') -- WHERE EMPLOYEE_ID = 100
Command rm -f * Error bash: /bin/rm: Argument list too long error Solution Use following command line $ find . -maxdepth 1 -name "*.txt" -print0 | xargs -0 rm
Run gpedit.msc -> User Configuration -> Administrative Templates -> Startup Menu and Taskbar -> Edit policy setting to Enable"Remove and prevent access to the Shut Down, Restart, Sleep, and Hibernate commands"-> Done! :)
Run gpedit.msc -> Computer Configuration -> Administrative Templates -> System -> Power Management -> Sleep Settings -> Edit policy setting to Enable"Turn Off Hybrid Sleep (Plugged In) and (On Battery)" -> Edit policy setting to Disable"Allow Standby States (S1-S3) when sleeping (Plugged In) and (On Battery)" -> Done! :)
Open two connections like "HR" and "HRNEW" -> Database -> Compare -> Schemas -> Define Source and Target Schemas -> Select Object Types in "Object Types to Compare" -> Check and Set "Stop when # of differences reaches" option to more than "1000" like "10000" in "Misc Options" tab -> Click "Run" image -> Check script in "Sync Script" -> Lastly click "Move Script to Editor and Run Now" button -> That's all :)