Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

How can I take dump?

  Asked By: Boell    Date: Sep 21    Category: Java    Views: 350

Do you know How I can take a dump from db (oracle10g) by some java
code or sql statement.



2 Answers Found

Answer #1    Answered By: Ayaz Hashmi     Answered On: Sep 21

1) exceute a select * SQL command
2) get field names and info by getmetadata on resultset
3) crate "create table" statement  from metadata
4) iterate result set and craate insertstatements
add result of 3,4 to your dump  file

Answer #2    Answered By: Zane Thompson     Answered On: Sep 21

Try the command line utility pair expdp/impdp

Didn't find what you were looking for? Find more on How can I take dump? Or get search suggestion and latest updates.