Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB Schema
Well, a very general query can be
Select * from all_objects;
geetha_sanjeeviah_at_p-com.com wrote:
>
> Hi :
>
> I am new to Oracle, PL/SQL and Databases. I want to know the command in
> PL/SQL which I can enter from commandline, so that I can create a Dump
> file which gives me all the information about the various Schema objects
> like Tables, Views etc present in my Oracle 7 Database.
>
> Thanks
> Gita
>
> PS: Please direct all the replies to geetha_sanjeeviah_at_p-com.com
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Tue Feb 03 1998 - 00:00:00 CST