I am migrating from 7.3.4 to 8.1.6 (Enterprise Edition) on Solaris 2.8 Before running the migration I took all the tablespaces except SYSTEM and Rollback offline as recommended. When I issued "Alter database open resetlogs;" I got the following message for almost every file in the database: File #3 is offline, but part of an online tablespace. Successfully brought file #3 online. Can anyone explain this error please? Oracle support is saying that all the files should have been offline, and if not the migration must be restarted. TIA!! Stephen Warkentien Senior Database Administrator, Information Technology Northrop Grumman Guidance and Control Systems Division 5500 Canoga Avenue M/S W91 Woodland Hills CA 91367-6698 818-715-2860 voice 818-715-2617 FAX mailto:[EMAIL PROTECTED] http://sonworshipper.net/techpage.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Warkentien, Stephen 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).
