Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Puzzle with tablespaces in the HR sample schema.

Puzzle with tablespaces in the HR sample schema.

From: Paul <paul_at_not.a.chance.ie>
Date: Sun, 6 Jun 2004 20:30:24 +0100
Message-ID: <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...

-- 
plinehan  y_a_h_o_o  and d_o_t  com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.

"XML avoids the fundamental question of what we should do, 
by focusing entirely on how we should do it." 

quote from http://www.metatorial.com 
Received on Sun Jun 06 2004 - 14:30:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US