SQL Server 2000, because the project needs to use Oracle 9i, the basic operation is to extract Oracle's data into SQL Server 2000, spend a while, I hope that the small process can provide GGDD, JJMM that needs these operations We laugh at it.
PCA: Windows XP SQL Server 2000 PCB: Windows 2K Server Oracle 9i
1) First install a simple client using Oracle 9i installer. (Application development is installed, more than 100 m, the master can use custom :));
2) Change the file, find the TNSNames.ora file under / oracle / ora92 / network / admin in the installed Oracle directory, if you don't have an urgent, find / Oracle / ORA92 / Network / Oracle / ORA92 / Network / Oracle / ORA92 / Network / Oracle / ORA92 / NETWORK / Admin Copy to PCA / ORA92 / NETWORK / Admin / ORA92 / Network / Admin / ORA92 / Network / Admin / ORA92 / Network / Admin / ORA92 / Network / Admin / ORA92 / NETWORK / ADMIN, use Notepad to open this file, add code:
..............................
Test = (deSCription = (address = (protocol = tcp) (port = pcb))))))))))))
..........................
3) Use the DTS of SQL Server 2000, select "Import Data", and select "Microsoft Ole DB for Oracle", click Properties, enter the server name: Test (above, it is also the PCB machine Oracle database 哟), Username: username Password: Password Username Password You should know, fill it.
4) Then go down, select the database to import to the PCA machine SQL Server 2K,
5) Select the imported table,
6) Import start. Everything is done.
