Thanks for the response.
If I was to use the export/import with the fromuser=x touser=y .
It will import all of the table from user x to y, then I have to go back to x schema and drop all of the tables(about 70) that I do not want in that schema right ?
Is there any simplier way just get the 70 tables out of that schema rather the whole list of tables? I see that I have the
list the name of all the tables
tables= table1,table2,table3,table4xxxxxxxxx
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
Reply With Quote