OraFAQ Forum: Server Administration » Moving Data from a table to another

Home » RDBMS Server » Server Administration » Moving Data from a table to another

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving Data from a table to another [message #61138]

Wed, 31 March 2004 06:42

saj
Messages: 8
Registered: January 1999

Junior Member

How can we move data from table X to table Y? X and Y are of the same structure.This is to insert data into Y before deleting it from X.(Other than insert and delete).

Report message to a moderator

Re: Moving Data from a table to another [message #61142 is a reply to message #61138]

Wed, 31 March 2004 18:49

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

alter table X rename to Y;

Report message to a moderator

Re: Moving Data from a table to another [message #61148 is a reply to message #61138]

Thu, 01 April 2004 00:52

jeevanmitra
Messages: 7
Registered: January 2003

Junior Member

Hi

You can write a before delete trigger on table X which moves the data from X to Y before deleting it from X.

regards
jeevanmitra

Report message to a moderator

Previous Topic:	9i developar forms run problem in windows XP
Next Topic:	Start database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 12:19:14 CDT 2024