problème de rollback segment

**valauga** · 27/11/2007, 16h23

J'ai créé une base de données en 9i de la façon suivante :
-------------------------------------------------------

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
    create database BUSINESS
       maxinstances 8
       maxlogfiles  32
       character set WE8ISO8859P9
       datafile
          '/baseBUSINESS/BUSINESS/system01.dbf'   size   500M EXTENT          MANAGEMENT LOCAL
       DEFAULT TEMPORARY TABLESPACE temp
       TEMPFILE  '/baseBUSINESS/BUSINESS/temp01.dbf' size 500M
       logfile
          '/baseBUSINESS/BUSINESS/redoA1.log'   size 500k ,
          '/baseBUSINESS/BUSINESS/redoB1.log'   size 500k ,
          '/baseBUSINESS/BUSINESS/redoC1.log'   size 500k ;
 
   create rollback segment r0 tablespace system
      storage (initial 16k next 16k minextents 2 maxextents 20);
      alter rollback segment r0 online;
 
      create tablespace UNDO datafile '/baseBUSINESS/BUSINESS/rbs01.dbf'   size 500M;
    create tablespace tools datafile '/baseBUSINESS/BUSINESS/tools01.dbf' size 10 M default storage (pctincrease 0);
    create tablespace users datafile '/baseBUSINESS/BUSINESS/users01.dbf' size 500K default storage (pctincrease 0);
     create tablespace business   datafile '/baseBUSINESS/BUSINESS/business.dbf' size 1500M
      default storage (pctincrease 0);
    create tablespace business_i datafile '/baseBUSINESS/BUSINESS/business_i.dbf'  size 1000M
      default storage (pctincrease 0);