Hi,
The quickest way by far is to do the Admin-Delete-Form as Jarl suggest.
Just make sure to export the form and directly related workflow, so you
can reimport these after the delete is done.
Our RRR|Chive tool can do this for you in a robust way with the following
config:
source_server
**
Hi Sean,
is a PL/SQL-Script an option for you?
Regards,
Jan Harenburg
INFOSYS GmbH / INFOSYS ONLINE GmbH * Remedy-Consulting *
jan.harenb...@infosys-online.de
http://www.infosys-online.de
Tel. +49 89 614471-0
Grünwalder Weg 13a
D-82008 Unterhaching
INFOSYS Online Sales Consulting Serv
RSLIST.ORG
Subject: [SPAM] Re: Deleting a form with 2 million records
Yes, at a database level is another option and access is "=
--0-441308472-1258644323=:25356
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi David,=0A=0AYes, at a=A0database l
RSLIST.ORG
Sent: Thu, 19 November, 2009 15:14:50
Subject: Re: Deleting a form with 2 million records
Hi Sean
Is it possible to access it via the database and use :-
truncate table Txxx ;
truncate table Bxxx ;
truncate table Hxxx ;
where xxx is the schemaid of the table (select name
Teh quickest way is to delete the form in Admin tool...
--
Jarl
2009/11/19 Sean Harrodine :
> **
> Hi all,
>
> I need to delete a form and the 2 million records stored in it.
>
> Can anyone elighten me please as to the best and safest way to delete the
> table with the least amount of impact on t
ld test it with a block of =
100
during operating hours just to get an idea of the overhead then up to 1k
=
if
things looked good there for another baseline. But then again it depends
=
on the
size of the record too, is there only 10 columns on the field or 100? =
Purging
1000 records with 1kb of data
, November 19, 2009 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Deleting a form with 2 million records
**
Hi all,
I need to delete a form and the 2 million records stored in it.
Can anyone elighten me please as to the best and safest way to delete
the table with the least amount of impact
Hi all,
I need to delete a form and the 2 million records stored in it.
Can anyone elighten me please as to the best and safest way to delete the table
with the least amount of impact on the system ie, without spiking the Oracle
archive logs.
Is it best to remove some or most of the records by
8 matches
Mail list logo