Re: Database structure
- From: "LiShan Cheng" <exriscer@xxxxxxxxx>
- To: efrances2000@xxxxxxxxx
- Date: Mon, 27 Feb 2006 18:39:15 +0100
hi
you can use dbms_metadata if you are in 9i
On 2/27/06, Eddy Frances <efrances2000@xxxxxxxxx> 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
>
>
>
- References:
- Database structure
- From: Eddy Frances
Other related posts:
- » Database structure
- » Re: Database structure
- » RE: Database structure
- Database structure
- From: Eddy Frances