Starting up Oracle with "missing" datafiles

From: Charlie Mengler <charliem_at_mwh.com>
Date: Mon, 15 Jan 2001 10:52:54 -0800
Message-Id: <10742.126706@fatcity.com>

After a clean DB shutdown, I want to grap a copy of just the single file holding the SYSTEM tablespace and the controlfiles associated with an instance; let's call it "PROD".

I move these files onto another system and now I want to start this instance WITHOUT any of the associated "data files" containing all the data.

After I
svrmgrl
connect internal
startup mount

What do I do for each of the tablespace I wish to eliminate from this instance before issuing the following command

alter database open

TIA!

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct   
858-831-2229                  San Diego, CA 92131    
HOME DEPOT - The Big Boy's Toy store!!!!!!!!!!!!!!!!!

Received on Mon Jan 15 2001 - 12:52:54 CST