niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Tools
Getting the schema of a View
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
Author Message
psoug
*nix forums Guru


Joined: 15 May 2005
Posts: 3492

PostPosted: Fri Jul 07, 2006 5:26 pm    Post subject: Re: Getting the schema of a View Reply with quote
David C. Barber wrote:
Quote:
Hi,

We have an Oracle 10 (I believe) database, but none of the tools to go with
it yet due to budget constraints. You know how it is with Oracle tools. It
runs a single vendor application comprising over 1400 tables and views. Now
we have to pry open the hood a little bit and get some data out. The vendor
documentation is trash, but I have a View that contains the data I'm
interested in. My problem is to trace back to the original tables that
comprise this View. Can anyone recommend any good Open Source (read: Free)
tools that can help me with this? I only have to do this maybe a few number
of times, which makes it hard to justify investing big bucks otherwise, and
I don't read DDL myself.

Thanks!

No tool required. In SQL*Plus type:

SELECT dbms_metadata.get_ddl('VIEW', '<the_name_of_your_view>')
FROM dual;

A full demo can be found in Morgan's Library at www.psoug.org under
DBMS_METADATA.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Back to top
gazzag
*nix forums Guru Wannabe


Joined: 08 Jun 2005
Posts: 277

PostPosted: Fri Jul 07, 2006 11:02 am    Post subject: Re: Getting the schema of a View Reply with quote
David C. Barber wrote:
Quote:
Hi,

We have an Oracle 10 (I believe) database, but none of the tools to go with
it yet due to budget constraints. You know how it is with Oracle tools. It
runs a single vendor application comprising over 1400 tables and views. Now
we have to pry open the hood a little bit and get some data out. The vendor
documentation is trash, but I have a View that contains the data I'm
interested in. My problem is to trace back to the original tables that
comprise this View. Can anyone recommend any good Open Source (read: Free)
tools that can help me with this? I only have to do this maybe a few number
of times, which makes it hard to justify investing big bucks otherwise, and
I don't read DDL myself.

Thanks!

Download Oracle's free SQL Developer tool from here:

http://www.oracle.com/technology/software/products/sql/index.html

HTH

-g
Back to top
GuessWho
*nix forums beginner


Joined: 29 Jun 2006
Posts: 10

PostPosted: Fri Jul 07, 2006 7:17 am    Post subject: Re: Getting the schema of a View Reply with quote
"David C. Barber" <david@NOSPAMdbarber.com> wrote in message
news:0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d@comcast.com...
Quote:
Hi,

We have an Oracle 10 (I believe) database, but none of the tools to go
with
it yet due to budget constraints. You know how it is with Oracle tools.

Oracle SQL Developer is free! Downloadable from otn.oracle.com.
R.

Quote:
It
runs a single vendor application comprising over 1400 tables and views.
Now
we have to pry open the hood a little bit and get some data out. The
vendor
documentation is trash, but I have a View that contains the data I'm
interested in. My problem is to trace back to the original tables that
comprise this View. Can anyone recommend any good Open Source (read:
Free)
tools that can help me with this? I only have to do this maybe a few
number
of times, which makes it hard to justify investing big bucks otherwise,
and
I don't read DDL myself.

Thanks!

Back to top
David C. Barber
*nix forums beginner


Joined: 07 Jul 2006
Posts: 1

PostPosted: Fri Jul 07, 2006 5:49 am    Post subject: Getting the schema of a View Reply with quote
Hi,

We have an Oracle 10 (I believe) database, but none of the tools to go with
it yet due to budget constraints. You know how it is with Oracle tools. It
runs a single vendor application comprising over 1400 tables and views. Now
we have to pry open the hood a little bit and get some data out. The vendor
documentation is trash, but I have a View that contains the data I'm
interested in. My problem is to trace back to the original tables that
comprise this View. Can anyone recommend any good Open Source (read: Free)
tools that can help me with this? I only have to do this maybe a few number
of times, which makes it hard to justify investing big bucks otherwise, and
I don't read DDL myself.

Thanks!
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
The time now is Sat Nov 22, 2008 5:38 am | All times are GMT
navigation Forum index » Databases » Oracle » Tools
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts hi, I am not able view all the records in the tabel Annam Srinivas MySQL 0 Fri Jul 21, 2006 7:42 am
No new posts Creating relational view for an ODBC result set? antilog@gmail.com Server 0 Fri Jul 21, 2006 5:56 am
No new posts Referential Integrity Using View Mahesh, MS, PMP Server 0 Tue Jul 18, 2006 2:34 pm
No new posts import to clone schema revisited EdStevens Server 0 Mon Jul 17, 2006 7:01 pm
No new posts CREATE VIEW xxxx Karl Larsen MySQL 1 Mon Jul 17, 2006 12:26 pm

Web Advertising | Myspace Proxy | Remortgages | Property for sale in Spain | MPAA
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2008s ][ Queries: 20 (0.1168s) ][ GZIP on - Debug on ]