Re: sqlplus: create database

Antonio 6sette wrote:
> hello,
>
> sorry for my english. I try to create manually a database in Oracle 9i. I don't
> understand this step:
>
> CREATE TABLESPACE rollback DATAFILE '....' ....
>
> /***************/
> CREATE ROLLBACK SEGMENT t0;
> ALTER ROLLBACK SEGMENT t0 ONLINE;
> SET TRANSACTION USE ROLLBACK SEGMENT t0;
> CREATE ROLLBACK SEGMENT r0 TABLESPACE rollback;
> CREATE ROLLBACK SEGMENT r1 TABLESPACE rollback;
> ALTER ROLLBACK SEGMENT t0 OFFLINE;
> DROP ROLLBACK SEGMENT t0;
> /***************/
>
> if I try to create directly the rollback segments r0 - r1 I have an error !!
> why ??
>
> tanks in advance ...

If 9i then you should not be using rollback segments and ROLLBACK is a reserved word so should not be used under any conditions.

Go to the Oracle docs and look up UNDO and UNDO TABLESPACE.

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)