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