Thursday, 29 December 2016

How to merge text files in cmd?

›
Run this command in current path CMD>  for %f in (*.txt) do type "%f" >> merged.txt Ref: How to run cmd from curr...
Monday, 19 December 2016

How to rollback committed data from flashback?

›
To Check SQL> SELECT *   FROM HR.EMPLOYEES        AS OF TIMESTAMP TO_TIMESTAMP ('2016-12-19 21:35:00', 'YYYY-MM-DD HH24:...

How to see file extensions in current directory?

›
$ find . -type f | perl -ne 'print $1 if m/\.([^.\/]+)$/' | sort -u

bash: /bin/rm: Argument list too long error Solution

›
Command rm -f * Error  bash: /bin/rm: Argument list too long error Solution Use following command line $ find . -maxdepth 1 -name ...
Saturday, 17 December 2016

How to remove shutdown, restart, sleep and hibernate options from start menu?

›
Run  gpedit.msc  -> User Configuration -> Administrative Templates -> Startup Menu and Taskbar -> Edit policy setting to Enable...

How to disable sleep option?

›
Run gpedit.msc -> Computer Configuration -> Administrative Templates -> System -> Power Management -> Sleep Settings -> ...
Tuesday, 13 December 2016

How to compare schemas in Toad?

›
Open two connections like " HR" and "HRNEW" -> Database -> Compare -> Schemas -> Define Source and Target ...
Wednesday, 30 November 2016

How to export/import schema/table with Oracle Data Pump?

›
Define new user: SQL> CREATE USER NEWHR   IDENTIFIED BY newhr   DEFAULT TABLESPACE USERS   TEMPORARY TABLESPACE TEMP   PROFILE DEFA...

What are database startup options?

›
SQL>  STARTUP --> starts normally SQL>   STARTUP nomount --> starts as nomount mode SQL>   STARTUP  restrict --> s...
Tuesday, 29 November 2016

How to enable debug mode?

›
SQL> GRANT DEBUG CONNECT SESSION TO hr; SQL> GRANT DEBUG ANY PROCEDURE TO hr; Lastly, reconnect to the session and try again :)
Wednesday, 23 November 2016

PLS-00201 Solution

›
Error PLS-00201: identifier ' TABLE_ALPER ' must be declared Solution Define public synonym for identifier e.g. SQL> CREA...

How to truncate a folder in Outlook?

›
Right mouse click on desired folder -> Select " Delete All " -> Click " Yes " -> Done! :)
Wednesday, 16 November 2016

ORA-01578 solution (if object is INDEX)

›
Error ORA-01578: ORACLE data block corrupted (file # 100, block # 50000) Solution Find the object that was corrupted: SQL>  ...
Thursday, 10 November 2016

How to get AWR report as html file?

›
Generate Snapshots SQL> EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot; -> Run this SQL as twice (at the begin and at the end) Get...

How to add target manually in 12c EM ?

›
Prepare the 12c EM server # vi /etc/hosts 10.10.10.10 alperdb.com -> remote machine (agent) IP and hostname Prepare the environment...
Wednesday, 9 November 2016

ORA-27102 solution

›
Error SQL> startup; ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device  Solution $ vi /etc/sysctl.conf   ed...
Monday, 7 November 2016

How to import old Toad profile for new one?

›
Export old  User Files from  %USERPROFILE%\AppData\Roaming\Quest Software Import them to %USERPROFILE%\AppData\Roaming\Quest Software u...
Wednesday, 2 November 2016

How to Clone Database Manually without any tool such as RMAN?

›
Collect live database paths before start $ ps -ef | grep pmon $ echo $ORACLE_SID $ echo $ORACLE_BASE $ echo $ORACLE_HOME $ . oraenv ...
Tuesday, 1 November 2016

How to configure listener port when it changes (like 1522) ?

›
After listener.ora and tnsnames.ora file changes, only run this command SQL> ALTER SYSTEM SET LOCAL_LISTENER ='(ADDRESS = (PROTOCOL...
Thursday, 27 October 2016

How to configure instant client for Toad?

›
-> unrar .zip file  e.g. C:\oracle_client\12.1.0\client_1 -> add this to "Environment Variables-> Path " That'...