import exported .dmp file

[impulse24]

Hi,

I received an Oracle 7.0 exported .dmp file from a customer. The customer does not know the user, or schema info for the .dmp file.

How do I go about importing the file into my oracle 10g server. I have tried using the imp command with various switches, all which appear to start running but error with invalid user, and table doesnt exist messages.

Is there a way to force the imp to bring in the database, create the schema and tables, if they dont exist?
I have also tried a tool called NXTract but it only processes 5,000 records, and it looks like it gets the data incorrectly for some of the tables.


Any help would be appreciated.

 

[alexhu]

Can you use the system user and SHOW=Y to see what SQL is contained within the dump ?

Alex

 

[SaintJames]

have you resolve this issue, i' experiencing a simmilar issue with an export dmp from 8.17 from before I joined this company.

 

[SantaMufasa]

SaintJames and Impulse,

Do as Alex suggested. From your o/s command prompt:

imp file=<dump file name> full=y show=y userid=<DBA user>/<password>

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[SaintJames]

Therefore if I have more that one database on this server and my research is correct then the command I should run should look like this.

imp file=<dump file name> full=y show=y userid=<DBA user>/<password>.<dbname>

Please correct me if I am mistaken.


Today is a good day..

 

[SaintJames]

Sorry I typed it in wrong, it should look like this?


imp file=<dump file name> full=y show=y userid=<DBA user>/<password>@<dbname>

 

[SantaMufasa]

Correct, provided <dbname> is an alias in your tnsnames.ora file that points you to the instance named <dbname>.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[oradba101]

I do not think that Oracle10g will recognize an Oracle7 file so you may have to do this in stages. First, import the file into an Oracle8i database (preferrably 8.1.7.2 or higher) then into Oracle10g (Release 1). If this is a Oracle10g Release 2 then I believe the lowest version it will accept is Oracle9i.

Regards,

William Chadbourne
Oracle DBA

 

[karluk]

oradba101, is 10g release 2 out yet? I haven't heard anything except that the target release date was supposed to be sometime this summer.

 

[oradba101]

Oops, you're right. My mistake.

Regards,

William Chadbourne
Oracle DBA