Thanks all for your responses. I'll go by "the order doesn't matter".
Let's see if I can hose up our dev DB with this now... ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > Sent: Thursday, April 11, 2002 3:13 PM > To: Multiple recipients of list ORACLE-L > > > I'm writing a Perl script to automate the procedure to create > a copy of an > 8.1.7 production DB to a development server. Both production > and dev are > HP/UX 11.0. > > In doing this, I've created a file that cross-references where the > production datafiles are and where they are to be placed in dev. This > works > fine, but I also wanted to dynamically create the CREATE CONTROLFILE > statement for the "new" dev DB. > > I've noticed that the DATAFILE clause does not have the > SYSTEM tablespace's > datafile first, nor are any of the other datafiles in the > same order that > they are in production (e.g. from the output of an ALTER SYSTEM BACKUP > CONTROLFILE TO TRACE). Does this matter? Does the order need to be > preserved? > > I suppose I'll end up dynamically creating the > cross-reference file, which > would preserve the order, but now I'm curious. > > TIA! > > Rich Jesse System/Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).