How to restore .dmp oracle file by using import

I take it as a challenge for myself when a friend in workplace ask for a help about how to restore a dmp file to a local machine.

Honestly, i have never done it before. so I went to google activity and found this related article. Thanks to Frenda on (http://frenda.wordpress.com/2013/01/05/importing-oracle-dmp-file-using-cmd/)

This was the summary that i have done on local machine
1. create user on oracle db (login using system)
2. setting connection on tns file
3. open command prompt | entry 'IMP'
4. follow the instructions. (image attached)

5. database are imported to my local machine

that's it and it works

Validate date in excel

I now realize that Excel is a powerful tool..  hehehe

to validate a date in cell, put a formula next to it like this

=isnumber(datevalue([cell]))

it's simple right?

:)

Got a formula in excel cell as text and you want it to work as a formula? here is how to do it

When you have a formula in excel as text, and we want to parse it as a formula.
use this steps to do it:

1. For a simple example, text in cell A1 is like this  ="=B1+C1"
2. Press alt+F11 to open Excel VBA
3. Insert new module to that excel file
4. Put this on the module text window

Function Eval(Ref As String)
    Application.Volatile
    Eval = Evaluate(Ref)
End Function

5. Save & close it.

6. Change the text in A1 into something like : =Eval("=B1+C1")

7. Just click enter then it would run the module that we have inserted to it.

Could not connect to Oracle XE (using Toad) : ORA-12541: TNS:no listener

A little confusing when i want to connect to my oracle database using toad after i restart my computer.
It show me error : ORA-12541: TNS:no listener. It was fine before i restart my computer.

The solution to this matter was the service to oracle TNS Listener should be turned on.
Open your control panel  |  administrative tools  |  select service.
On the Services window, find 'OracleXETNSListener' and just started it.

whoalaa... that should be it.
try the oracle connection again. It should be running now.