Tuesday, 28 October 2014

[ADVICE] Free Windows Disk Defragmenter Alternative

›
I strongly recommend to use  Smart Defrag tool instead of classical Windows Defragmenter tool.
Sunday, 26 October 2014

How to check NTFS file system in CMD?

›
Only you need to run this command. e.g. chkntfs C: C:\Windows\system32>chkntfs C: The type of the file system is NTFS. C: is not ...

How to defrag disk partiton in CMD?

›
Only you need to run this command as Administrator. e.g. defrag C:

How to change font color in CMD?

›
Only you need to run this command in cmd. e.g. color A 0 = Black 1 = Blue 2 = Green 3 = Aqua 4 = Red 5 = Purple 6 = Yellow 7 = W...

How to define a tablespace in Windows?

›
Please execute the commands as "sys"; To define the tablespace: SQL>  CREATE TABLESPACE ALPER_DATA  DATAFILE 'C:\table...

How to prepare a video with steps via windows tool?

›
Please you run this command first in cmd. CMD> psr Then you can record the steps by clicking start record. After finish your video...

How to know hostname from IP in Command Prompt?

›
Press Windows button + R and press cmd then click "OK". Then, write down "below command" and press enter nbtstat -a ...
Wednesday, 22 October 2014

How to delete linux user?

›
# sudo userdel -r alper -r -> Remove home directory and mail spool
Tuesday, 21 October 2014

How to run sql query in shell script?

›
Please add these codes into your .sh file then you can run .sh file e.g.  ssh -q -T oracle@192.168.2.2  << EOF sqlplus / as sysdb...

How to know file format description in CMD?

›
Please you run this command in CMD. e.g. assoc .rar .rar=WinRAR e.g. assoc .txt .txt=txtfile
Monday, 20 October 2014

What are testing types and methods?

›
There are two test methods which are Black Box Testing and White Box Testing Basically, there are two test types which are Functional ...

What is the goal of testing?

›
The goal of testing is to reach minimum bug number and using time effectively as person/day.

What are Verification and Validation in software world?

›
Verification is that the process of evaluating work-products (not the actual final product) of a development phase to determine whether the...

How to know SuSE release version?

›
Only run this command in terminal; $ cat /etc/SuSE-release or $  cat -n /etc/SuSE-release (-n) to see rows numbers as well
Sunday, 19 October 2014

How to define and drop temporary tablespace?

›
Please execute the commands as "sys"; SQL> CREATE TEMPORARY TABLESPACE ALPER_TS_TEMP TEMPFILE   'C:\tablespaces\data_01...

How to run .sql file in sqlplus?

›
Press Windows button + R and press cmd then click "OK". Write down "below command" and press enter Full path approa...

How to change a specified string inside all files by recursively?

›
Only run this command in terminal; $ find . -type f -exec sed -i 's/' old '/' new '/g' {} \; You can also use e...

How to connect into RMAN tool in Windows?

›
Press Windows button + R and press cmd then click "OK". Write down "rman" and press enter Lastly run that command to...

How to login Windows machine with RDP (mstsc) even though firewall is active?

›
Please follow the instructions to use mstsc tool for Windows machines. Press Windows key -> Right-clicking on Computer and select Pr...
Wednesday, 15 October 2014

How to clear screen in sqlplus?

›
SQL> clear screen;