CODEWITHSUNDEEP
databaseoracle-database
Yuval Adam
Yuval Adam

Reputation: 165202

Oracle (?) DB dump file

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.

Upvotes: 0

Views: 1096

Answers (4)

APC
APC

Reputation: 146199

"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 .

Upvotes: 2

Kai Sternad
Kai Sternad

Reputation: 22830

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.

Upvotes: 5

Markus Winand
Markus Winand

Reputation: 8706

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

Upvotes: 1

Peter G.
Peter G.

Reputation: 15114

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

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

Upvotes: 2

Related Questions