Oracle Dump Files and SQL Server
Posted on 2003-11-12
Hi, I have a few questions about Oracle dumps. I'm receiving a .dmp file that eventually needs to get imported into SQL Server... right now, we have to use a third party tool to "undump" the oracle file and get the tables that are associated with the dump. My first question is, can you create a dump file and include the column headers? Right now we're not getting any kind of schema included in the dump, just the raw data.
Secondly, is there some way that I can read the .dmp file in SQL Server? Or are dump files specific to only the platform from which they came? I can get SQL to run a command line shell and run the tool to "undump" the oracle file, but just wondered if there was an easier way to do it.
I am totally unfamiliar with the dump process from Oracle... so any help would be greatly appreciated.