Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!m58g2000cwm.googlegroups.com!not-for-mail
From: "Valentin Minzatu" <valentinminzatu@yahoo.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: move a row from table t1 to t2
Date: 2 Feb 2007 09:42:59 -0800
Organization: http://groups.google.com
Lines: 20
Message-ID: <1170438179.821348.62880@m58g2000cwm.googlegroups.com>
References: <1170343560.742415.202130@a34g2000cwb.googlegroups.com>
NNTP-Posting-Host: 205.189.93.240
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170438184 8460 127.0.0.1 (2 Feb 2007 17:43:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 17:43:04 +0000 (UTC)
In-Reply-To: <1170343560.742415.202130@a34g2000cwb.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m58g2000cwm.googlegroups.com; posting-host=205.189.93.240;
   posting-account=fFMh9AwAAADc9-o_9lpjYaP-XzKecp04
Xref: news.f.de.plusline.net comp.databases.oracle.misc:77901

On Feb 1, 10:26 am, "Prasath" <prasath....@gmail.com> wrote:
> Hi,
>
> I have a requirement, where I frequently move a row from table t1 to
> t2.   The tables have an identical structure.
>
> I accomplish this task in two steps.
>
> 1. INSERT into t2.
> 2. DELETE from t1.
>
> Is there an efficient way of doing this? Can this be accomplished in
> one step?
>
> Thanks,
> Prasath.

What makes your approach inefficient? Takes too long? Resource
utilization?