Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlplus: create database

sqlplus: create database

From: Antonio 6sette <bottesini_at_libero.it>
Date: Mon, 21 Nov 2005 17:04:16 +0000 (UTC)
Message-ID: <dlsumg$r0j$2@area.cu.mi.it>


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 ...

-- 
#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 Mon Nov 21 2005 - 11:04:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US