Home -> Usenet -> comp.databases.oracle -> access data from other tablespaces

access data from other tablespaces

From: dave <davidvantassell_at_yahoo.com>
Date: 7 Oct 2002 08:45:30 -0700
Message-ID: <5a7c603c.0210070745.7df0dce1_at_posting.google.com> 






I'm trying to learn the syntax (if it exists) on how to reference data
from a different tablespace.  I'm new to oracle and creating a new
database, and having read that it's good to sepearate the database
into different tablespaces I thought I might try that.  However if I
have a table called fruit in my produce tablespace and a table called
list in my shopping tablespace I can't figure out how to relate the
two.  (To add to the situation, if I create a table, then it creates
the table in the shopping tablespace.)



I tried:

sqlplus> select produce.fruit.name
sqlplus> from produce.fruit
sqlplus> where produce.fruit.fruit_id = shopping.list.fruit_id
sqlplus> ;





it tells me that it value: "shopping.list.fruit_id" is not valid.



Any suggestions or where I might go to find the answer?



Thanks
Received on Mon Oct 07 2002 - 17:45:30 CEST












Original text of this message