migrate database from SQL Server to Oracle 8i

[gmennessier]

Hello,

I want to import database from Oracle 8i.
It is actually a SQL Server database.
What must I do ?

 

[walaS1]

exp from USER/PASS@INSTANCE FILE=filename.dmp FULL=Y
imp to USER/PASS@INSTANCE FILE=filename.dmp FULL=Y

 

[walaS1]

exp fromUSER/PASS@INSTANCE FILE=filename.dmp FULL=Y
imp toUSER/PASS@INSTANCE FILE=filename.dmp FULL=Y

 

[Turkbear]

Apparently folks have missed a detail:
You cannot export from SqlServer with the Oracle EXP utility!

Look at

http://technet.oracle.com

for info about the Oracle Migration Assistant and/or
export your data, using SqlServer tools, as a delimited file and use Oracle's SqlLoader tool to load it
into your Oracle database-- This is much more difficult
since you need to precreate the structures and create the control files first..

Try the Migration assistant first...