I thinks get the point.
My question is when you create a new instance in the same machine (or database) do I have to include the system file and rollback segment in the script to generate the database. Or the new instance uses the same system file and rollback segments.
I just wonder (has not specified in the documentation) the system tablespace for rcat database.
When I create a small database like rcat do I have to create a separate system tablespace or can I skipp the creation of system tablespace including all the views and data dictionary again. The target database has the same info, if so do I have to the target database up and runnig all the time for using the data dictionary and views and all the information and what happens to the information stored in the datafiles of system tablespace.
The question was generally asked.
My problem today is if I cant use the same size of system tablespace of the target database and wonder how mush disk space AS MINIMUM do I need for system tablespace for 8.1.5 version to get the required function of system tablespace for rcat.
I seems you have never created a database before otherwise you would never ask such a question. Without system tablespace you cannot have a database in Oracle. A tablespace can belong to only and only one database.
Take a print out of Concepts Guide, take a leave for a week read it throughly. Without knowing the concepts i wonder how you going to backup and recover your PROD database. This is no joke, but a serious advice for you if you want to keep your job as a DBA. And do not forget to read the Backup and Recovery Concepts guide as well.