Re: How to connect another tablespace?
Date: 1995/11/04
Message-ID: <mreagan-0411952243380001_at_mreagan.fast.net>#1/1
In article <47brah$hg2_at_ctsc.hkbc.hk>, Johnson.Chow_at_Comp.HKBU.Edu.HK wrote:
> Hi,
>
> I have created another tablespace, other than system tablespace.
>
> But I'm not sure how to use (and mount) this tablespace.
>
> Would you mind telling me how to do it?
>
> TIA.
>
> --
> Johnson Chow
The first thing you need to do, if you haven't already, is create a second rollback segment in the SYSTEM tablespace. When you create a database, only one rollback segment is created. This rollback segment is only for activity in the SYSTEM tablespace. You can create other tablespaces, but cannot use them until you create a second rollback segment.
The way I usually create a new database is:
- create the database using the script generated by ORACLEINS (with some minor adjustments, of course).
- Log on as SQLDBA and create
- a tablespace for rollback segments (RB_SEG)
- a scratch tablespace (SCRATCH)
- a temporary segments tablespace (TEMP_SEG)
- Create a second rollback segment called RB_SEG_TEMP in the SYSTEM tablespace.
- Create the necessary rollback segments in the RB_SEG tablespace.
- Take the rollback segment created in step # 3 offline (RB_SEG_TEMP). This will keep the SYSTEM tablespace from being fragmented by that rollback segment.
- Create the necessary user accounts with SCRATCH as the default tablespace and TEMP_SEG as the temporary segment tablespace.
If the tablespace is truly offline,
ALTER TABLESPACE tablespacename ONLINE;
should bring it back online. You might want to check to see if the datafile is offline.
Good luck, and let me know if this works (or if I completely misunderstood the question 8-P).
Matt... Received on Sat Nov 04 1995 - 00:00:00 CET