Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
xml and perl
- Thread starter moof15
- Start date
MattMcGinnis
Programmer
Hmmmmm. Your subject is "XML and perl" but your question is about Oracle and .dmp files. Have you converted the dmp file to an XML document?
You could use a combination of an XML module (I think XML::Simple would work) and the ODBC module to 1.parse the info from the XML doc and 2.insert the info into Oracle.
It all depends on the format of the dmp file, the structure of your table, and what info you WANT to put in the database. I don't think you are going to find a script which will do exactly what you want, but you may find something to customize. Actually, it might just be easier to write the whole thing using the modules.
Maybe if you provide more info, someone here can help you.
MattMcGinnis
You could use a combination of an XML module (I think XML::Simple would work) and the ODBC module to 1.parse the info from the XML doc and 2.insert the info into Oracle.
It all depends on the format of the dmp file, the structure of your table, and what info you WANT to put in the database. I don't think you are going to find a script which will do exactly what you want, but you may find something to customize. Actually, it might just be easier to write the whole thing using the modules.
Maybe if you provide more info, someone here can help you.
MattMcGinnis
- Thread starter
- #3
- Thread starter
- #4
- Status
Similar threads
