| Create Rollback Tablespace [message #177307] |
Wed, 14 June 2006 01:39  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
hi,
i am using oracle8i in solaris
now i want to create a RBS tablespace and make it availablein oracle8i,
in oracle9i i know to create as
create undo tablespace undo1 datafile 'filename' size 20m;
and we should use "alter system set undo_tablespace=undo1" to make it available.
but in oracle8i i dont know how to create and make it available.
do we need to create as follows or any other option is there to create
create rbs tablespace rbs01 datafile 'filename' size 20m; likewise ........
and how to make it available
anyone's reply in this is greatly appriciated
with regards
Boo
|
|
|
|
| Re: Create Rollback Tablespace [message #177310 is a reply to message #177307] |
Wed, 14 June 2006 02:19  |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
|
In Oracle8i you must at first to create simple tablespace(you can call him RBS), and after that to create manually rollback segments wich must be placed in this tablespace(In Oracle9i with atomatic undo this step makes autimatically). Also you must to set parameters of rollback segements correctly to your system, because work with system can become drastically, or impossible.
|
|
|
|
|
|
| Re: Create Rollback Tablespace [message #178266 is a reply to message #177314] |
Tue, 20 June 2006 06:48 |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
the following are the commands to create rollback segments on tablespace RBS
create rollback segment rbs1 tablespace RBS
or else
create rollback segment rbs1 tablespace RBS
storage(initital 10k next 10k minextent 2 maxextent unlimited)
Thanks,
Shahnaz
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
