Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!newsrout1.ntli.net!news-in.ntli.net!newspeer1-win.server.ntli.net!newsfe5-gui.server.ntli.net.POSTED!53ab2750!not-for-mail
From: "Dave" <david.sharples3@ntlXworld.com>
Newsgroups: comp.databases.oracle.misc
References: <MPG.1b2d812825d103d498993f@news1.eircom.net>
Subject: Re: Puzzle with tablespaces in the HR sample schema.
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <LxMwc.1421$9%3.728@newsfe5-gui.server.ntli.net>
Date: Sun, 6 Jun 2004 22:04:27 +0100
NNTP-Posting-Host: 81.106.166.174
X-Complaints-To: http://www.ntlworld.com/netreport
X-Trace: newsfe5-gui.server.ntli.net 1086559467 81.106.166.174 (Sun, 06 Jun 2004 22:04:27 GMT)
NNTP-Posting-Date: Sun, 06 Jun 2004 22:04:27 GMT
Organization: ntl Cablemodem News Service
Xref: core-easynews comp.databases.oracle.misc:110818
X-Received-Date: Sun, 06 Jun 2004 14:03:49 MST (news.easynews.com)


"Paul" <paul@not.a.chance.ie> wrote in message
news:MPG.1b2d812825d103d498993f@news1.eircom.net...
>
>
> Hi all,
>
>
> I am currently working through the book "Beginning Oracle Programming"
> by Dillon, Beck, Kyte & al.
>
>
> If you run this query
>
> SQL> connect oracle_admin/oracle_admin
> SQL> SELECT owner, table_name, tablespace_name
> 2    FROM dba_tables
> 3    WHERE owner in ('SCOTT', 'HR')
> 4    ORDER BY owner, tablespace_name, table_name
> 5    /
>
> (oracle_admin has dba privileges)
>
> All the tables is either in tablespace Example or System *_except_* for
> the COUNTRIES table in the HR schema.
>
> Don't all tables have to have a tablespace? Where is this country data
> stored? I'm a bit puzzled and would appreciate any pointers.
>
>
> TIA.
>
>
> Paul...
>
>

if its a partitioned tabledit might not show it