Re: some simple questions about tablespace

Brian,

Problem 1:
Take the BAckup of the database before proceeding . Take the export of the user whose TBS needs to be changed. Drop the user.
Create the same user and change the TBS to New one. Import the backup of the user into the new user.

Problem 2:
No Oracle will use all rollback segments dynamically. For long transactions use
SET TRANSACTION USE ROLLBACK SEGMENT <NAME>. Try to keep all the Rollback Segments of same size. IF using Big Transaction i.e. Batch Processing and you feel that existing RBS would not suffice then use the above command to explicitly assign a bigger RBS to the Transaction.

Problem No 3
Temporary Segment usage depends on the User as you specify Users with Temporary Segements. Assign Temporary segments as per users i.e. which user is assigned for Batch Processes and which is assigned for small Processes. OR
Create a single Temporary segment of the size of Maximum size of Transaction .

Thanx

Brian Yan <by2_at_gpu.srv.ualberta.ca> wrote in article <362EA454.25DB_at_gpu.srv.ualberta.ca>...
> I am new on DBA stuff. I would appreciate it very much if someone can
> help me on the following questions.
>
> 1). Can I specify the new tablespace while importing a schema data file?
> I created new tablespace DATA_1 and INDEXES_1 for the new imported
> schema datafile. How to let the import go to the new tablespace instead
> of existing tablespace?
>
> 2). I have eight small rollback segments and three big rollback
> segments. Will the Oracle be smart enough to go to the big rollback
> segment when it is doing big transactions? Or I should turn the small
> rollback segments offline manully when Oracle does big transactions?
>
> 3). Similar question to temporary tablespace. If I create a small temp
> tablespace and a big temp tablespace for importing. Is Oracle smart
> enough to select the appropriate tablespace according to the
> transaction? Or I should turn one offline manully?
>
> Thank you for your help!
>
> Brian
>
Received on Fri Oct 23 1998 - 15:49:20 CDT