Re: Restoring tables/tablespaces

From: <Heidi_Schmidt_at_gillette.com>
Date: Mon, 25 Sep 2000 12:17:32 -0400
Message-Id: <10630.117760@fatcity.com>

Ana,

Since you do a cold backup of the datafiles you can restore to a date before the user was dropped and then
go export the entire user.

Then after the entire user is exported create a new user that reflects the type of work the tablespace is needed for. For example report as a username for a reporting tool.

So what I would do would be something like this. Double check the steps and see if you have disk space to do this.

     Restore datafiles from before user account disabled and the objects were dropped.

     Export the user in its entirety as the user (if you need to change the password in svrmgrl as sys/internal)

     Create an index file from the user based on a parfile [reference command imp help=y ]

     Create a new user with basic create session, and unlimited tablespace with some create objects grants

     making sure the default tablespace is accurately where you want the objects to go.

     Create another parfile that only loads the rows and not the indexes or the constraints make sure the fromuser is the user that was exported and the touser is the new user who you want the objects to be owned by.

     Go through all the cron jobs or batch jobs on the system and dependent jobs run by hand in t he former

     users directory and change the username/password in
     the connect string
     Better yet, put that in a dotfile with a name you will remember with
permission's 0740 and then only change
     the connection in one place and have it sourced into the script when

needed.

     I probably left out a detail or two so double check me. Received on Mon Sep 25 2000 - 11:17:32 CDT