Import data from one table to another using exp/imp

[ryan101]

I have a dmp file that's a full export of my database from a few days ago. One of our devs wants the data contained in that export from table X. The tricky part is that he doesn't want to overwrite the current table X with the old data, he wants a new table (Y) created with the same data from X.

I was hoping there would be fromtable / totable parameters for imp, but I haven't had any luck finding them.

I was thinking of creating a new user (Bob) and specifying fromuser and touser in the imp parfile, importing the table and then doing a CREATE TABLE Y AS SELECT * FROM Bob.X.

Does anyone see any problems with using the above method, or does anyone have a better solution?

Thanks for the assistance!

 

[carp]

Your solution makes perfect sense to me (for whatever THAT'S worth!).