Re: How to switch between two tablespace?

Just to be picky, the tablespace is really their logical location, and the datafile is their physical location.

I feel much better now I've got that out! ;)

Pete

Sybrand Bakker wrote:

> 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.

--

Regards

Pete

Received on Mon Jun 28 1999 - 11:05:51 CDT