Are all the insert operations inside a transaction?
ie do you notice a
begin ; or
begin work;
line in the initial part of the .sql file
then there shud be a commit; line in the
end of the sql file otherwise the transaction
will rollback.
in case you are inserting from a program you
must send commit
On Thu, 2004-10-21 at 09:51, akanksha kulkarni wrote:
> Hi,
>
> I am trying a simple insert command with select
> statement (Insert into () select
> from ).
> The data to be inserted is around 1 GB.
> The problem is that at the end of the insert
> operation, data is NOT inserted.
>
> I was moni
