I am a SQL Server 2000 DBA and was given a task to get an Oracle .dmp file into SQL Server.
Is it even possible to do? Or do I have to script the Oracle DB and import the DB that way?
But then how would I get the data?
I need to get the Oracle structure and the Data over to SQL Server.
i very much doubt you'll be able to get sql server to accept oracle .dmp input. rather, use amended select statements to create csv data spooled to file. sql server, like db2's load utility and oracle's sql*loader has a utility to handle this.
alternatively, for seamless migration use oracle's gateway product to allow the databases to talk directly to each other.
of course, this is all useless to you if you can't get at the database