Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Puzzle with tablespaces in the HR sample schema.
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.comReceived on Sun Jun 06 2004 - 14:30:24 CDT