Re: Tablespace limitations
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/07/10
Message-ID: <Pine.SUN.3.91.950710095036.29989A-100000_at_seatimes>#1/1
Date: 1995/07/10
Message-ID: <Pine.SUN.3.91.950710095036.29989A-100000_at_seatimes>#1/1
On 6 Jul 1995 swisshelm_at_lilly.com wrote:
> 1. ALTER SYSTEM BACKUP CONTROLFILE TO TRACE;
> 2. Edit trace file to remove misc junk, and to change the value for maxdatafiles.
> 3. Shutdown your database.
> 4. Take a backup (just in case)
And remove the existing control files!
> 5. Startup the database NOMOUNT
> 6. Connect internal and run the CREATE CONTROLFILE command.
> 7. ALTER DATABASE OPEN; (You may need to say RESETLOGS too, I forget)
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Mon Jul 10 1995 - 00:00:00 CEST