Re: single table restore w/out exports
From: Nick Strange <nicks_at_churchill.co.uk>
Date: Wed, 29 Mar 1995 10:05:38 GMT
Message-ID: <D675DH.HIw_at_churchill.co.uk>
Date: Wed, 29 Mar 1995 10:05:38 GMT
Message-ID: <D675DH.HIw_at_churchill.co.uk>
Glenn Travis (gtravis_at_richmond.infi.net) wrote:
: We are running cold backups as our backup. Shut down database, backup
: system files, restart db. Our users want to be able to restore single
: tables as they did before when we we using exports. Is there a way to
: use the datafiles and a temp db to trick oracle into loading the table,
: so we could export it from a copy of the datafile?
: --
: Glenn Travis
: DBA
: Circuit City Stores, Inc.
: Richmond, VA USA
: gtravis_at_richmond.infi.net
: gtravis_at_aol.com
You will have to restore the database. and then export the table you require. Either restore the database to another machine (no problems with sids or file names) or be careful about overwriting your 'real' database.
--
_____________
Nick Strange churchill Tel: +44 81 313 5679
Head of IT ============= Fax: +44 81 313 5699
Churchill Technology
15-17 London Rd, Bromley BR1 1DE, UK. Email: nicks_at_churchill.co.uk
Received on Wed Mar 29 1995 - 12:05:38 CEST