Re: sqlplus: create database

From: Antonio 6sette <bottesini_at_libero.it>
Date: Tue, 22 Nov 2005 08:51:36 +0000 (UTC)
Message-ID: <dlum6o$nek$2@area.cu.mi.it>

On 2005-11-21, Antonio 6sette <bottesini_at_libero.it> wrote:

on my laptop I have the error:

"ORA-01552 cannot use system rollback segment for non-system tablespace"

another question: when I create a databse with the following commands:

SQL> CREATE DATABASE DB1 DATAFILE '/usr/local/oracle/oradata/DB1/sys.dbf' SIZE 200 M AUTOEXTEND ON NEXT 10 M
LOGFILE '/usr/local/oracle/oradata/DB1/logfile01.log' SIZE 10 M, '/usr/local/oracle/oradata/DB1/logfile02.log' SIZE 10 M;

SQL> CREATE TABLESPACE rollback
DATAFILE '/usr/local/oracle/oradata/DB1/rollback.dbf' SIZE 100 M AUTOEXTEND ON NEXT 10 M; SQL> CREATE TABLESPACE temp
DATAFILE '/usr/local/oracle/oradata/DB1/temporary.dbf' SIZE 100 M AUTOEXTEND ON NEXT 10 M TEMPORARY; SQL> CREATE TABLESPACE data
DATAFILE '/usr/local/oracle/oradata/DB1/datafile.dbf' SIZE 100 M AUTOEXTEND ON NEXT 50 M;

SQL> CREATE ROLLBACK SEGMENT t0;
SQL> ALTER ROLLBACK SEGMENT t0 ONLINE;
SQL> SET TRANSACTION USE ROLLBACK SEGMENT t0;
SQL> CREATE ROLLBACK SEGMENT r0 TABLESPACE rollback;
SQL> CREATE ROLLBACK SEGMENT r1 TABLESPACE rollback;
SQL> ALTER ROLLBACK SEGMENT t0 OFFLINE;
SQL> DROP ROLLBACK SEGMENT t0;

SQL> CREATE USER <username> IDENTIFIED BY <password>
        DEFAULT TABLESPACE data TEMPORARY TABLESPACE temp
        QUOTA UNLIMITED ON data;
SQL> GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE,
        CREATE ROLLBACK SEGMENTS, CREATE VIEW TO <username>;

SQL> CONNECT <username>/<password>

the user 'antonio' work with the r0-r1 rollback segments ??

tanks ...

-- 
#include <stdio.h>
int main(void){char c[]={10,65,110,116,111,110,105,111,32,98,97,114,98,111,110,
101,32,60,104,105,110,100,101,109,105,116,64,116,105,115,99,97,108,105,110,101,
116,46,105,116,62,10,10,0};printf("%s",c);return 0;}

Received on Tue Nov 22 2005 - 02:51:36 CST