Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database structure

Re: Database structure

From: LiShan Cheng <exriscer_at_gmail.com>
Date: Mon, 27 Feb 2006 18:39:15 +0100
Message-ID: <6e9345580602270939t43966c91y40be00988463c0c4@mail.gmail.com>


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-l
Received on Mon Feb 27 2006 - 11:39:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US