RE: Rollforwarddb Query

  Hi Anne,

 You might have to rollforward the whole database from the
 last checkpoint and apply the journals up until just prior
 the table drop transaction.

 If the table existed during the last checkpoint,  it will exist
 after the rollforward. Just make sure the '-eDD-MMM-YYYY' is before
 the table was dropped.

Andre
-----Original Message-----
From: Anne O'Kelly
To: [EMAIL PROTECTED]
Sent: 17/11/03 11:47 AM
Subject: Rollforwarddb Query

A table on our LIVE database has been accidentally dropped!!
What is the most efficient way to recover it and minimise data loss.
 
 
 
Can we rollforwarddb the one table from the checkpoint by just
recreating the table structure
as we are currently getting an error as the table does not exist.
 
 
Any quick replies would be appreciated greatly!
 
Thanks,
 
Anne



********************************************************************
This message is intended only for the use of the person(s) ("the
intended
recipient(s)") to whom it is addressed. It may contain information which
is
privileged and confidential within the meaning of applicable law. If you

are not the intended recipient, please contact the sender as soon as
possible. The views expressed in this communication may not necessarily
be the views held by LGCSB (Local Government Computer Services Board).

Any attachments have been checked by a virus scanner and appear to be 
clean.
Please ensure that you also scan all messages, as LGCSB does not accept
any liability for contamination or damage to your systems.
********************************************************************