Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Database structure

Eddy Frances

2006-02-27

Replies:

Is there a script available to extract non-Oracle
tablespaces, users, and roles information into another
script?

My reason for this script is to be able to restore a
database backup done via Oracle EXP/IMP utility but
with more control over the location of the
tablespaces, users, and roles.

My idea is that if a department wants a restore of
there database (small in size). I could whip out the
script and get last nights export and restore the
database anywhere.

Thanks in advance,

Eddy
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.