Finally, They believe me to develop a project. yattaaaa..
It’s really amazing for me. I’ll do my best.. YOSSSHHH.. hehehe…
I should create a dblink and store procedure that contain dynamic sql to query some data from oracle 8i to oracle 7i. Due to oracle 7i only can be access successfully using dblink that created in oracle 8i so I should install oracle 8i first at my XP Professional OS. It can be accessed using dblink from 9i, but the connection’s too slow.
First step, I should install Oracle 8i in Windows XP before create the dblink. So many times I tried but the 8i setup was still not working. Then, as usual, I’m googling and.. tam.. ra.. ram…
just do this:
- Copy the content of your Oracle CD into hard disk in your machine. For example Copy from oracle8i CD into D:\Oracle\ …
- Search the file Symcjit.dll on the D drive (where you have copied Oracle8i. You can found it in:
- For Oracle8i 1.7:
D:\Oracle\stage\Components\oracle.swd.jre\1.1.7.30\1\
DataFiles\Expanded\jre\win32\bin\symcjit.dll
- For Oracle8i 1.6:
D:\Oracle\stage\Components\oracle.swd.jre\1.1.7.24\1\
DataFiles\Expanded\jre\win32\bin\symcjit.dll- Rename those file (Example): symcjit_back.dll
- Execute the Oracle setup.exe from D:\Oracle\setup.exe
Yatta, it’s really works Friend..
Ok, lets go to the next step.. ^o^
