Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restoring tables/tablespaces

Re: Restoring tables/tablespaces

From: David Turner <>
Date: Mon, 25 Sep 2000 11:09:39 -0700
Message-Id: <>

Recover the database to another machine then extract what you want. This will prevent you from toasting your current database. Prior to all this take another back up of your current database.

Dave Turner
On Mon, Sep 25, 2000 at 08:00:30AM -0800, wrote:
> One of our users left the university. The termination procedures require
> that all computer accounts are closed, so HR notifies the Help Desk who in
> turn checks and deletes all accounts owned by that person. So they did.
> Unfortunately, this person was doing some heavy work in Oracle. His
> default tablespace was the 'users' tablespace, and by default all his
> important stuff was created in this tablespace, with him as the owner. So
> now, all the jobs running in 'datastage' are failing of course.
> No one else has anything of importance in the 'users' tablespace, so this
> tablespace might be restored to a previous state without problem.
> My question to the list is: Is it possible to restore a tablespace from
> tape without affecting the database as a whole? We'll need to recover all
> objects owned by this person.
> We're on a Sun Solaris 2.6 box, Oracle The database is in no
> archive log mode. We shut down the database at 12:00 am, and restart it at
> 2:00am every day to do backup. We're backing up the file system, not using
> any Oracle backup procedures.
> Thanks.
> Ana Choto
> Systems Programmer
> American University
> Phone (202) 885-2275
> Fax (202) 885-2224
> --
> Please see the official ORACLE-L FAQ:
> --
> Author:
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Sep 25 2000 - 13:09:39 CDT

Original text of this message