I have a number of tables in SQL Server (can be 2005 or 2008) that need to have the data migrated to Oracle (10 or 11). There are images stored in these or large data files full of html code. The target Oracle tables have CLOB datatypes for the incoming data.
SQL scripts are not working. Oracle dmp files are used once the data needs to be moved into other Oracle databases. I cannot find a way to create a dmp file from SQL Server.
Does anyone know the correct way to do this initial transfer.