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

Home -> Community -> Usenet -> c.d.o.server -> Re: User level Oracle DB Schema

Re: User level Oracle DB Schema

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Sun, 18 May 2003 14:40:07 GMT
Message-ID: <3EC799F1.E0F141EB@telusplanet.net>

Alex Smith wrote:

> How can I export the complete database schema listing all the Tables, Views,
> Triggers, Stored Procedures, Functions, Packages, Grants etc...
> for a given user.
> I will need to export few lookup tables with data, but just the schema for
> all others. In other words - I would like the Oracle System Snap-Shot for a
> given user without the data.
>
> Any easy way of doing this.

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96652.pdf Received on Sun May 18 2003 - 09:40:07 CDT

Original text of this message

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