Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database structure
hi
you can use dbms_metadata if you are in 9i
On 2/27/06, Eddy Frances <efrances2000_at_yahoo.com> wrote:
>
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 27 2006 - 11:39:15 CST
![]() |
![]() |