Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: hypermommy@comcast.net (Hypermommy)
Newsgroups: comp.databases.oracle.misc
Subject: "View" to a large schema
Date: 7 Jul 2003 08:57:58 -0700
Organization: http://groups.google.com/
Lines: 26
Message-ID: <7ed5e93a.0307070757.39afe0f5@posting.google.com>
NNTP-Posting-Host: 160.130.101.54
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057593478 27960 127.0.0.1 (7 Jul 2003 15:57:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 15:57:58 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129099

Hi all,

You'll have to forgive me if I don't use the right terms.  I am
nowhere near an Oracle programmer and don't know the proper
termanology.  But I hope you'll bear with me....

Something I'm working on accesses an Oracle database we have at the
office.  Now this database has hundreds tables in one area (schema?)
and we can't change that.  However, the program that's accessing it
(which is an ASP thing) is timing out.  And I suspect it's due to the
number of tables and such that is there becuase it works fine with
smaller databases.

So, now, my issue is... what can we do in Oracle, without splitting up
this schema, to pull over references to just a few tables at a time. 
For instance, if we have 10 tables that deal with podiatrists and
that's all we want to look at is podiatrists and not all of the
pediatricians and so forth, is there some way -- without moving the
tables themselves -- to set up a view just to the podiatrist type
information?  Then I could set up an ODBC connection to that view
(whatever it is or however it's done) and see just podiatrist
information without the system trying to slog through all the doctors?

Thanks in advance for whatever assistance you can give me.

--== Hyper ==--