fast recovery of an oracle schema
Posted on 2011-03-14
i have a question. An application works as having an oracle schema e.g. "abcd" and it has all objects inside tablespace "abcd". Now normal procedure to backup is to take export of that schema obviously which takes some time as data is growing. An in case we have to recover schema by importing from that export file it takes many hours.
is there any quick solution to this problem?
can only tablespace backup /restore can help in this scenario?