Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Puzzle with tablespaces in the HR sample schema.
"Paul" <paul_at_not.a.chance.ie> wrote in message
news:MPG.1b2d812825d103d498993f_at_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 Received on Sun Jun 06 2004 - 16:04:27 CDT