I want to ask If oracle express can cooperate with oracle form and reports.
Basically I want to set up oracle db at my home PC (Win xp pro- Pentium 4- 3 Ghz,1 GB ram )for learning purpose with out making my system "heavy", so what is the best solution?
Sure; no problem. Download Oracle XE (Express Edition) from the Oracle Technology Network (you'll see it on the homepage, in the Featured Downloads section) and install it. Directory XE resides in is called "Oracle Home".
Then install Developer Suite (download it from the same site) and install it into different directory (i.e. Developer Suite should have another Oracle Home).
Use Net Configuration Assistant (or even copy TNSNAMES.ORA and SQLNET.ORA from XE/network/admin directory to Develper_Suite/network/admin one) and everything should work.