Oracle (?) DB dump file

Question

I have a legacy DB dump file which starts off something like this:

^C^@&D
EXPORT:V07.03.04
DHISTO
RTABLES
8192
0
^@    Mon Jan 11 09:02:31 2010
TABLE "ABCD"
CREATE TABLE "ABCD" ("TIME" DATE, "ELEMENT" CHAR(16), ....

From the "EXPORT:V07.03.04", and from the data I do have, I am assuming this is an Oracle DB dump (v7). Which tools do I have available to import this data?

Thanks everybody for the help. I ended up installing Oracle XE 10g, and using it to import the dump files - worked perfectly.

Kai Sternad · Accepted Answer · 2010-10-01 17:28:36Z

5

Yes, it looks like an Oracle dump format. You can use the imp command:

imp userid=user/passwd file=file.dmp ignore=y

Use ignore=y to skip tables that already exist (imp will give an error if the object is re-created). Depending on what you whant to import from the dump you may also have to use other flags, such as full=y (Grants and constraints are automatically included).

See

imp help=yes

for all options of this command.

answered Oct 1, 2010 at 17:28

Kai Sternad

23k8 gold badges50 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yuval Adam Over a year ago

Thanks! On a machine which currently has no Oracle installation, what would be the fastest way to import this data so I can export it to other formats and work with it?

Kai Sternad Over a year ago

Maybe you could download a preconfigured virtual machine or use a respective instance of a cloud provider. Then again it probably isn't too time consuming to install a version of Oracle XE (free) on your local computer. Then fire up imp with your data.

Peter G. · Accepted Answer · 2010-10-01 17:15:57Z

2

Oracle imp is the counterpart to exp which created this file.

http://www.orafaq.com/wiki/Import_Export_FAQ

answered Oct 1, 2010 at 17:15

Peter G.

15.2k7 gold badges60 silver badges76 bronze badges

Comments

APC · Accepted Answer · 2010-10-02 04:02:28Z

2

"On a machine which currently has no Oracle installation, what would be the fastest way to import this data so I can export it to other formats and work with it?"

The file is an Oracle proprietary format. So the easiest way of working with it would be to install an Oracle database and use IMP to load it. You can use pretty much any version of Oracle as the target because IMP has backwards compatibility going way back. If you have an Oracle Support account the relevant note is id=132904.1 .

answered Oct 2, 2010 at 4:02

APC

147k20 gold badges180 silver badges289 bronze badges

3 Comments

Yuval Adam Over a year ago

Would Oracle Express Edition 11g be able to handle this v7 format?

APC Over a year ago

@YuvalA - 10gR2 is the only available version of XE. XE does support IMP. Note that the XE documentation gives examples using Datapump Import - that won't work with an Oracle7 Export file: you need to use the Import utility.

Yuval Adam Over a year ago

so just to clarify - using imp should work with oracle7 dump file?

Markus Winand · Accepted Answer · 2010-10-01 17:16:15Z

1

Try "imp": http://wiki.oracle.com/page/Oracle+export+and+import+

answered Oct 1, 2010 at 17:16

Markus Winand

8,8541 gold badge38 silver badges49 bronze badges

Collectives™ on Stack Overflow

Oracle (?) DB dump file

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related