Re: How to switch between two tablespace?

Just some clarification:
Tables are created in a schema. The tablespace is only their fysical location.
If you have two tables called guest, they should have two different owners, as a tablename is unique
within a schemaname.
So you need, as system,
statements like
select * from owner1.guest
and
select * from owner2.guest
I don't know how 'newer' you are, I would recommend you read the Oracle Concepts Manual, before you get yourself up in a mess. It is very easy to end there, if you have insufficient knowledge of Oracle. This is meant as friendly advice of course, not to reproach you.

Hth,
Sybrand Bakker, Oracle DBA

johnlyn_at_my-deja.com wrote in message <7l48u5$edo$1_at_nnrp1.deja.com>...
>Hi:
> I am a newer dba for oracle8. I have created two tablespace, one is
>named "tablespace_one",another is named "tablespace_two". All of them
>have a table named 'guest'.
> The question is: I have connected oracle8 as system user. How to
>view the data of 'guest' in 'tablespace_one'? How to switch to 'guest'
>in 'tablespace_two'?
>
>Thanks!
>
>John l.yn
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Jun 27 1999 - 02:59:13 CDT