Backup table using create statement [message #428470] |
Wed, 28 October 2009 08:12  |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
Hi all,
I created a backup table before deleting some records in the table.
Here is the steps which i followed.
create table MAN_BKP as select * from MAN;
delete from man where records =1;
By mistake,i created the backup table MAN_BKP in A user (which should be created in user B)
and deleted the records in different user B.
Now my backup table is in user A.
My question is how to revert those backup table of user A to user B.
Thanks,
|
|
|
|
|
|
|
|
|
Re: Backup table using create statement [message #428507 is a reply to message #428496] |
Wed, 28 October 2009 09:51   |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
Let me explain one more time.
I have deleted some records in table in some user AA for which i had taken backup
not in the same user, but in different user.
Could you please tell me how to revert that backup table which i have created in
different user to the user (where i deleted records).
Hope it is clear now.
Regards,
|
|
|
Re: Backup table using create statement [message #428517 is a reply to message #428507] |
Wed, 28 October 2009 10:35   |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Hitman11 wrote on Wed, 28 October 2009 14:51
Could you please tell me how to revert that backup table which i have created in
different user to the user (where i deleted records).
To me this means that you want to move the backup table with all it's data to the user where you deleted the records. In which case I've already given the solution.
If that's not what you mean then you're going to have to describe the problem in more detail instead of just repeating yourself.
|
|
|
Re: Backup table using create statement [message #428539 is a reply to message #428507] |
Wed, 28 October 2009 13:01   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Hitman11 wrote on Wed, 28 October 2009 10:51
I have deleted some records in table in some user AA for which i had taken backup
not in the same user, but in different user.
What schema, what table, when? List a detailed description with schema names and table names along with a timeline of when things were done. You're explanation leaves a lot to be desired. "Same," "different," "some" are such ambiguous words.
|
|
|
|
|