Re: How to connect another tablespace?

In message <47brah$hg2_at_ctsc.hkbc.hk>, wschow_at_Comp.HKBU.Edu.HK (Mr. Chow Wing Siu) writes:

>Hi,
>
>I have created another tablespace, other than system tablespace.
>
>But I'm not sure how to use (and mount) this tablespace.
>

By default the tablespace is online upon creation. Alter the user you would to use this tablespace as follows:

alter user username
default tablespace TS_NAME
temporary tablespace TS_NAME
quota unlimited/size in bytes on TS_NAME.

You can now create objects in the altered user's schema which will be stored in the designated default tablespace. It is important to keep all user objects and database activity out of the system tablespace. To get information on the tablespaces in your DB, query the dba_tablespaces view. You can query dba_segments to find out what tablespace objects are stored in.

Regards -- Angelo Melendez (melendez_at_nosc.mil) Received on Fri Nov 03 1995 - 00:00:00 CET